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

help / color / mirror / Atom feed
From: Greg Smith <gsmith@gregsmith.com>
To: Bryce Nesbitt <bryce2@obviously.com>
Cc: Pgsql Hackers <pgsql-hackers@postgresql.org>
Subject: Re: New pg_dump patch, --no-stats flag, disables sending to statistics collector
Date: Tue, 20 Jan 2009 17:13:53 -0500 (EST)
Message-ID: <Pine.GSO.4.64.0901201633160.21742@westnet.com> (raw)
In-Reply-To: <49763C47.7070400@obviously.com>
References: <483FD205.4090904@sigaev.ru>
	<486BC501.6060605@sigaev.ru>
	<27880.1215810535@sss.pgh.pa.us>
	<487A6E0C.3090600@sigaev.ru>
	<8993.1216843701@sss.pgh.pa.us>
	<4888A594.6010102@sigaev.ru>
	<490B07BA.6030109@sigaev.ru>
	<492F04D9.5070404@enterprisedb.com>
	<4942A137.3000502@sigaev.ru>
	<1229910966.2285.76.camel@jdavis>
	<49708008.8070109@sigaev.ru>
	<1232348905.7281.114.camel@jdavis>
	<4974B002.3040202@sigaev.ru>
	<1232474489.23316.8.camel@jdavis>
	<49763C47.7070400@obviously.com>

On Tue, 20 Jan 2009, Bryce Nesbitt wrote:

> This patch adds another flag to pg_dump, this time to disable statistics 
> collection.

You can pass session parameters to anything that uses the standard libpq 
library using PGOPTIONS.  See 
http://www.postgresql.org/docs/8.3/static/config-setting.html for a 
sample.  I suspect that something like:

PGOPTIONS='-c stats_block_level=false -c stats_row_level=false' pg_dump

would do the same thing as your patch without having to touch the code.

That's a pretty obscure bit of information though, and it would be 
worthwhile to update the documentation suggesting such a syntax because I 
think this would be handy for a lot of people.  I was already planning to 
do that for another use case (pgbench) once the 8.4 work here shifts from 
development to testing and I have some more time for writing.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD



view thread (9+ messages)  latest in thread

Message-ID: <Pine.GSO.4.64.0901201633160.21742@westnet.com>
Permalink:  ../Pine.GSO.4.64.0901201633160.21742@westnet.com/
Also on:    postgresql.org/message-id/Pine.GSO.4.64.0901201633160.21742@westnet.com

 · 

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-patches@postgresql.org
  Cc: gsmith@gregsmith.com, bryce2@obviously.com, pgsql-hackers@postgresql.org
  Subject: Re: New pg_dump patch, --no-stats flag, disables sending to statistics collector
  In-Reply-To: <Pine.GSO.4.64.0901201633160.21742@westnet.com>

* 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