From: Jeff Davis <pgsql@j-davis.com>
To: Sergio Mayoral <mayoralstuttgart@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: execution time for first INSERT
Date: Fri, 08 Jul 2011 17:40:23 -0700
Message-ID: <1310172023.5376.4.camel@jdavis-ux.asterdata.local> (raw)
In-Reply-To: <1310124189.79849.YahooMailClassic@web39303.mail.mud.yahoo.com>
References: <1310124189.79849.YahooMailClassic@web39303.mail.mud.yahoo.com>
On Fri, 2011-07-08 at 04:23 -0700, Sergio Mayoral wrote:
> this must be something with the parser stage and since i am doing
> every time the same queries, I would like to know if there is a way to
> cache these queries in order to speed up the first INSERT.
I doubt it's the parser.
Seeing as it's around a couple ms at minimum, it's probably some kind of
IO latency. You could see that by wrapping the statements in a big
transaction (BEGIN/END block) -- I bet the inserts go very quickly and
the final commit takes longer.
Regards,
Jeff Davis
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: pgsql@j-davis.com, mayoralstuttgart@yahoo.com
Subject: Re: execution time for first INSERT
In-Reply-To: <1310172023.5376.4.camel@jdavis-ux.asterdata.local>
* 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