"Dann Corbit" <DCorbit(at)connx(dot)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