Re: Pre-alloc ListCell's optimization

Stephen Frost <sfrost@snowman.net>

From: Stephen Frost <sfrost@snowman.net>

To: Robert Haas <robertmhaas@gmail.com>

Cc: pgsql-hackers@postgresql.org

Date: 2012-05-18T22:19:52Z

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

* 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.

	Thanks,

		Stephen