I do have a performance problem, and it is due to I/O bottleneck.
We don't have pg_stat_statements installed, we will check it out.
Thanks
On Mon, Sep 30, 2013 at 8:44 PM, Jeff Janes wrote:
> On Mon, Sep 30, 2013 at 5:45 AM, Xenofon Papadopoulos wrote:
>
>> I am trying to understand the heap_b
On Mon, Sep 30, 2013 at 5:45 AM, Xenofon Papadopoulos wrote:
> I am trying to understand the heap_blks_read and heap_blks_hit of
> pg_statio_all_tables in 9.2
> Do the numbers refer only to SELECT, or they take INSERT into account?
>
They take insert (and update, and delete) into account.
> Wou
Il 30/09/2013 16:41, Xenofon Papadopoulos ha scritto:
Should this ratio stay low even in the case of a write-heavy table?
Yes, in my opinion. Before data manipolation, database pages are moved
on the shared buffer. heap_blks_read and heap_blks_hit are involved in
those operations, not directl
Hello Giuseppe,
do you actually mean I have a *poorly-cached *database?
Should this ratio stay low even in the case of a write-heavy table?
On Mon, Sep 30, 2013 at 5:40 PM, Giuseppe Broccolo <
giuseppe.brocc...@2ndquadrant.it> wrote:
> Hi Xenofon,
>
> Il 30/09/2013 14:45, Xenofon Papadopoulos h
Hi Xenofon,
Il 30/09/2013 14:45, Xenofon Papadopoulos ha scritto:
I am trying to understand the heap_blks_read and heap_blks_hit of
pg_statio_all_tables in 9.2
Do the numbers refer only to SELECT, or they take INSERT into account?
heap_blks_read and heap_blks_hit refer to number of blocks rea
I am trying to understand the heap_blks_read and heap_blks_hit of
pg_statio_all_tables in 9.2
Do the numbers refer only to SELECT, or they take INSERT into account?
Would a heap_blks_read / ( heap_blks_read + heap_blks_hit ) ration of over
55% combined with a heap_blks_read value of over 50M indica
