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" <[EMAIL PROTECTED]> 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 : [EMAIL PROTECTED] > >>tél : 01 69 29 36 18 > >>-------------------------------------------------------------------------- > >> > >> > >----------------- > > > > > >> > >> > >> > > > > > >-----Original Message----- > >From: [EMAIL PROTECTED] > >[mailto:[EMAIL PROTECTED] > 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 - [EMAIL PROTECTED] - > 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
