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 PeReiRASent: 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 aroundhttp://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