RE: Bad estimates

From: "Alex Ignatov" <a(dot)ignatov(at)postgrespro(dot)ru>
To: "'Don Seiler'" <don(at)seiler(dot)us>, 'Artur Zając' <azajac(at)ang(dot)com(dot)pl>
Cc: <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: RE: Bad estimates
Date: 2017-11-22 15:05:11
Message-ID: 137f101d363a3$4b226240$e16726c0$@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

It doesn’t help in this case.

--

Alex Ignatov
Postgres Professional: <http://www.postgrespro.com> http://www.postgrespro.com
The Russian Postgres Company

From: Don Seiler [mailto:don(at)seiler(dot)us]
Sent: Wednesday, November 22, 2017 5:49 PM
To: Artur Zając <azajac(at)ang(dot)com(dot)pl>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Bad estimates

I'm assuming you never analyzed the table after creation & data load? What does this show you:

select * from pg_stat_all_tables where relname='xyz';

Don.

--

Don Seiler
www.seiler.us <http://www.seiler.us>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2017-11-22 15:07:26 Re: Query became very slow after 9.6 -> 10 upgrade
Previous Message Tom Lane 2017-11-22 15:01:57 Re: Bad estimates