pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Sergei Kornilov <sk@zsrv.org>
Cc: Julien Rouhaud <rjuju123@gmail.com>
Cc: legrand legrand <legrand_legrand@hotmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Planning counters in pg_stat_statements (using pgss_store)
Date: Fri, 6 Sep 2019 16:27:48 +0200
Message-ID: <20190906142748.rheb64oypbjz4naz@development> (raw)
In-Reply-To: <20190906141916.etcdgjc66peyy4y5@development>
References: <1553726396218-0.post@n3.nabble.com>
	<7091891553759108@iva3-2961a207771d.qloud-c.yandex.net>
	<CAOBaU_YsFEKmU31JVjnuxkTgAPYaSKrKmCUh6Ea1EM_10=n3CQ@mail.gmail.com>
	<CAOBaU_abWF8Q-qKr3f6Q1M3MN7nVrfvwF6P105C-kCds85Lzww@mail.gmail.com>
	<1554150919882-0.post@n3.nabble.com>
	<CAOBaU_aYyZ2GEyb4QTmrE9O5k0C1n0aDLbRCaH771sSn0eq7VA@mail.gmail.com>
	<DB6PR0301MB2135811EFF4391A031339D5690560@DB6PR0301MB2135.eurprd03.prod.outlook.com>
	<CAOBaU_bP3VN6O20kpuHX595HSmHhVS_DEXSCiMEFQrrDyLNBZA@mail.gmail.com>
	<33867131567613987@iva1-adac53ff5c48.qloud-c.yandex.net>
	<20190906141916.etcdgjc66peyy4y5@development>

On Fri, Sep 06, 2019 at 04:19:16PM +0200, Tomas Vondra wrote:
>
>FWIW I've done some benchmarking on this too, with a single pgbench client
>running select-only test on a tiny database, in different modes (simple,
>extended, prepared). I've done that on two systems with different CPUs
>(spreadsheet with results attached).
>

And of course, I forgot to attach the spreadsheet, so here it is.

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachments:

  [application/vnd.oasis.opendocument.spreadsheet] planning.ods (52.0K, ../20190906142748.rheb64oypbjz4naz@development/2-planning.ods)
  download

view thread (127+ messages)  latest in thread

Message-ID: <20190906142748.rheb64oypbjz4naz@development>
Permalink:  ../20190906142748.rheb64oypbjz4naz@development/
Also on:    postgresql.org/message-id/20190906142748.rheb64oypbjz4naz@development

 · 

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-hackers@postgresql.org
  Cc: tomas.vondra@2ndquadrant.com, sk@zsrv.org, rjuju123@gmail.com, legrand_legrand@hotmail.com
  Subject: Re: Planning counters in pg_stat_statements (using pgss_store)
  In-Reply-To: <20190906142748.rheb64oypbjz4naz@development>

* 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