Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eHWad-0000iC-0f for pgsql-performance@arkaria.postgresql.org; Wed, 22 Nov 2017 15:05:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eHWac-0007TL-EB for pgsql-performance@arkaria.postgresql.org; Wed, 22 Nov 2017 15:05:26 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eHWab-0007T8-N7 for pgsql-performance@lists.postgresql.org; Wed, 22 Nov 2017 15:05:26 +0000 Received: from mail.postgrespro.ru ([93.174.131.138]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1eHWaP-0000eT-Ge for pgsql-performance@lists.postgresql.org; Wed, 22 Nov 2017 15:05:24 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id 4388921C176B; Wed, 22 Nov 2017 18:05:10 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru Received: from inferno (unknown [192.168.27.1]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id 1170021C0644; Wed, 22 Nov 2017 18:05:10 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1511363110; bh=S0K1jRmG6HqHTIdFLkZg8TfHoqgMiBDPYtGeT5jrLFM=; h=From:To:Cc:References:In-Reply-To:Subject:Date; b=CjFR3Q4Qy1f4/Vv9oCT517xqdwZ8X27VwLfLSvSRKIdw4R3jYdhWHyTkD4ADolMlD ubB86kMwCmOCg2LFffL0XYtKTCmKucmaMbWNqq5XREuVJIq6zUk/rAW5wmcpbHjANE 2n5zCWhOwMr6dzDrpaJ8cz3LqwPpLRoJjlbC2N+c= From: "Alex Ignatov" To: "'Don Seiler'" , =?utf-8?Q?'Artur_Zaj=C4=85c'?= Cc: References: <03b401d3639e$5d7493a0$185dbae0$@ang.com.pl> In-Reply-To: Subject: RE: Bad estimates Date: Wed, 22 Nov 2017 18:05:11 +0300 Message-ID: <137f101d363a3$4b226240$e16726c0$@postgrespro.ru> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_137F2_01D363BC.70700F70" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQFq/2zJcyt7SdRYqyFnDZAxwQ8iGwJm5PdMo94QgXA= Content-Language: ru List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_137F2_01D363BC.70700F70 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable It doesn=E2=80=99t help in this case. =20 -- Alex Ignatov=20 Postgres Professional: = http://www.postgrespro.com=20 The Russian Postgres Company =20 From: Don Seiler [mailto:don@seiler.us]=20 Sent: Wednesday, November 22, 2017 5:49 PM To: Artur Zaj=C4=85c Cc: pgsql-performance@lists.postgresql.org Subject: Re: Bad estimates =20 I'm assuming you never analyzed the table after creation & data load? = What does this show you: =20 select * from pg_stat_all_tables where relname=3D'xyz'; =20 Don. =20 --=20 Don Seiler www.seiler.us =20 ------=_NextPart_000_137F2_01D363BC.70700F70 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

It = doesn=E2=80=99t help in this case.

Alex Ignatov =
Postgres Professional: 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=C4=85c = <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=3D'xyz';

Don.

-- =

Don Seiler
www.seiler.us

------=_NextPart_000_137F2_01D363BC.70700F70--