Re: [PERFORM] problem with select count(*) ..

2003-11-19 Thread Bruno Wolff III
On Thu, Nov 20, 2003 at 07:07:30 +0530, Rajesh Kumar Mallah <[EMAIL PROTECTED]> wrote: > > If i dump and reload the performance improves and it takes < 1 sec. This > is what i have been doing since the upgrade. But its not a solution. > > The Vacuum full is at the end of a loading batch SQL fil

[PERFORM] problem with select count(*) ..

2003-11-18 Thread Rajesh Kumar Mallah
Ever Since i upgraded to 7.4RC2 i am facing problem with select count(*) . In 7.3 the problem was not there select count(*) from data_bank.profiles used to return almost instantly , but in 7.4 explain analyze SELECT count(*) from data_bank.profiles;