| From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Reasonable Configuration |
| Date: | 2003-09-08 07:00:05 |
| Message-ID: | 3F5C764D.15358.1450251F@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 7 Sep 2003 at 10:42, Alex wrote:
> Hi,
> the postgres configuration file is somewhat confusing to me and I could
> not find a good tutorial on how to configure the db.
>
> I have a single and dual processor machine, 1GB of memory.
> The database is a couple of GB, about 10Million records.
> The system runs batch jobs that can be quite heave. Users connect via
> Tomcat.
>
> What would be reasonable figures for
>
> - shared_buffers
> - wall_buffere3s
> - sort_mem
> - vacuum_mem
> - effective_chachesize
>
> these are the ones that come into my mind.
Check http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
HTH
Bye
Shridhar
--
Either one of us, by himself, is expendable. Both of us are not. -- Kirk,
"The Devil in the Dark", stardate 3196.1
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2003-09-08 08:18:31 | Re: Unix domain instead of TCP socket connections with |
| Previous Message | Nigel J. Andrews | 2003-09-08 06:44:24 | Re: tsearch CVS and differences to version for 7.3.x |