pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <greg@2ndquadrant.com>
To: André Volpato <andre.volpato@ecomtecnologia.com.br>
Cc: Brad Nicholson <bnichols@ca.afilias.info>
Cc: pgsql-performance@postgresql.org
Subject: Re: AIX slow buffer reads
Date: Wed, 27 Oct 2010 15:24:25 -0400
Message-ID: <4CC87C69.5070301@2ndquadrant.com> (raw)
In-Reply-To: <1141414014.10692.1288199109474.JavaMail.root@zimbra01a>
References: <1141414014.10692.1288199109474.JavaMail.root@zimbra01a>

André Volpato wrote:
> | 
> | If it is being spent in the bitmap index scan, try setting
> | effective_io_concurrency to 0 for Linux, and see what effect that has.
>
> I disabled effective_io_concurrency at AIX but it made no changes on bitmap index times.
>   

Brad's point is that it probably doesn't do anything at all on AIX, and 
is already disabled accordingly.  But on Linux, it is doing something, 
and that might be contributing to why it's executing so much better on 
that platform.  If you disable that parameter on your Debian box, that 
should give you an idea whether that particular speed-up is a major 
component to the difference you're seeing or not.

Also, if the system check was done by the "vendor team" team, don't 
trust them at all.  It doesn't sound like a disk problem is involved in 
your case yet, but be sure to do your own basic disk benchmarking too 
rather than believing what you're sold.  There's a quick intro to that 
at http://www.westnet.com/~gsmith/content/postgresql/pg-disktesting.htm 
and a much longer treatment of the subject in my book if you want a lot 
more details.  I don't have any AIX-specific tuning advice in there though.

-- 
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services and Support        www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books




view thread (13+ messages)  latest in thread

Message-ID: <4CC87C69.5070301@2ndquadrant.com>
Permalink:  ../4CC87C69.5070301@2ndquadrant.com/
Also on:    postgresql.org/message-id/4CC87C69.5070301@2ndquadrant.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: greg@2ndquadrant.com, andre.volpato@ecomtecnologia.com.br, bnichols@ca.afilias.info
  Subject: Re: AIX slow buffer reads
  In-Reply-To: <4CC87C69.5070301@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox