Re: Minmax indexes (timings)

Kevin Grittner <kgrittn@ymail.com>

From: Kevin Grittner <kgrittn@ymail.com>

To: Erik Rijkers <er@xs4all.nl>, "alvherre@2ndquadrant.com" <alvherre@2ndquadrant.com>

Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2013-11-15T16:33:56Z

Lists: pgsql-hackers

Erik Rijkers <er@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

Commits

Refactor per-page logic common to all redo routines to a new function.
- f8f4227976a2 9.5.0 cited
Reduce use of heavyweight locking inside hash AM.
- 76837c1507cb 9.3.0 cited
Scan the buffer pool just once, not once per fork, during relation drop.
- ece01aae4792 9.2.0 cited
Major patch from Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov>
- 9e2a87b62db8 7.1.1 cited