| From: | Thom Brown <thom(at)linux(dot)com> |
|---|---|
| To: | Andrus <kobruleht2(at)hot(dot)ee> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition |
| Date: | 2010-09-29 10:29:27 |
| Message-ID: | AANLkTikXw66V7NoMAAWu2EEmqcJR42P5O7MRy6PTeZS7@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2010/9/29 Andrus <kobruleht2(at)hot(dot)ee>:
> I installed PostgreSql 9.0 Win 64 standard distro.
>
> Stack builder offered in end of installation does not contain
> postgresql.conf optimization wizard.
>
> How to optimize postgresql.conf for 64 bit dedicated postgresql windows
> 2003 server or is default .conf file best for this?
It depends on how write-heavy the database will be, how much memory
you have to spare, and what sort of data you keep in it. I'm
absolutely certain you will need to alter the config from the
defaults. It's set up to be very conservative by default.
But take a look at http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2010-09-29 10:31:35 | Re: Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition |
| Previous Message | Leonardo Francalanci | 2010-09-29 10:21:39 | Re: Postgresql for a CEP app |