| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Peter Darley <pdarley(at)kinesis-cem(dot)com>, Pgsql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Stale temp tables |
| Date: | 2002-03-11 22:53:10 |
| Message-ID: | 20020312095310.B28330@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Mar 11, 2002 at 03:49:22PM -0500, Bruce Momjian wrote:
> Peter Darley wrote:
> > Friends,
> > I've got a whole bunch (8,000 or so) of old stale temp tables that were the
> > result of a hung backend. I can see them using pgAdmin II, but not through
> > psql. Is there any way to dump these guys, should I dump them, are they
> > likely to be causing problems? What should I do about this?
>
> Wow, that is a good question. You can stop the postmaster and start the
> 'postgres' binary with the -O option and drop them. -O is required
> because they are system tables.
Isn't this something VACUUM should be checking for? Assuming that it could
tell if a temporary table was still in use by another backend, it would be
possible for the system to go through the data directory and delete any
temporary tables not in use.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org>
http://svana.org/kleptog/
> If the company that invents a cure for AIDS is expected to make their
> money back in 17 years, why can't we ask the same of the company that
> markets big-titted lip-syncing chicks and goddamn cartoon mice?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-03-11 22:57:28 | Re: Stale temp tables |
| Previous Message | Martijn van Oosterhout | 2002-03-11 22:39:22 | Re: A query or maybe programmatic? |