Have you looked at the Nagios XI & Core packages?
https://www.nagios.com/solutions/postgres-monitoring/
On 02/23/2018 12:31 PM, Daulat Ram wrote:
Hello team,
I need help how & what we can monitor the Postgres database via Nagios.
I came to know about the check_postgres.pl script but we
Greetings,
* l...@laurent-hasson.com (l...@laurent-hasson.com) wrote:
> > * l...@laurent-hasson.com (l...@laurent-hasson.com) wrote:
> > > This was done during a maintenance window, and that table is read-only
> > except when we ETL data to it on a weekly basis, and so I was just wondering
> > why
> -Original Message-
> From: Stephen Frost [mailto:sfr...@snowman.net]
> Sent: Friday, February 23, 2018 19:10
> To: l...@laurent-hasson.com
> Cc: pgsql-performance@lists.postgresql.org
> Subject: Re: Updating large tables without dead tuples
>
> Greetings,
>
> * l...@laurent-hasson.com (
Sorry for delay with response, I had to switch to other tasks and didn't
have time to run proper tests and write some meaningful response.
Recently, a similar issue happened with another our database, so I
decided to write an update.
Bitmap scan was preferred to index scan by the planner, bu
