Skip site navigation (1) Skip section navigation (2)

Re: Tables and Indexes

From: MaRCeLO PeReiRA <gandalf_mp(at)yahoo(dot)com(dot)br>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>,pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Tables and Indexes
Date: 2004-10-28 14:25:30
Message-ID: 20041028142530.59365.qmail@web52705.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
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/

In response to

pgsql-general by date

Next:From: Sally SallyDate: 2004-10-28 14:31:32
Subject: Re: primary key and existing unique fields
Previous:From: Joshua D. DrakeDate: 2004-10-28 14:07:33
Subject: Re: Tables and Indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group