RE: BUG #17059: postgresql 13 version problem related to query.

Dear Tom,

Postgresql-12 have one year old data compare than postgresql-13 (postgresql-12 is QRD server and postgresql-13 is test server)
And same query we run is PRD postgresql-11 server data will come within 2-3 min.

Regards,
Ram Pratap.

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: 16 June 2021 01:25
To: Pavel Stehule
Cc: Ram Pratap Maurya; PostgreSQL mailing lists
Subject: Re: BUG #17059: postgresql 13 version problem related to query.

Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
> út 15. 6. 2021 v 21:36 odesílatel Ram Pratap Maurya <
> ram(dot)maurya(at)lavainternational(dot)in> napsal:
>> Postgresql-12 :
>> -> Index Scan using retailer_code_12390127_idx
>> on tretailer_mst retailerlist (cost=0.42..5468.67 rows=146923
>> width=25) (actual time=0.018..180.502 rows=144211 loops=1)
>>
>> Postgresql-13
>> -> Index Scan using
>> retailer_code_12390127_idx on tretailer_mst retailerlist
>> (cost=0.38..0.59
>> rows=1 width=684) (actual time=0.028..928.347 rows=221068 loops=1)

There seem to be rather serious discrepancies between rowcount estimates and reality on the v13 installation. Maybe an ANALYZE would help.

I'm also wondering why auto-analyze hasn't come along and improved the situation.

regards, tom lane