title: Why is count(*) taking extremely long in one PostgreSQL database but not another?
body: <p>I have two Postgres databases.  In one I have two tables, each with about 8,000,000 rows, and a count on either of them takes about a second.  In another database, also Postgres, there are tables that are 1,000,000 rows, and a count takes 10s, and one table thats about 6,000,000 rows, and count takes 3min to run.  What factors determine how long this will take?  They are on different machines, but the database that takes longer is on a faster machine.</p>
  
  <p>I've read about how postgres count is slow in general, but this seems odd to me.  I can't really use a workaround, because I am using django, and it does a count in the admin, which is taking forever and making it dificult to use.</p>
  
  <p>Any information on this would be helpful.</p>