Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Bad n_distinct estimation; hacks suggested? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: [HACKERS] Bad n_distinct estimation; hacks suggested?
Date
Msg-id 200505031752.54293.josh@agliodbs.com
Whole thread Raw
In response to Re: [HACKERS] Bad n_distinct estimation; hacks suggested?  (John A Meinel <john@arbash-meinel.com>)
List pgsql-performance
Tree view 
John,

> But doesn't an index only sample one column at a time, whereas with
> page-based sampling, you can sample all of the columns at once.

Hmmm.  Yeah, we're not currently doing that though.  Another good idea ...

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: John A Meinel
Date:
Subject: Re: [HACKERS] Bad n_distinct estimation; hacks suggested?
Next
From: Chris Hebrard
Date:
Subject: Kernel Resources and max_connections