From: | Nicolai Petri <nicolai(at)catpipe(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: More thoughts about planner's cost estimates |
Date: | 2006-06-02 09:01:30 |
Message-ID: | 200606021101.31487.nicolai@catpipe.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi All,
Just a small comment from a mortal user.
On Thursday 01 June 2006 19:28, Josh Berkus wrote:
> 5. random_page_cost (as previously discussed) is actually a funciton of
> relatively immutable hardware statistics, and as such should not need to
> exist as a GUC once the cost model is fixed.
It's correct that the hardware statistics are quite immutable - per
tablespace. This suggests to me that the GUC should be default value only and
then overridable per tablespace. It's quite normal to have primary (current
data) and secondary (historical data) storage for larger databases.
This can also fit nicely into the pg_tmp storage if tie support for multiple
tmp folders together with tablespaces.
>
> 6. We haven't added any way to estimate rows returned from SRFs.
This would also be very cool - currently the planner can really get annoyed
when joining SRF functions with tables.
---
Nicolai
From | Date | Subject | |
---|---|---|---|
Next Message | Larry Rosenman | 2006-06-02 09:09:37 | Re: Going for "all green" buildfarm results |
Previous Message | Peter Eisentraut | 2006-06-02 08:37:48 | Re: SET GLOBAL (todo) |