Hello, Not to mention upping your effective_cache. Doug McNaught wrote: Chris Cheston <[EMAIL PROTECTED]> writes:shared_buffers = 40 # min 16, at least max_connections*2, 8KB eachThis is ridiculously low for any kind of production server. Try something like 5000-10000 for a start. -Doug ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL |
- [PERFORM] postgres 7.4 at 100% Chris Cheston
- Re: [PERFORM] postgres 7.4 at 100% Richard Huxton
- Re: [PERFORM] postgres 7.4 at 100% Chris Cheston
- Re: [PERFORM] postgres 7.4 at 100% Doug McNaught
- Re: [PERFORM] postgres 7.4 at 100... Joshua D. Drake
- Re: [PERFORM] postgres 7.4 a... Chris Cheston
- Re: [PERFORM] postgres 7... Christopher Kings-Lynne
- Re: [PERFORM] postgr... Frank Knobbe
- Re: [PERFORM] postgr... Tom Lane
- Re: [PERFORM] postgr... Josh Berkus
- Re: [PERFORM] postgr... Chris Cheston
- Re: [PERFORM] postgr... Christopher Kings-Lynne
- Re: [PERFORM] postgr... Chris Cheston
- Re: [PERFORM] postgr... Bruno Wolff III
- Re: [PERFORM] postgr... Gavin M. Roy