Re: Need to increase performance of a query

From: Jesper Krogh <jesper(at)krogh(dot)cc>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Need to increase performance of a query
Date: 2010-06-10 18:12:41
Message-ID: 4C112B19.6080908@krogh.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 2010-06-10 19:50, Anne Rosset wrote:
> Any advice on how to make it run faster?

What timing do you get if you run it with \t (timing on) and without
explain analyze ?

I would be surprised if you can get it much faster than what is is.. I
may be that a
significant portion is "planning cost" so if you run it a lot you might
benefit from
a prepared statement.

--
Jesper

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message hubert depesz lubaczewski 2010-06-10 18:33:56 Re: Need to increase performance of a query
Previous Message Lacey Powers 2010-06-10 18:01:30 Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?