By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,541 Members | 1,476 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,541 IT Pros & Developers. It's quick & easy.

Reasonable Configuration

P: n/a
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.

I have allocated 512MB of the system memory to shmmax and shmall
Are there other parameters of the default config that need attention ?

Thanks
Alex

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 11 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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/Gener...bits/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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Browse more PostgreSQL Database Questions on Bytes