Re: Single client performance on trivial SELECTs

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Greg Smith" <greg(at)2ndquadrant(dot)com>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Joshua Berkus" <josh(at)agliodbs(dot)com>, "David Fetter" <david(at)fetter(dot)org>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Single client performance on trivial SELECTs
Date: 2011-04-15 21:33:38
Message-ID: 4DA87362020000250003C8DC@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Smith <greg(at)2ndquadrant(dot)com> wrote:

> I'm not sure exactly what is useful to be learned from that
> specific work. But it does suggest two things: one, this is far
> from an easy thing to fix. Two, the only reason MySQL does so
> well on it is because there was some focused work on it, taking a
> quite a while to accomplish, and involving many people. Doing
> better for PostgreSQL is something I see as more of a long-term
> goal, rather than something it would be reasonable to expect quick
> progress on.

Nice research. Thanks for putting that in front of people.

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2011-04-15 22:44:47 Re: WAL, xl_heap_insert and tuple oid mystry
Previous Message Tom Lane 2011-04-15 21:11:41 Re: regression test client encoding