Horton

Re: Proposal: roll pg_stat_statements into core

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread
From: Alvaro Herrera from 2ndQuadrant <alvherre@alvh.no-ip.org>
To: Euler Taveira <euler@timbira.com.br>
Cc: Adrien Nayrat <adrien.nayrat@anayrat.info>, Tom Lane <tgl@sss.pgh.pa.us>, David Fetter <david@fetter.org>, PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2019-09-05T16:07:55Z
Lists: pgsql-hackers 
On 2019-Sep-02, Euler Taveira wrote:

> At least if pg_stat_statements
> was in core you could load it by default and have a GUC to turn it
> on/off without restarting the server (that was Magnus proposal and
> Andres agreed). I support this idea.

Actually this is possible without moving to part of core, too -- change
things so that putting it in shared_preload_libraries reserves the shmem
area but does not enable collection, then have a separate GUC that
enables/disables collection.  A bit like archive_mode=on,
archive_command=/bin/true, which allows to change archive_command
without restarting.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services