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
On Thu, 2002-06-06 at 01:54, Sam Liddicott wrote:
> >
> > 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 running your current solution - maybe a comparison would be
> > worthwhile.
>
> -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
On Wed, 2002-06-05 at 21:02, Sam Liddicott wrote:
> >
> > When did you last do a vacuum? If you are adding and
> > dropping temporary
> > tables a lot, perhaps you should vacuum pg_class and
> > pg_attribute often
> > as well.
>
> I do a vacuum analyse every night on that whole DB, cron logs
On Fri, 2002-05-31 at 22:28, Sam Liddicott wrote:
> And when I do drop a table CPU usage goes to 99% on one CPU.
When did you last do a vacuum? If you are adding and dropping temporary
tables a lot, perhaps you should vacuum pg_class and pg_attribute often
as well.
Regards,
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 x;
runs quickly
