Re: Large table update/vacuum PLEASE HELP! - Mailing list pgsql-general

At 11:20 AM 4/16/02 -0400, Dmitry Tkach wrote:

>select * from a limit 1;
>
>Takes about 30 minutes and I have no idea what it is thinking about for so
>long!
>
>If anyone has anyu idea at all what could be the problem, PLEASE HELP!

If a is still something like:

create table a
(
    id int primary key,
    some_data int
);

Try:

vacuum analyze;
explain select * from a order by id limit 1;
select * from a order by id limit 1;

Hopefully the results are good.

Good luck,
Link.