Tables and Indexes

**Patrick Fiche** · Nov 23 '05, 02:43 AM

Re: Tables and Indexes

Hi,

I think that TABLESPACE is what you need...
It's now available in Postgresql, just look at the syntax in documentation.

[color=blue]
> --------------------------------------------------------------------------[/color]
-----------------[color=blue]
> Patrick Fiche
> email : patrick.fiche@a qsacom.com
> tél : 01 69 29 36 18
> --------------------------------------------------------------------------[/color]
-----------------[color=blue]
>
>
>[/color]

-----Original Message-----
From: pgsql-general-owner@postgresq l.org
[mailto:pgsql-general-owner@postgresq l.org]On Behalf Of MaRCeLO PeReiRA
Sent: jeudi 28 octobre 2004 15:04
To: pgsql
Subject: [GENERAL] Tables and Indexes

Hi guys,

Is there a way I can separate things in PostgreSQL?
Putting tables in a disk partition and indexes in
another one?????

Regards,

MaRcELo PeReiRa
PHP/SQL/PostgreSQL

_______________ _______________ _______________ _____
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

Yahoo Mail | Email with smart features and top-notch security

http://mail.yahoo.com

Yahoo Mail: Your smarter, faster, free email solution. Organize your inbox, protect your privacy, and tackle tasks efficiently with AI-powered features and robust security tools.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Protected by Polesoft Lockspam

http://www.polesoft.com/refer.html

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

PostgreSQL: PostgreSQL Mailing List Archives

http://archives.postgresql.org

**Joshua D. Drake** · Nov 23 '05, 02:43 AM

Re: Tables and Indexes

Patrick Fiche wrote:
[color=blue]
>Hi,
>
>I think that TABLESPACE is what you need...
>It's now available in Postgresql, just look at the syntax in documentation.
>
>[/color]
Actually it is only available in Beta. You will have to wait a little
while longer for stable release.

Sincerely,

Joshua D. Drake

[color=blue]
>
>
>[color=green]
>>--------------------------------------------------------------------------
>>
>>[/color]
>-----------------
>
>[color=green]
>>Patrick Fiche
>>email : patrick.fiche@a qsacom.com
>>tél : 01 69 29 36 18
>>--------------------------------------------------------------------------
>>
>>[/color]
>-----------------
>
>[color=green]
>>
>>
>>[/color]
>
>
>-----Original Message-----
>From: pgsql-general-owner@postgresq l.org
>[mailto:pgsql-general-owner@postgresq l.org]On Behalf Of MaRCeLO PeReiRA
>Sent: jeudi 28 octobre 2004 15:04
>To: pgsql
>Subject: [GENERAL] Tables and Indexes
>
>
>Hi guys,
>
>Is there a way I can separate things in PostgreSQL?
>Putting tables in a disk partition and indexes in
>another one?????
>
>Regards,
>
>MaRcELo PeReiRa
>PHP/SQL/PostgreSQL
>
>______________ _______________ _______________ ______
>Do You Yahoo!?
>Tired of spam? Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>
>
>
>Protected by Polesoft Lockspam
>http://www.polesoft.com/refer.html
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>[/color]

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandpromp t.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

**MaRCeLO PeReiRA** · Nov 23 '05, 02:43 AM

Re: Tables and Indexes

Hi,

Even in Beta, it is just fine to me!

When I create a index, the tablespace used is the
table's tablespace, unless I use the tablespace clause
to put it in another one. It is ok, I have read
documentation and learned that.

I was looking for a default configuration, so ALL the
indexes created will be put in a tablespace, and the
tables in another one, without using tablespace
clause. So, I start the postmaster, create two
tablespaces, configure it to put some things in one,
and some other things in another, and after that I
create my tables, indexes and view the natural way.

(hey, how many times did I write the word 'tablespace'
in this e-mail??? hehehhe)

Regards,

Marcelo

--- "Joshua D. Drake" <jd@commandprom pt.com>
escreveu:[color=blue]
> Patrick Fiche wrote:
>[color=green]
> >Hi,
> >
> >I think that TABLESPACE is what you need...
> >It's now available in Postgresql, just look at the[/color]
> syntax in documentation.[color=green]
> >
> >[/color]
> Actually it is only available in Beta. You will have
> to wait a little
> while longer for stable release.
>
> Sincerely,
>
> Joshua D. Drake
>
>
>[color=green]
> >
> >
> >[/color]
>[color=green]
>>--------------------------------------------------------------------------[color=darkred]
> >>
> >>[/color]
> >-----------------
> >
> >[color=darkred]
> >>Patrick Fiche
> >>email : patrick.fiche@a qsacom.com
> >>tél : 01 69 29 36 18[/color][/color]
>[color=green]
>>--------------------------------------------------------------------------[color=darkred]
> >>
> >>[/color]
> >-----------------
> >
> >[color=darkred]
> >>
> >>
> >>[/color]
> >
> >
> >-----Original Message-----
> >From: pgsql-general-owner@postgresq l.org
> >[mailto:pgsql-general-owner@postgresq l.org]On[/color]
> Behalf Of MaRCeLO PeReiRA[color=green]
> >Sent: jeudi 28 octobre 2004 15:04
> >To: pgsql
> >Subject: [GENERAL] Tables and Indexes
> >
> >
> >Hi guys,
> >
> >Is there a way I can separate things in PostgreSQL?
> >Putting tables in a disk partition and indexes in
> >another one?????
> >
> >Regards,
> >
> >MaRcELo PeReiRa
> >PHP/SQL/PostgreSQL
> >
> >______________ _______________ _______________ ______
> >Do You Yahoo!?
> >Tired of spam? Yahoo! Mail has the best spam[/color]
> protection around[color=green]
> >http://mail.yahoo.com
> >
> >---------------------------(end of[/color]
> broadcast)---------------------------[color=green]
> >TIP 8: explain analyze is your friend
> >
> >
> >
> >
> >Protected by Polesoft Lockspam
> >http://www.polesoft.com/refer.html
> >
> >
> >---------------------------(end of[/color]
> broadcast)---------------------------[color=green]
> >TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
> >[/color]
>
>
> --
> Command Prompt, Inc., home of Mammoth PostgreSQL -
> S/ODBC and S/JDBC
> Postgresql support, programming shared hosting and
> dedicated hosting.
> +1-503-667-4564 - jd@commandpromp t.com -
> http://www.commandprompt.com
> PostgreSQL Replicator -- production quality
> replication for PostgreSQL
>
>[/color]

_______________ _______________ _______________ __________
Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

PostgreSQL: PostgreSQL Mailing List Archives

http://archives.postgresql.org

Tables and Indexes

Tables and Indexes

Comment

Comment

Comment