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

From: "Arjen van der Meijden" <acm(at)tweakers(dot)net>
To: <chris(at)hutchinsonsoftware(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 'best practises' to speed up sorting? tuning postgresql.conf
Date: 2003-06-28 11:58:09
Message-ID: 001001c33d6c$9590c140$3ac15e91@acm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Thomas Swan 2003-06-30 05:49:39 Re: Memory question
Previous Message Shridhar Daithankar 2003-06-28 11:37:52 Re: 'best practises' to speed up sorting? tuning postgresql.conf