Re: turn off caching for performance test - Mailing list pgsql-performance

From Pierre C
Subject Re: turn off caching for performance test
Date
Msg-id op.vh128jb5eorkce@apollo13
Whole thread Raw
In response to turn off caching for performance test  (Willy-Bas Loos <willybas@gmail.com>)
Responses Re: turn off caching for performance test
List 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...

pgsql-performance by date:

Previous
From: Arjen van der Meijden
Date:
Subject: Re: turn off caching for performance test
Next
From: "Maria L. Wilson"
Date:
Subject: [Fwd: postgres 8.4.1 number of connections]