Postgres Pro
Downloads
Home   >   mailing lists

Re: estimation problems for DISTINCT ON with FDW - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: estimation problems for DISTINCT ON with FDW
Date
Msg-id CAMkU=1wmJZurcaaUCzefosBuLMn_dHAFESPijvU99VAMHnH+HQ@mail.gmail.com
Whole thread Raw
In response to Re: estimation problems for DISTINCT ON with FDW  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view
On Fri, Jul 3, 2020 at 5:50 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:

OK, I'll go ahead and push the patch I proposed yesterday.

Thank you.  I tested 12_STABLE with my real queries on the real data set, and the "hard coded" estimate of 200 distinct rows (when use_remote_estimte is turned back on) is enough to get rid of the worst plans I was seeing in 12.3.

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Default setting for enable_hashagg_disk
Next
From: Jeff Davis
Date:
Subject: Re: Default setting for enable_hashagg_disk