Skip site navigation (1) Skip section navigation (2)

Re: postgres 7.4 at 100%

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Doug McNaught <doug(at)mcnaught(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgres 7.4 at 100%
Date: 2004-06-26 14:11:49
Message-ID: 40DD8425.3080108@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hello,

Not to mention upping your effective_cache.

Doug McNaught wrote:

>Chris Cheston <ccheston(at)gmail(dot)com> writes:
>
>  
>
>>shared_buffers = 40             # min 16, at least max_connections*2, 8KB each
>>    
>>
>
>This 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 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2004-06-26 14:45:57
Subject: Re: How can one see what queries are running withing a
Previous:From: Doug McNaughtDate: 2004-06-26 13:32:08
Subject: Re: postgres 7.4 at 100%

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group