Re: Timing of 'SELECT 1' - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Timing of 'SELECT 1'
Date
Msg-id 3066.1078899196@sss.pgh.pa.us
Whole thread Raw
In response to Timing of 'SELECT 1'  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Timing of 'SELECT 1'
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: Use "average field correlation per hard disk
Next
From: Peter Eisentraut
Date:
Subject: Re: cvs breakage