Postgres Pro
Downloads
Home   >   mailing lists

Re: statistics horribly broken for row-wise comparison - Mailing list pgsql-hackers

From Tom Lane
Subject Re: statistics horribly broken for row-wise comparison
Date
Msg-id 1692.1236043756@sss.pgh.pa.us
Whole thread Raw
In response to statistics horribly broken for row-wise comparison  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: statistics horribly broken for row-wise comparison
List pgsql-hackers
Tree view 
Merlin Moncure <mmoncure@gmail.com> writes:
> It looks like for row-wise comparison, only the first column is used
> for generating the expected row count.

[ shrug... ]  Short of multi-column statistics, it's hard to see how to
do better.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Bryce Cutt
Date:
Subject: Re: Proposed Patch to Improve Performance of Multi-BatchHash Join for Skewed Data Sets
Next
From: Robert Haas
Date:
Subject: Re: GIN, partial matches, lossy bitmaps