-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wed, 12 Mar 2008 21:55:18 -0700 Craig James <craig_james@xxxxxxxxxxxxxx> wrote: > Diffs from original configuration: > > max_connections = 1000 > shared_buffers = 400MB > work_mem = 256MB > max_fsm_pages = 1000000 > max_fsm_relations = 5000 > wal_buffers = 256kB > effective_cache_size = 4GB I didn't see which OS but I assume linux. I didn't see postgresql so I assume 8.3. wal_sync_method = open_sync checkpoint_segments = 30 shared_buffers = 2000MB asyncrhonous_commit = off (sp?) Try again. Thanks this is useful stuff! Joshua D. Drake > - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL political pundit | Mocker of Dolphins -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFH2MHsATb/zqfZUUQRAqqtAJsEa8RkJbpqY2FAYSrNVHhvTK/GBgCfYzYD 9myRDV7AYXq+Iht7rIZVZcc= =PLpQ -----END PGP SIGNATURE----- -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-performance
