From: Theo Kramer <theo@flame.co.za>
To: pgsql-performance@postgresql.org
Subject: Re: Performance problems with prepared statements
Date: Wed, 10 Oct 2007 22:08:30 +0200
Message-ID: <1192046910.2549.25.camel@fedmac> (raw)
In-Reply-To: <36e682920710101255n5760a009v8fdbf42e4599f16f@mail.gmail.com>
References: <1192027540.2495.3.camel@localhost.localdomain>
<36e682920710101255n5760a009v8fdbf42e4599f16f@mail.gmail.com>
On Wed, 2007-10-10 at 15:55 -0400, Jonah H. Harris wrote:
> On 10/10/07, Theo Kramer <theo@flame.co.za> wrote:
> > When running the query directly from psql it returns the required rows
> > in less than 100 milli-seconds.
> >
> > However, when using a prepared statement from my C application on the
> > above query and executing it the query duration is as follows
> > ...
> > Row[s] = 25, Duration = 435409.474 ms
> >
>
> How are you timing it? Does it really take 435 seconds to complete?
Fraid so - and I am running postgresql on a separate machine from the
client machine - with the load going way up on the postgresql machine
and the client machine remains idle until the query returns.
Also the postgresql has only the one prepared statement executing during
my tests.
> Try the following in psql:
Did that - see my previous email.
--
Regards
Theo
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: theo@flame.co.za
Subject: Re: Performance problems with prepared statements
In-Reply-To: <1192046910.2549.25.camel@fedmac>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox