Erik Jones wrote:
It would be nice to get pg_dump activity out of the stats for another
reason --- pg_dump adds to the sequential scan activity, in a way
that does not represent the "typical" use of the database.
Essentially pg_dump is an atypical user of the database, so it's
stats are "different" than the rest of the activity.
It sounds like the proper wording for a feature request here would be
something like "Disable stats collection on a per-session basis".
And based on that, I found it's possible. I just had to teach pg_dump
to do it:
http://archives.postgresql.org/pgsql-hackers/2009-01/msg01474.php
(we'll see if anyone else finds it useful enough to commit the patch to
postgres 8.5).
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
