| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: slow query performance |
| Date: | 2003-10-30 13:53:10 |
| Message-ID: | 20031030135310.A5152@bacon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 |
+------------------------------+---------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff | 2003-10-30 14:29:11 | Re: slow query performance |
| Previous Message | Dave Weaver | 2003-10-30 13:49:46 | Re: slow query performance |