Postgres Pro
Downloads
Home   >   mailing lists

Re: speeding up COUNT and DISTINCT queries - Mailing list pgsql-performance

From Joe Conway
Subject Re: speeding up COUNT and DISTINCT queries
Date
Msg-id 3E6FE59E.1050602@joeconway.com
Whole thread Raw
In response to Re: speeding up COUNT and DISTINCT queries  (Max Baker <max@warped.org>)
Responses Re: speeding up COUNT and DISTINCT queries  (Max Baker <max@warped.org>)
List pgsql-performance
Tree view 
Max Baker wrote:
> Thanks for the help.  I guess i'm not clear on why there is so much
> extra cruft.  Does postgres leave a little bit behind every time it does
> an update?  Because this table is updated constantly.
>

Yes. See:
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/routine-vacuuming.html

Joe

pgsql-performance by date:

Previous
From: Max Baker
Date:
Subject: Re: speeding up COUNT and DISTINCT queries
Next
From: Max Baker
Date:
Subject: Re: speeding up COUNT and DISTINCT queries