| From: | Curt Sampson <cjs(at)cynic(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Andrew Sullivan <andrew(at)libertyrms(dot)info>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Disk Utilization Increases And Time for Vacuum Increases. |
| Date: | 2003-08-28 03:23:04 |
| Message-ID: | Pine.NEB.4.51.0308281212410.1359@angelic-vtfw.cvpn.cynic.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 27 Aug 2003, Tom Lane wrote:
> Curt Sampson <cjs(at)cynic(dot)net> writes:
> > While we're at it, anybody got a clue on how to reindex system tables?
> The procedure given in the REINDEX reference page doesn't work for you?
You mean with the standalone backend? All the other developers get
pissed at me when I take down the database cluster. :-) Heck, I get
pissed at me because some other thing I was running in the background
goes and blows up.
I'm not actually sure why there would be a problem (aside from
performance) in removing and rebuilding an index on a system table,
unless there are cached query plans somewhere that would try to use
the old or now-nonexistent index.
cjs
--
Curt Sampson <cjs(at)cynic(dot)net> +81 90 7737 2974 http://www.NetBSD.org
Don't you know, in this new Dark Age, we're all light. --XTC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-08-28 03:30:27 | Re: Disk Utilization Increases And Time for Vacuum Increases. |
| Previous Message | Tom Lane | 2003-08-28 03:07:13 | Re: Disk Utilization Increases And Time for Vacuum Increases. |