| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Gregory Stark <stark(at)enterprisedb(dot)com> |
| Cc: | jd(at)commandprompt(dot)com, Robert Haas <robertmhaas(at)gmail(dot)com>, Greg Smith <gsmith(at)gregsmith(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Simple postgresql.conf wizard |
| Date: | 2008-12-04 01:17:43 |
| Message-ID: | 20081204011743.GF18595@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Gregory Stark escribió:
> "Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> > I don't think at any time I have said to my self, I am going to set this
> > parameter low so I don't fill up my disk. If I am saying that to myself
> > I have either greatly underestimated the hardware for the task. Consider
> > that we are quarreling over what amounts to a nominal amount of hard
> > drive space, 1000 checkpoint_segments = 1.6G of space. My phone has more
> > capacity than that.
>
> Well my phone has 16G of RAM, why not 10000 ?
I don't think the disk space used is the only consideration here. You
also have to keep recovery time in mind. If you set it to 1000,
recovery would take way too long.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2008-12-04 01:18:01 | Re: Simple postgresql.conf wizard |
| Previous Message | Gregory Stark | 2008-12-04 01:15:04 | Re: Simple postgresql.conf wizard |