Horton

Re: Single client performance on trivial SELECTs

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joshua Berkus <josh@agliodbs.com>
Cc: David Fetter <david@fetter.org>, Greg Smith <greg@2ndquadrant.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-04-15T19:13:04Z
Lists: pgsql-hackers 
Joshua Berkus <josh@agliodbs.com> writes:
> Certainly any sacrifice of functionality in order to be faster at that kind of trivial workload would be foolhardy.

Yeah, and I'd further say that any sacrifice of maintainability would be
equally foolhardy.  In particular I'm repelled by David's proposal of a
whole parallel parse/plan/execute chain for "standard" datatypes
(whichever those are).

			regards, tom lane