Tables and Indexes

[MaRCeLO PeReiRA]

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

[Patrick Fiche]

Hi,

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

-------------------------------------------------------------------------- ----------------- Patrick Fiche
email : pa***********@aqsacom.com
tél : [phone]
-------------------------------------------------------------------------- -----------------

-----Original Message-----
From: pg*****************@postgresql.org
[mailto:pg*****************@postgresql.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

[Joshua D. Drake]

Patrick Fiche wrote:

Hi,

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

Actually it is only available in Beta. You will have to wait a little
while longer for stable release.

Sincerely,

Joshua D. Drake

--------------------------------------------------------------------------

-----------------

Patrick Fiche
email : pa***********@aqsacom.com
tél : [phone]
--------------------------------------------------------------------------

-----------------

-----Original Message-----
From: pg*****************@postgresql.org
[mailto:pg*****************@postgresql.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

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
[phone] - [e-mail] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

[MaRCeLO PeReiRA]

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" <[e-mail]>
escreveu:

Patrick Fiche wrote:

Hi,

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

syntax in documentation.

Actually it is only available in Beta. You will have
to wait a little
while longer for stable release.

Sincerely,

Joshua D. Drake

--------------------------------------------------------------------------

-----------------

Patrick Fiche
email : pa***********@aqsacom.com
tél : [phone]

--------------------------------------------------------------------------

-----------------

-----Original Message-----
From: pg*****************@postgresql.org
[mailto:pg*****************@postgresql.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

--
Command Prompt, Inc., home of Mammoth PostgreSQL -
S/ODBC and S/JDBC
Postgresql support, programming shared hosting and
dedicated hosting.
[phone] - [e-mail] -
http://www.commandprompt.com
PostgreSQL Replicator -- production quality
replication for PostgreSQL

__________________________________________________ _____
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?

http://archives.postgresql.org