Re: turn off caching for performance test

From: "Pierre C" <lists(at)peufeu(dot)com>
To: pgsql-performance(at)postgresql(dot)org, "Willy-Bas Loos" <willybas(at)gmail(dot)com>
Subject: Re: turn off caching for performance test
Date: 2010-08-26 17:37:21
Message-ID: op.vh128jb5eorkce@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> The bitmap heap scan is 3% faster,

3% isn't really significant. Especially if the new setting makes one query
100 times slower... Like a query which will, by bad luck, get turned into
a nested loop index scan for a lot of rows, on a huge table which isn't in
cache...

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Maria L. Wilson 2010-08-26 20:29:31 [Fwd: postgres 8.4.1 number of connections]
Previous Message Arjen van der Meijden 2010-08-26 16:50:11 Re: turn off caching for performance test