Re: Please help

2018-02-24 Thread PropAAS DBA
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

Re: Updating large tables without dead tuples

2018-02-24 Thread Stephen Frost
Greetings, * [email protected] ([email protected]) wrote: > > * [email protected] ([email protected]) 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

RE: Updating large tables without dead tuples

2018-02-24 Thread [email protected]
> -Original Message- > From: Stephen Frost [mailto:[email protected]] > Sent: Friday, February 23, 2018 19:10 > To: [email protected] > Cc: [email protected] > Subject: Re: Updating large tables without dead tuples > > Greetings, > > * [email protected] (

Re: Bitmap scan is undercosted?

2018-02-24 Thread Vitaliy Garnashevich
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