Read-only connectios optimizatios

Scenario: -PostgreSQL 13 latest version; -I have some reporting users, with "SELECT,REFERENCES" permissions on all tables in the public schema. -Connections are established using the jdbc "readonly" attribute. Does PostgreSQL perform any optimization on queries in this scenario to avoid establis

RES: Any way to speed up INSERT INTO

De: Andres Freund Enviado:sexta-feira, 4 de março de 2022 15:52 Para: pgsql-performance@lists.postgresql.org; Tom Lane; aditya desai Cc:Pgsql Performance

RES: Log number of tuples returned

De: Justin Pryzby<mailto:pry...@telsasoft.com> Enviado:quinta-feira, 29 de abril de 2021 12:08 Para: Edson Richter<mailto:edsonrich...@hotmail.com> Cc:pgsql-performance@lists.postgresql.org<mailto:pgsql-performance@lists.postgresql.org> Assunto: Re: Log number of tuples return

Log number of tuples returned

Hi! Which postgresql logging parameters should I activate to log the “number of tuples returned” for a query? I would like to debug some dynamicly generated queries in the system that are returning a absurd number of tuples (> 2,6mi of records). Thanks, ER Enviado do Email