"Dann Corbit" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
