Postgres Pro
Downloads
Home   >   mailing lists

Re: 'best practises' to speed up sorting? tuning postgresql.conf - Mailing list pgsql-performance

From Arjen van der Meijden
Subject Re: 'best practises' to speed up sorting? tuning postgresql.conf
Date
Msg-id 001001c33d6c$9590c140$3ac15e91@acm
Whole thread Raw
In response to 'best practises' to speed up sorting? tuning postgresql.conf  ("Chris Hutchinson" <chris@hutchinsonsoftware.com>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: 'best practises' to speed up sorting? tuning postgresql.conf
Next
From: Thomas Swan
Date:
Subject: Re: Memory question