Horton

Re: Single client performance on trivial SELECTs

Josh Berkus <josh@agliodbs.com>

View thread
From: Joshua Berkus <josh@agliodbs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: David Fetter <david@fetter.org>, Greg Smith <greg@2ndquadrant.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-04-15T16:59:40Z
Lists: pgsql-hackers 
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.

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

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
San Francisco