Re: Query performance with small data base

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>, Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Subject: Re: Query performance with small data base
Date: 2002-10-18 13:38:09
Message-ID: 16904.1034948289@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

pginfo <pginfo(at)t1(dot)unisoftbg(dot)com> writes:
> I think that the problem is in sorting.

Not according to the EXPLAIN results ... but did you change sort_mem?
The default value is kinda small.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Harding 2002-10-18 13:38:19 I Never Thought I Would See
Previous Message G.Nagarajan 2002-10-18 13:35:40 Re: Performance problem iterating a resultset