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.