Postgres Pro
Downloads
Home   >   mailing lists

Re: accounting for memory used for BufFile during hash joins - Mailing list pgsql-hackers

From Tom Lane
Subject Re: accounting for memory used for BufFile during hash joins
Date
Msg-id 27902.1557199108@sss.pgh.pa.us
Whole thread Raw
In response to Re: accounting for memory used for BufFile during hash joins  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: accounting for memory used for BufFile during hash joins  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Tree view 
Tomas Vondra <tomas.vondra@2ndquadrant.com> writes:
> Do we actually check how many duplicates are there during planning?

Certainly that's part of the planner's cost estimates ... but it's
only as good as the planner's statistical knowledge.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: reindexdb & clusterdb broken against pre-7.3 servers
Next
From: Tom Lane
Date:
Subject: Re: reindexdb & clusterdb broken against pre-7.3 servers