Thread: 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
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 : patrick.fiche@aqsacom.com > tél : 01 69 29 36 18 > -------------------------------------------------------------------------- ----------------- > > > -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@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
Patrick Fiche wrote:
Sincerely,
Joshua D. Drake
Actually it is only available in Beta. You will have to wait a little while longer for stable release.Hi, I think that TABLESPACE is what you need... It's now available in Postgresql, just look at the syntax in documentation.
Sincerely,
Joshua D. Drake
-------------------------------------------------------------------------------------------Patrick Fiche email : patrick.fiche@aqsacom.com tél : 01 69 29 36 18 ------------------------------------------------------------------------------------------------Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@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
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 : patrick.fiche@aqsacom.com > >>tél : 01 69 29 36 18 > >>-------------------------------------------------------------------------- > >> > >> > >----------------- > > > > > >> > >> > >> > > > > > >-----Original Message----- > >From: pgsql-general-owner@postgresql.org > >[mailto:pgsql-general-owner@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/