We've found pghero to be a good first line of defence. It doesn't have
alerting yet, but it's great for a quick high level healthcheck.
Also +1 for Datadog. Extremely flexible and elegant UI + powerful alerting
capabilities.
On Fri, May 26, 2017 at 10:32 AM, Sunkara, Amrutha
wrote:
> We have be
Are you already on SSDs? That will be the dominant factor I think. Then
memory After that, more cores are good for parallelism (especially with
9.6, although that requires solid memory support). Faster cores will be better
if you expect complex calculations in memory, i.e., some analytics pe
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
+1 for Datadog. It is highly configurable, but out of the box the
postgres integration collects a good amount of useful stuff. Tech
support is also good.
http://docs.datadoghq.com/integrations/postgresql/
Grant Evans
Enova Inc.
gev...@enova.com
On 5/26/17 5:19 AM, Rick Otten wrote:
On Thu
Hi Ravi,
We use the nagios to monitor the Postgresql Database . Nagios provide the
dedicated API for Postgresql and you can customize the same.
Thanks.
On May 26, 2017 1:19 AM, "Ravi Tammineni"
wrote:
> Hi,
>
>
>
> What is the best monitoring tool for Postgres database? Something like
> Oracle
> We use Zabbix.
There's a Zabbix template for PostgreSQL called "pg_monz".
http://pg-monz.github.io/pg_monz/index-en.html
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-performance mailing lis
Hi,
This is a general question around this performance area rather
than a specific performance problem.so I apologise now for a lack of a
specific detail.
We have an application that does many small actions on the DB -
and it's a small DB (a 50/100 Mbytes) s
Am 26.05.2017 um 14:31 schrieb Dinesh Chandra 12108:
Hi Thomas,
Thanks for your reply.
Yes, the query is absolutely same which I posted.
Please suggest if something need to change in query.
As Per your comment...
The query you posted includes there two join conditions:
evidence_to_do.
Hi Thomas,
Thanks for your reply.
Yes, the query is absolutely same which I posted.
Please suggest if something need to change in query.
As Per your comment...
The query you posted includes there two join conditions:
evidence_to_do.project_id = tool_performance.project_id
evidence_to_
On 05/25/2017 07:15 PM, Scott Mead wrote:
Thanks
ravi
We use Zabbix.
JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone
On Thu, May 25, 2017 at 3:48 PM, Ravi Tammineni <
rtammin...@partner.aligntech.com> wrote:
> Hi,
>
>
>
> What is the best monitoring tool for Postgres database? Something like
> Oracle Enterprise Manager.
>
>
>
> Specifically I am interested in tools to help:
>
>
>
> Alert DBAs to problems with bo
11 matches
Mail list logo