Re: slow query performance

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   |
+------------------------------+---------------------------------------------+