Re: Selecting a constant question - Mailing list 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