public inbox for pgsql-performance@postgresql.org
help / color / mirror / Atom feedFrom: Karl Czajkowski <karlcz@isi.edu>
To: Rick Otten <rottenwindfish@gmail.com>
Cc: Kevin.Hughes@uk.fujitsu.com <Kevin.Hughes@uk.fujitsu.com>
Cc: pgsql-performa. <pgsql-performance@postgresql.org>
Subject: Re: Client Server performance & UDS
Date: Tue, 30 May 2017 13:20:46 -0700
Message-ID: <20170530202046.GE7575@moraine.isi.edu> (raw)
In-Reply-To: <CAMAYy4K+a8E0sWrDY-1Zhp8WPM_89enkHq07wqx-XsrgjBhm3g@mail.gmail.com>
References: <d9852308baee4c33aa11b4b1d33c8dc3@R01UKEXCASM123.r01.fujitsu.local>
<CAMAYy4J1CrDfvTdSpx9zZ-aZ5W=AJmOPKBTRBhg9V69G7B_sjw@mail.gmail.com>
<da3dc4593d12498187a6429e39340185@R01UKEXCASM123.r01.fujitsu.local>
<CAMAYy4K+a8E0sWrDY-1Zhp8WPM_89enkHq07wqx-XsrgjBhm3g@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On May 30, Rick Otten modulated:
> If your clients are keeping persistent connections open to the
> database, and the latency you are experiencing is within the
> transaction itself, you might look at disk I/O for your WAL (write
> ahead logs) and take a closer look at WAL and checkpoint tuning.
>
Also, if you are doing similar operations over and over with literal
data in them, you may have more query planner overhead per transaction
than if you prepared statements when opening the persistent connection
and then simply executed the statements over and over with different
parameters for each request.
Karl
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
reply
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: karlcz@isi.edu, rottenwindfish@gmail.com, Kevin.Hughes@uk.fujitsu.com
Subject: Re: Client Server performance & UDS
In-Reply-To: <20170530202046.GE7575@moraine.isi.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox