Re: Single client performance on trivial SELECTs
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Fetter <david@fetter.org>
Cc: Greg Smith <greg@2ndquadrant.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-04-15T03:16:03Z
Lists: pgsql-hackers
David Fetter <david@fetter.org> writes: > On Thu, Apr 14, 2011 at 10:43:16AM -0400, Tom Lane wrote: >> ... I think a lot of this ultimately >> traces to the extensible, data-type-agnostic design philosophy. The >> fact that we don't know what an integer is until we look in pg_type, >> and don't know what an "=" operator does until we look up its >> properties, is great from a flexibility point of view; but this sort >> of query is where the costs become obvious. > Is it time to revisit that decision? Umm ... what are you proposing? Toss user-defined data types and user-defined operators overboard? No interest in that here. regards, tom lane