Re: Query performance

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: S Arvind <arvindwill(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query performance
Date: 2009-10-12 13:29:13
Message-ID: 2f4958ff0910120629n7390ad4cuc279eee3367ee1d7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

btw, what's the version of db ?
what's the work_mem setting ?

try setting work_mem to higher value. As postgresql will fallback to disc
sorting if the content doesn't fit in work_mem, which it probably doesn't
(8.4+ show the memory usage for sorting, which your explain doesn't have).

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2009-10-12 13:36:59 Re: Query performance
Previous Message S Arvind 2009-10-12 13:23:22 Re: Query performance