Re: severe performance issue with planner

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Eric Brown <bigwhitecow(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: severe performance issue with planner
Date: 2004-03-12 02:42:28
Message-ID: 40512394.2050506@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> if i first do prepare blah as SELECT ....., then run execute blah, the
> time goes down to about 275ms (i had been running this query a lot, and
> did a vacuum update before all this).

If you make it an SQL stored procedure, you get the speed up of the
PREPARE command, without having to prepare manually all the time.

Chris

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-03-12 04:07:13 Re: severe performance issue with planner
Previous Message Eric Brown 2004-03-12 01:47:23 severe performance issue with planner