Postgres Pro
Downloads
Home   >   mailing lists

Re: Really really slow select count(*) - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Really really slow select count(*)
Date
Msg-id AANLkTingr+vPHiBw38=SQxREYFkPe9OXu_kT2EqBxW7f@mail.gmail.com
Whole thread Raw
In response to Re: Really really slow select count(*)  (felix <crucialfelix@gmail.com>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: felix
Date:
Subject: Re: Really really slow select count(*)
Next
From: Shaun Thomas
Date:
Subject: Re: Really really slow select count(*)