Re: [PERFORM] 'best practises' to speed up sorting? tuning postgresql.conf

2003-06-28 Thread Arjen van der Meijden
> 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

Re: [PERFORM] 'best practises' to speed up sorting? tuning postgresql.conf

2003-06-28 Thread Shridhar Daithankar
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

[PERFORM] 'best practises' to speed up sorting? tuning postgresql.conf

2003-06-28 Thread Chris Hutchinson
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=