Re: Simple postgresql.conf wizard - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Simple postgresql.conf wizard
Date
Msg-id 23243.1227660267@sss.pgh.pa.us
Whole thread Raw
In response to Re: Simple postgresql.conf wizard  (Decibel! <decibel@decibel.org>)
List pgsql-hackers
Decibel! <decibel@decibel.org> writes:
> The thought occurs to me that we're looking at this from the wrong  
> side of the coin. I've never, ever seen query plan time pose a  
> problem with Postgres, even without using prepared statements.

That tells more about the type of queries you tend to run than about
whether there's an issue in general.

> Anyone  
> who actually cares that much about plan time is certainly going to  
> use prepared statements,

This is simply false.  There's a significant performance hit caused
by using prepared statements in many cases where the planner needs
to know the parameter values in order to make good decisions.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Column reordering in pg_dump
Next
From: KaiGai Kohei
Date:
Subject: Re: Updates of SE-PostgreSQL 8.4devel patches (r1197)