| From: | James Mansion <james(at)mansionfamily(dot)plus(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Claudio Freire <klaussfreire(at)gmail(dot)com>, Tomas Vondra <tv(at)fuzzy(dot)cz>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Performance |
| Date: | 2011-04-29 08:25:00 |
| Message-ID: | 4DBA75DC.6070506@mansionfamily.plus.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Robert Haas wrote:
> The server can and does measure hit rates for the PG buffer pool, but to my knowledge there is no clear-cut way for PG to know whether read() is satisfied from the OS cache or a drive cache or the platter.
>
>
Does the server know which IO it thinks is sequential, and which it
thinks is random? Could it not time the IOs (perhaps optionally) and at
least keep some sort of statistics of the actual observed times?
It might not be appropriate for the server to attempt auto-tuning, but
it might be able to provide some information that can be used by a DBA
to make informed decisions.
James
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2011-04-29 10:34:38 | Re: Will shared_buffers crash a server |
| Previous Message | Achilleas Mantzios | 2011-04-29 07:48:35 | Re: Will shared_buffers crash a server |