Re: [PERFORM] Monitoring tool for Postgres Database

2017-05-26 Thread Sunkara, Amrutha
We have been using Nagios to monitor the system level stats. The database level stats that we gather are custom scripts that we have nagios poll to get the database health. You could use pg badger to generate reports against your database logs as well. Pg_badger reports are your bffs for performanc

Re: [PERFORM] Improving PostgreSQL insert performance

2017-06-09 Thread Sunkara, Amrutha
Frits, When you use the copy command, are you doing anything special to get the run time that you are indicating? On Fri, Jun 9, 2017 at 10:39 AM, Frits Jalvingh wrote: > Hi all, > > Thanks a lot for the many responses! > > About preparing statements: this is done properly in Java, and pgsql do