Re: speeding up COUNT and DISTINCT queries

From: Joe Conway <mail(at)joeconway(dot)com>
To: Max Baker <max(at)warped(dot)org>
Cc: Manfred Koizar <mkoi-pg(at)aon(dot)at>, PostgreSQL Performance Mailing List <pgsql-performance(at)postgresql(dot)org>
Subject: Re: speeding up COUNT and DISTINCT queries
Date: 2003-03-13 01:57:50
Message-ID: 3E6FE59E.1050602@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Max Baker 2003-03-13 02:05:47 Re: speeding up COUNT and DISTINCT queries
Previous Message Max Baker 2003-03-13 01:55:40 Re: speeding up COUNT and DISTINCT queries