Re: Really really slow select count(*)

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: felix <crucialfelix(at)gmail(dot)com>
Cc: sthomas(at)peak6(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: Really really slow select count(*)
Date: 2011-02-04 18:33:38
Message-ID: AANLkTingr+vPHiBw38=SQxREYFkPe9OXu_kT2EqBxW7f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

You can run vacuum verbose on just the postgres database and get the
global numbers at the end. gotta be a superuser as well.

# \c postgres postgres
postgres=# vacuum verbose;
.... lots deleted.
DETAIL: A total of 7664 page slots are in use (including overhead).
7664 page slots are required to track all free space.
Current limits are: 1004800 page slots, 5000 relations, using 6426 kB.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shaun Thomas 2011-02-04 18:34:42 Re: Really really slow select count(*)
Previous Message felix 2011-02-04 18:14:00 Re: Really really slow select count(*)