Thies C Arntzen wrote:
i would be interested in getting this uncorrected count "after sort" but "before first row" in query (a). so in a fresh DB with no updates/deletes this would be the correct count, and i could avoid the very expensive (b).
You don't say what applicaton language you are using, but most offer a pg_num_rows() interface which tells you how many results are in the recordset you have fetched.
Your best bet to learn more is to read whatever documentation comes with your client library.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
