Re: Timing of 'SELECT 1'

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I am timing small queries, and found that a PREPARE/EXECUTE of "SELECT
> 1" takes about 1.2ms on my machine.  A normal SELECT doesn't take much
> longer, so I am wondering why a simpler query isn't faster.

Define "normal SELECT".  I can think of plenty of people who would be
overjoyed if their average SELECT was only a couple millisecs.
        regards, tom lane