News for hackers. Stuff that matters.
Re:PostgreSQL Rising by lobster_johnson on Friday July 20, 2012 @12:28PM (#4271534)
You can do a fast, conditionless count that ignores current transaction state and therefore risks being slightly out of date, but usually good enough for most use cases:

    select n_live_tup
    from pg_stat_user_tables
    where relname = 'mytable'
Re:PostgreSQL Rising by erichocean on Sunday July 22, 2012 @08:58PM (#4279062)
Way more people should be using this.