Postgres Pro
Downloads
Home   >   mailing lists

Re: reducing the overhead of frequent table locks - now, with WIP patch - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: reducing the overhead of frequent table locks - now, with WIP patch
Date
Msg-id 4DED2139.8060408@agliodbs.com
Whole thread Raw
In response to reducing the overhead of frequent table locks - now, with WIP patch  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: reducing the overhead of frequent table locks - now, with WIP patch  (Jignesh Shah <jkshah@gmail.com>)
Re: reducing the overhead of frequent table locks - now, with WIP patch  (Jignesh Shah <jkshah@gmail.com>)
List pgsql-hackers
Tree view 
> That's an improvement of about ~3.5x.  According to the vmstat output,
> when running without the patch, the CPU state was about 40% idle.
> With the patch, it dropped down to around 6%.

Wow!  That's fantastic.

Jignesh, are you in a position to test any of Robert's work using DBT or
other benchmarks?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Error in PQsetvalue
Next
From: Dimitri Fontaine
Date:
Subject: Re: reducing the overhead of frequent table locks - now, with WIP patch