Re: Minmax indexes (timings) - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Minmax indexes (timings)
Date
Msg-id 20131115162857.GE5489@awork2.anarazel.de
Whole thread Raw
In response to Re: Minmax indexes (timings)  ("Erik Rijkers" <er@xs4all.nl>)
List pgsql-hackers
On 2013-11-15 17:11:46 +0100, Erik Rijkers wrote:
> I've been messing with minmax indexes some more so here are some results of that.
> 
> Perhaps someone finds these timings useful.
> 
> 
> Centos 5.7, 32 GB memory, 2 quadcores.
> 
> '--prefix=/var/data1/pg_stuff/pg_installations/pgsql.minmax' '--with-pgport=6444' '--enable-depend'
'--enable-cassert'
> '--enable-debug' '--with-perl' '--with-openssl' '--with-libxml' '--enable-dtrace'

Just some general advice: doing timings with --enale-cassert isn't that
meaningful - it often can distort results significantly.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: writable FDWs / update targets confusion
Next
From: Kevin Grittner
Date:
Subject: Re: Minmax indexes (timings)