Re: Single client performance on trivial SELECTs

Joshua D. Drake <jd@commandprompt.com>

From: "Joshua D. Drake" <jd@commandprompt.com>
To: pgsql-hackers@postgresql.org
Date: 2011-04-15T17:30:55Z
Lists: pgsql-hackers
On 04/15/2011 09:59 AM, Joshua Berkus wrote:
> All,
>
> While it would be nice to improve our performance on this workload, let me point out that it's not a very important workload from the point of view of real performance challenges.  Yes, there are folks out there with 100MB databases who only run one-liner select queries.  But frankly, Valemort/Redis/Mongo are going to whip both our and MySQL's butts on that kind of workload anyway.

Yes but if we can kick MySQL's butt, that would certainly be a good 
thing. There are people (lots of people) that do not like the whole 
Valemort/Redis/Mongo paradigm.

> Certainly any sacrifice of functionality in order to be faster at that kind of trivial workload would be foolhardy.

Agreed.

JD