Re: [HACKERS] Minmax indexes (timings)

2013-11-15 Thread Andres Freund 
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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Minmax indexes (timings)

2013-11-15 Thread Kevin Grittner 
Erik Rijkers e...@xs4all.nl wrote:

 Perhaps someone finds these timings useful.

 '--enable-cassert'

Assertions can really distort the timings, and not always equally
for all code paths.  Any chance of re-running those tests without
that?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers