Re: Indices for select count(*)?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Alexander Scholz <alexander(dot)scholz1(at)freenet(dot)de>
Subject: Re: Indices for select count(*)?
Date: 2005-12-21 21:39:58
Message-ID: 200512212239.58696.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Mittwoch, 21. Dezember 2005 12:01 schrieb Alexander Scholz:
> So - what kind of indexing would speed this up then?

You can't speed up a full-table count using an index.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2005-12-21 21:42:54 Re: view or index to optimize performance
Previous Message Joshua D. Drake 2005-12-21 21:38:11 Re: Memory Question