I'm having an perplexing issue in PG 10.1 wherein deleting a large amount
of rows from a table causes query planning time to spike dramatically for a
while. This happens with or without autovacuums so vacuuming isn't the
issue.
CPU usage during this time spikes as well. I can't determine if the qu
On Wed, Feb 21, 2018 at 4:14 PM, Tom Lane wrote:
> Lucas Fairchild-Madar writes:
> > I'm having an perplexing issue in PG 10.1 wherein deleting a large amount
> > of rows from a table causes query planning time to spike dramatically
> for a
> > while. This happens w
On Wed, Feb 21, 2018 at 7:28 PM, Tom Lane wrote:
>
> > What is the planner doing when trying to find the current live max value
> of
> > the column?
>
> It's trying to estimate whether a mergejoin will be able to stop short of
> reading all the tuples from the other side of the join. (For instanc
