Re: Need to tune for Heavy Write

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Need to tune for Heavy Write
Date: 2011-08-04 15:07:21
Message-ID: CAOR=d=3HgwBfhHWQj9OvZkKkHsaZzSS+6=fELjG12EL-zRnBZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Aug 4, 2011 at 7:57 AM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
>> RAM : 16 GB
>
>> effective_cache_size = 4096MB
>
> That should probably be more like 12GB to 15GB.  It probably won't
> affect the load time here, but could affect other queries.

Actually on a heavily written database a large effective cache size
makes things slower.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2011-08-04 15:07:42 Re: Seq Scan vs. Index Scan
Previous Message Andy Colson 2011-08-04 13:57:59 Re: Parameters for PostgreSQL