From: Alex Ignatov <a.ignatov@postgrespro.ru>
To: 'Don Seiler' <don@seiler.us>
To: 'Artur Zając' <azajac@ang.com.pl>
Cc: pgsql-performance@lists.postgresql.org
Subject: RE: Bad estimates
Date: Wed, 22 Nov 2017 18:05:11 +0300
Message-ID: <137f101d363a3$4b226240$e16726c0$@postgrespro.ru> (raw)
In-Reply-To: <CAHJZqBCGV8Ke12RuOvZVs6E088UBY8CP=CoMQmJVfGEsM6yzDw@mail.gmail.com>
References: <03b401d3639e$5d7493a0$185dbae0$@ang.com.pl>
<CAHJZqBCGV8Ke12RuOvZVs6E088UBY8CP=CoMQmJVfGEsM6yzDw@mail.gmail.com>
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@seiler.us]
Sent: Wednesday, November 22, 2017 5:49 PM
To: Artur Zając <azajac@ang.com.pl>
Cc: pgsql-performance@lists.postgresql.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;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: a.ignatov@postgrespro.ru, don@seiler.us, azajac@ang.com.pl, pgsql-performance@lists.postgresql.org
Subject: RE: Bad estimates
In-Reply-To: <137f101d363a3$4b226240$e16726c0$@postgrespro.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox