From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Jan Wieck <JanWieck@Yahoo.com>
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: Stats collector performance improvement
Date: Mon, 02 Jan 2006 15:20:24 -0500
Message-ID: <11924.1136233224@sss.pgh.pa.us> (raw)
In-Reply-To: <200601021840.k02Ieed21704@candle.pha.pa.us>
References: <200601021840.k02Ieed21704@candle.pha.pa.us>
[ moving to -hackers ]
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I did some research on this because the numbers Tom quotes indicate there
> is something wrong in the way we process stats_command_string
> statistics.
> [ ... proposed patch that seems pretty klugy to me ... ]
I wonder whether we shouldn't consider something more drastic, like
getting rid of the intermediate stats buffer process entirely.
The original design for the stats communication code was based on the
premise that it's better to drop data than to make backends wait on
the stats collector. However, as things have turned out I think this
notion is a flop: the people who are using stats at all want the stats
to be reliable. We've certainly seen plenty of gripes from people who
are unhappy that backend-exit messages got dropped, and anyone who's
using autovacuum would really like the tuple update counts to be pretty
solid too.
If we abandoned the unreliable-communication approach, could we build
something with less overhead?
regards, tom lane
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: tgl@sss.pgh.pa.us, pgman@candle.pha.pa.us, JanWieck@Yahoo.com, pgsql-hackers@postgreSQL.org
Subject: Re: Stats collector performance improvement
In-Reply-To: <11924.1136233224@sss.pgh.pa.us>
* 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