Re: pg_stat_statements: improve loading and saving routines for the dump file

From: Sami Imseih <samimseih(at)gmail(dot)com>
To: Ivan Kush <ivan(dot)kush(at)tantorlabs(dot)com>
Cc: m(dot)litsarev(at)postgrespro(dot)ru, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: pg_stat_statements: improve loading and saving routines for the dump file
Date: 2025-01-21 21:22:08
Message-ID: CAA5RZ0u_Jt7LgTXDcbjyjeosSni2MEjhm=vr368GkB_Qk4aqzA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This will only reduce the size of the
$PGDATA/pg_stat/pg_stat_statements.txt file. Even with
100k entries, the most I have seen pg_stat_statements.max
set to, that will be less than 1 MB of disk saving. The default
config of 5k entries will be much less.

Regards,

Sami

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2025-01-21 21:26:52 Re: Proposal: "query_work_mem" GUC, to distribute working memory to the query's individual operators
Previous Message Oliver Ford 2025-01-21 21:14:55 Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options