On 5/18/07, Kenneth Marshall <[EMAIL PROTECTED]> wrote:
Make a summary table and select from there instead.
Yes, a summary table updated by triggers is the only way to have correct numbers... but you also pay the overhead of maintaining those numbers on every INSERT/UPDATE statement. If you just need *reasonable* guesstimates, use reltuples in pg_class after an analyze. -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 3rd Floor | [EMAIL PROTECTED] Iselin, New Jersey 08830 | http://www.enterprisedb.com/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
