From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
---|---|
To: | Douglas Alan <darkwater42(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Subject: | Re: What is the right way to deal with a table with rows that are not in a random order? |
Date: | 2009-05-28 22:39:57 |
Message-ID: | 1243550397.31652.26.camel@monkey-cat.sm.truviso.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 2009-05-28 at 15:12 -0400, Douglas Alan wrote:
> The most obvious solution would be an option to tell Postgres not to
> assume that the value is evenly distributed throughout the table, and
> to take account of the fact that the data in question might very well
> be clustered at the very end of the table.
There's no use adding a new statistic (user supplied or collected) to
PostgreSQL until we know that correlation isn't useful for that purpose.
Can you tell us the correlation that PostgreSQL has already collected (I
apologize if I missed this elsewhere in the thread)?
Hopefully, correlation is useful enough. With some planner tweaks
similar to the ones Tom mentioned, and a few more data points, maybe
we'll have a real solution.
Regards,
Jeff Davis
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-05-28 22:42:05 | Re: pg_stats.avg_width differs by a factor of 4 on different machines |
Previous Message | Craig de Stigter | 2009-05-28 22:12:22 | pg_stats.avg_width differs by a factor of 4 on different machines |