Foreign table scan estimates - Mailing list pgsql-hackers

From Albe Laurenz
Subject Foreign table scan estimates
Date
Msg-id D960CB61B694CF459DCFB4B0128514C207C34354@exadv11.host.magwien.gv.at
Whole thread Raw
Responses Re: Foreign table scan estimates  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
While playing around with ANALYZE on foreign tables, I noticed
that the row count estimate for foreign scans is still
initialized to 1000 even if there are statistics for the
foreign table.  I think that this should be improved.

The attached patch illustrates my suggestion.

BTW, ist there any other place where foreign table statistics
should or do enter the planning process?

Yours,
Laurenz Albe

Attachment

pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: Plan stability versus near-exact ties in cost estimates
Next
From: Tom Lane
Date:
Subject: Re: Plan stability versus near-exact ties in cost estimates