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>
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 |