| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Let's drop some GUCs (bgwriter) |
| Date: | 2005-08-23 15:50:51 |
| Message-ID: | 200508230850.51870.josh@agliodbs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Jim,
> But have you looked at how this affects response time, especially around
> checkpoints? Testing I've done shows that changing the variables in
> 8.0.3 can markedly reduce the impact of checkpoints. In many
> applications, maintaining low response times is more important than
> overall throughput, and that's where bgwriter tuning currently comes
> into play. Depending on hardware it may not be possible to simplify all
> these into a single number, either.
Hmmm ... can you give me the settings you used? I'd like to check the
response times.
--Josh
--
Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2005-08-23 15:55:00 | Re: Pre-allocated free space for row updating (like PCTFREE) |
| Previous Message | Kevin Grittner | 2005-08-23 15:44:05 | Fwd: Re: [GENERAL] Where to get 8.1 beta test version? |