Re: [PERFORM] Monitoring tool for Postgres Database

Hi Ravi, We, at Dalibo, are contributing to the postgres community mostly through open source administration tools development. Among them : - pgBadger, from Gilles Darold, extracts a lot of data from the postgres logs and restitutes them via a web interface (https://github.com/dalibo/pgbadg

Re: [PERFORM] Client Server performance & UDS

You should have a layer such as pgbouncer between your pg instance and your application. It is designed to mitigate the access latency issues you describe. On May 26, 2017 10:03 AM, "kevin.hug...@uk.fujitsu.com" < kevin.hug...@uk.fujitsu.com> wrote: > Hi, > > > > This is a genera

[PERFORM] Different plan between 9.6 and 9.4 when using "Group by"

Hi team: The following SQL is very slow in 9.6.1 for the plan has a “sort” node. SQL text: explain(analyze, buffers, verbose, timing)WITH m as (SELECT date,accumulation,prod_type,IF,plan_code, mapping_code, channel, VARIABLE, up_load_data FROM sdm_actu_fore_up_act_nb