On Wed, Dec 19, 2018 at 1:04 AM anand086 wrote:
>
> The Execution time for the above sql is 17841.467 ms during normal
> operations but when autovacuum runs on table test_table, the same sql took
> 1628495.850 ms (from the postgres log).
>
> We have noticed this increase in execution times for t
On Wed, 19 Dec 2018 at 19:04, anand086 wrote:
> We have noticed this increase in execution times for the sqls only when
> autovacuum runs and it runs with prevent wraparound mode. I think during the
> autovacuum process the Buffers: shared hit are increasing causing increase
> in execution time.
>
Hi All,
I am looking into a performance issue and needed your input and thoughts.
We have table (non-partitioned) of 500Gb with 11 indexes
+--+---+--+-+--+-++++
| row_estimate | total_bytes | inde
