By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,363 Members | 2,961 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,363 IT Pros & Developers. It's quick & easy.

Tables and Indexes

P: n/a
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

Nov 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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 : 01 69 29 36 18
-------------------------------------------------------------------------- -----------------

-----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

Nov 23 '05 #2

P: n/a
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 : 01 69 29 36 18
--------------------------------------------------------------------------

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



-----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.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
Nov 23 '05 #3

P: n/a
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@commandprompt.com>
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 : 01 69 29 36 18

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

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



-----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.
+1-503-667-4564 - jd@commandprompt.com -
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

Nov 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.