Horton

Re: Selecting a constant question

Gregory Stark <stark@enterprisedb.com>

View thread View on postgr.es
From: Gregory Stark <stark@enterprisedb.com>
To: "Dann Corbit" <DCorbit@connx.com>
Cc: <pgsql-hackers@postgresql.org>
Date: 2007-06-11T19:48:22Z
Lists: pgsql-hackers 
"Dann Corbit" <DCorbit@connx.com> writes:

> SELECT 1  FROM test.dbo.a_003 
>
> gets about 60,000 records per second
>
> SELECT '1'  FROM test.dbo.a_003 
>
> gets about 600 records per second.
>
> The cause is that postgres describes the return column as "unknown"
> length 65534 in the 2nd case.

Wait, back up. How does this cause it to go slower?

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com