Re: Slow count(*) again... - Mailing list pgsql-performance

From Samuel Gendler
Subject Re: Slow count(*) again...
Date
Msg-id AANLkTi=WE-CsGVC3j4CX9ddGGsRZ3Mmk6aJGKk4NT=g6@mail.gmail.com
Whole thread Raw
In response to Re: Slow count(*) again...  (Greg Smith <greg@2ndquadrant.com>)
Responses Re: Slow count(*) again...  (Scott Carey <scott@richrelevance.com>)
Re: Slow count(*) again...  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-performance


On Mon, Oct 11, 2010 at 7:19 PM, Greg Smith <greg@2ndquadrant.com> wrote:

This is a problem for the operating system to solve, and such solutions out there are already good enough that PostgreSQL has little reason to try and innovate in this area.  I routinely see seq scan throughput double on Linux just by tweaking read-ahead from the tiny defaults to a sane value.

I spent some time going through the various tuning docs on the wiki whie bringing some new hardware up and I can't remember seeing any discussion of tweaking read-ahead at all in the normal performance-tuning references.  Do you have any documentation of the kinds of tweaking you have done and its effects on different types of workloads?

pgsql-performance by date:

Previous
From: Neil Whelchel
Date:
Subject: Re: Slow count(*) again...
Next
From: Scott Carey
Date:
Subject: Re: Slow count(*) again...