Re: [GENERAL] How to improve query performance?

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] How to improve query performance?
Date: 1999-02-16 06:10:23
Message-ID: 36C90BCF.635BCC48@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The Hermit Hacker wrote:
>
> The table holds ~120k records right now, and the above query returns ~1100.
>
> To get a feel for the speed it returns, see http://www.hub.org/OS_Survey
>
> I can't think of any way to improve the speed, and yes, I do a 'vacuum
> analyze' on it periodically (did one just before the above EXPLAIN)...
>
> Other other note...its a v6.4.2 server, running on a PII with 384Meg of
> RAM and FreeBSD 3.0-STABLE...

What is -S (memory for sorting)? Try to use -S 8192 or -S 16384.

Vadim

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message dustin sallings 1999-02-16 06:18:57 Re: [GENERAL] How to improve query performance?
Previous Message The Hermit Hacker 1999-02-16 06:00:47 How to improve query performance?