From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | jim(at)contactbda(dot)com |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Justin Clift <justin(at)postgresql(dot)org>, shridhar_daithankar(at)persistent(dot)co(dot)in, PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>, Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
Subject: | Re: How to REINDEX in high volume environments? |
Date: | 2002-10-04 02:23:47 |
Message-ID: | 200210040223.g942Nlm25797@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)postgresql(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-10-04 02:26:30 | Re: floor function in 7.3b2 |
Previous Message | Bruce Momjian | 2002-10-04 02:21:27 | Return of INSTEAD rules |