Le mer. 11 janv. 2023 à 00:28, Ron a écrit :
> If your application *requires* subsecond response, and you're only
> getting subsecond response some of the time, then you obviously want to
> know why. Part of that is checking to see if the database and queries are
> doing their job.
>
now that l
Hi!
Happy new (gregorian calendar) year!
Somehow related to the proposal of having a `psql --idle` option, is there
a way to disallow the command `\!` (and anything of the likes in psql?
Sure, I can set the SHELL env var at run-time, but I still want to have
postgres user to be a normal user, wit
On 1/10/23 09:57, Alicja Kucharczyk wrote:
wt., 10 sty 2023 o 14:57 Ron napisał(a):
On 1/10/23 07:14, Alicja Kucharczyk wrote:
Do you know any use case for enabling log_duration? Like 3rd party
tools for instance.
I find this parameter pretty much useless (in opposite to
lo
wt., 10 sty 2023 o 14:57 Ron napisał(a):
> On 1/10/23 07:14, Alicja Kucharczyk wrote:
>
> Do you know any use case for enabling log_duration? Like 3rd party tools
> for instance.
> I find this parameter pretty much useless (in opposite to
> log_min_duration_statement) as it does not show the quer
Hi there,
Could you please advise on the best opensource monitoring tool for
Postgresql?
Thanks & Best Regards
Vikas
On 1/10/23 07:14, Alicja Kucharczyk wrote:
Do you know any use case for enabling log_duration? Like 3rd party tools
for instance.
I find this parameter pretty much useless (in opposite to
log_min_duration_statement) as it does not show the query text, so besides
having just the timing logged it
On 1/9/23 22:51, Martin Ritchie wrote:
Are there any limits on the number of records in
the postgresql/12/main/pg_multixact/members directory? We have a database
that has grown to tens of thousands of files in this directory during an
autovacuum after a large data purge. It shrank after the aut
Do you know any use case for enabling log_duration? Like 3rd party tools
for instance.
I find this parameter pretty much useless (in opposite to
log_min_duration_statement) as it does not show the query text, so besides
having just the timing logged it is of no use in troubleshooting and often
caus
