Re: Tables and Indexes

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(at)commandprompt(dot)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(dot)fiche(at)aqsacom(dot)com
> >>tél : 01 69 29 36 18
>
>>--------------------------------------------------------------------------
> >>
> >>
> >-----------------
> >
> >
> >>
> >>
> >>
> >
> >
> >-----Original Message-----
> >From: pgsql-general-owner(at)postgresql(dot)org
> >[mailto:pgsql-general-owner(at)postgresql(dot)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(at)commandprompt(dot)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/