argdenis
argdenis

Reputation: 23

Can pg_stat_statements.max increase cause problems?

My production postgresql v11 db is "tenant" over schemas, so on each schema the objects are repeated so I have over 100k objects to track with pg_stat_statements, which is set 5000 by default. If I increase this number could cause me some overheads, bottlenecks, etc..

Upvotes: 0

Views: 180

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246093

The only effect is that the extension creates a bigger shared memory segment at server start – memory that may be missing elsewhere.

Upvotes: 1

Related Questions