Sorry for the delays on this that machine actually died recently and had to
be rebuit before I could do any more tests.
> > > It would be interesting to see the 'vacuum full analyze'
> > > results for the
> > > system tables in that DB, although perhaps less
> interesting while you
> > > are ru
> -Original Message-
> From: Andrew McMillan [mailto:[EMAIL PROTECTED]]
> Sent: 05 June 2002 12:58
> To: Sam Liddicott
> Cc: [EMAIL PROTECTED]
> Subject: RE: [BUGS] drop tempoary table VERY slow
>
> Interesting. Those are pretty long times to take for a
&g
> -Original Message-
> From: Andrew McMillan [mailto:[EMAIL PROTECTED]]
> Sent: 02 June 2002 11:52
> To: Sam Liddicott
> Cc: [EMAIL PROTECTED]
> Subject: Re: [BUGS] drop tempoary table VERY slow
>
>
> On Fri, 2002-05-31 at 22:28, Sam Liddicott wrote:
> &g
I have a DB where
this:
select 1 into
temporary table x;
runs quickly,
but
drop table
x;
takes many seconds
to run.
I don't know
why.
But:
begin;
select 1 into
temporary table x;
abort;
is very
quick.
Note the slow
dropping applies to automatic dropping of temporary tab
And
when I do drop a table CPU usage goes to 99% on one CPU.
Sam
-Original Message-From: Sam Liddicott
Sent: 31 May 2002 10:57To:
'[EMAIL PROTECTED]'Subject: drop tempoary table VERY
slow
I have a DB where
this:
select 1 into
temporary table
