> Chris Hutchinson wrote:
> I'm wondering how to speed up sorting which is slowing a
> query run regularly on a linux postgresql 7.3.3 system.
I see a lot of seq scans in your explain and there are no index scans,
have you done a 'vacuum analyze' lately?
Arjen
---(end
On Saturday 28 June 2003 17:01, Chris Hutchinson wrote:
> I'm wondering how to speed up sorting which is slowing a query run
> regularly on a linux postgresql 7.3.3 system.
>
> The box is a dual PIII with 1Gb ram. The database is located on a 20Gb SCSI
> disk, with WAL on a separate disk.
>
> The o
I'm wondering how to speed up sorting which is slowing a query run regularly
on a linux postgresql 7.3.3 system.
The box is a dual PIII with 1Gb ram. The database is located on a 20Gb SCSI
disk, with WAL on a separate disk.
The only changes I've made to postgresql.conf so far are:
shared_buffers=