| From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | Greg Smith <gsmith(at)gregsmith(dot)com> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Automatic adjustment of bgwriter_lru_maxpages |
| Date: | 2007-05-15 12:45:03 |
| Message-ID: | 4649AB4F.8050209@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches pgsql-performance |
Greg Smith wrote:
> I realized recently the task I should take on here is to run some more
> experiments with the latest code and pass along suggested techniques for
> producing/identifying the kind of problem conditions I've run into in
> the past; then we can see if other people can reproduce them. I got a
> new 8-core server I need to thrash anyway and will try and do just that
> starting tomorrow.
Yes, please do that. I can't imagine a situation where a tunable maximum
would help, but you've clearly spent a lot more time experimenting with
it than me.
I have noticed that on a heavily (over)loaded system with fully
saturated I/O, bgwriter doesn't make any difference because all the
backends need to wait for writes anyway. But it doesn't hurt either.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2007-05-15 13:18:11 | fixing uuid-ossp |
| Previous Message | Gregory Stark | 2007-05-15 11:33:47 | Invalid magic number in log file? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-05-15 13:07:18 | Re: [PATCHES] Autovacuum and XID wraparound |
| Previous Message | daveg | 2007-05-15 04:55:16 | Re: Automatic adjustment of bgwriter_lru_maxpages |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Drew Wilson | 2007-05-15 13:57:55 | Many to many join seems slow? |
| Previous Message | Richard Huxton | 2007-05-15 10:47:29 | Re: 500 requests per second |