From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Deferring some AtStart* allocations? |
Date: | 2014-10-09 21:03:48 |
Message-ID: | 20141009210348.GE6724@awork2.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2014-10-09 17:02:02 -0400, Robert Haas wrote:
> On Thu, Oct 9, 2014 at 3:53 PM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
> >> OK, here's an attempt at a real patch for that. I haven't perf-tested this.
> >
> > Neato. With a really trivial SELECT:
> >
> > before:
> > tps = 28150.794776 (excluding connections establishing)
> > after:
> > tps = 29978.767703 (excluding connections establishing)
> >
> > slightly more meaningful:
> >
> > before:
> > tps = 21272.400039 (including connections establishing)
> > after:
> > tps = 22290.703482 (excluding connections establishing)
> >
> > So that's a noticeable win. Obviously it's going to be less for more
> > complicated stuff, but still...
> >
> > I've not really looked at the patches though.
>
> Yeah, not bad at all for the amount of work involved. Want to
> disclose the actual queries?
SELECT 1;
SELECT * FROM smalltable WHERE id = xxx;
The latter is something quite frequent in the real world, so it's not
all academic...
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2014-10-09 21:10:42 | Re: Autovacuum fails to keep visibility map up-to-date in mostly-insert-only-tables |
Previous Message | Alvaro Herrera | 2014-10-09 21:03:00 | Re: Autovacuum fails to keep visibility map up-to-date in mostly-insert-only-tables |