Re: Pre-alloc ListCell's optimization

Bruce Momjian <bruce@momjian.us>

From: Bruce Momjian <bruce@momjian.us>

To: Stephen Frost <sfrost@snowman.net>

Cc: Robert Haas <robertmhaas@gmail.com>, pgsql-hackers@postgresql.org

Date: 2012-08-30T01:30:26Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Replace the parser's namespace tree (which formerly had the same
- a4996a895399 8.1.0 cited
Turns out that my recent elimination of the 'redundant' flatten_andors()
- 56c88772911b 8.1.0 cited

On Fri, May 18, 2012 at 06:19:52PM -0400, Stephen Frost wrote:
> * Stephen Frost (sfrost@snowman.net) wrote:
> > > llist_opt: 9289 tps
> > > HEAD:      9286 tps
> > 
> > llist_opt: 9407 tps
> > 
> > Which gives us ~1.3% improvment.
> 
> Trying out some different options- going with 32 pre-allocated
> ListCell's actually reduced performance, according to these tests.
> 
> Dropping it to 4 improved performance a bit: 9476 tps.
> 
> Going to keep playing around and see where this goes.

Any status on this?


-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +