Hi, > >A numrows() solution will be the quick way to a first version, but we may > >discover that the performance is terrible and 'SELECT COUNT(*)' is needed. [..] > The advantage is, that we can initalize more resultsets, not have to > allocate memory and not have to query count(*) statements.
Please never use 'SELECT COUNT(*)', the performance of Postgres' count(*) is horrible. 'explain analyze select count(*) from dbmail_messages' takes 600ms for my 60000 rows ... Thomas -- http://www.tmueller.com for pgp key (95702B3B)
