Re: slow query performance
От | Paul Thomas |
---|---|
Тема | Re: slow query performance |
Дата | |
Msg-id | 20031030135310.A5152@bacon обсуждение исходный текст |
Ответ на | Re: slow query performance (Shridhar Daithankar <shridhar_daithankar@myrealbox.com>) |
Список | pgsql-general |
On 30/10/2003 10:41 Shridhar Daithankar wrote: > Dave Weaver wrote: >> The version of Postgres that I'm running (7.1.3) doesn't seem to have a >> "vacuum full". >> >> I have reindexed after a vacuum, with liitle-to-no effect. > > If possible you should upgrade. 7.1.3 is rather old. But that shouldn't > mke that much difference ( I guess. Wasn't a postgresql user back > then..:-) > > Shridhar IIRC, vacuum on older versions of PG locked tables and was effectively what vacuum full is now. Looking at HISTORY, non-locking vacuum and vacuum full were introduced in 7.2. -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+
В списке pgsql-general по дате отправления: