Re: BUG #14858: Inaccurate estimations after bulk delete and bulk insert

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: stanislaw(dot)skonieczny(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14858: Inaccurate estimations after bulk delete and bulk insert
Date: 2017-10-16 16:27:39
Message-ID: 20171016162739.wglwr26sk7vzrlhh@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

stanislaw(dot)skonieczny(at)gmail(dot)com wrote:

> In our product we have found that PG is choosing full scan on a big table
> instead using indexes.
> This was caused caused by very inaccurate estimations of total number of
> rows in the table.

Stanislaw emailed the -owner address with the attached email.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomas Vondra 2017-10-16 16:32:57 Re: BUG #14853: Parameter type is required even when the query does not need to know the type
Previous Message Pavel Stehule 2017-10-16 15:49:12 Re: BUG #14853: Parameter type is required even when the query does not need to know the type