Re: How to REINDEX in high volume environments?

Jim, glad you are still around.  Yes, we would love to get tablespaces
in 7.4.  I think we need to think bigger and get something where we can
name tablespaces and place tables/indexes into these named spaces.  I
can reread the TODO.detail stuff and give you an outline.  How does that
sound?  Thomas Lockhart is also interested in this feature.

---------------------------------------------------------------------------

Jim Buttafuoco wrote:
> Just wanted to pipe in here.  I am still very interested in tablespaces ( I have many database systems that are over
> 500GB and growing) and am willing to port my tablespace patch to 7.4.  I have everything (but only tested here)
working
> in 7.2 but the patch was not accepted.  I didn't see a great speed improvement but the patch helps with storage
management.
> 
> Recap.  the patch would enable the following
> 
>     a database to have a default data tablespace and index tablespace
>     a user to have a default data and index tablespace
>     a table to have a specific tablespace
>     an index to have a specfic tablespace
> 
>     I would like to also add  namespace (schema) to have a default data and index tablespaces
> 
> Jim
> 
> 
> 
> 
> > Justin Clift <justin@postgresql.org> writes:
> > > Shridhar Daithankar wrote:
> > >> Looks like we should have a subdirectory in database directory which stores
> > >> index.
> > 
> > > That was my first thought also, but an alternative/additional approach
> > > would be this (not sure if it's workable):
> > 
> > See the tablespaces TODO item.  I'm not excited about building
> > half-baked versions of tablespaces before we get around to doing the
> > real thing ...
> > 
> >             regards, tom lane
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> > 
> > http://www.postgresql.org/users-lounge/docs/faq.html
> 
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073