Re: Large table update/vacuum PLEASE HELP!

On Tue, 2002-04-16 at 14:11, Dmitry Tkach wrote:
[snip]
> >
> > Try:
> >
> > vacuum analyze;
>
> Yeah... I did that yesterday... It took about 24 hours (!) to run... And
> I don't see any difference in the behaviour :-(
>
> >
> > explain select * from a order by id limit 1;
>
>
> Aha... This is an interesting thing to try. Thanks.
> Unfortunately, I can't try that right now either! :-(
> I am running 'vacuum full' on that table (out of despare), and, despite
[snip]

Just to be sure we all understand, you ran
  vacuum analyze;

you didn't just run vacuum or vacuum full

the analyze part is important; it creates statistics for the query
planner

--

Tom Jenkins
Development InfoStructure
http://www.devis.com