Home > mailing lists

Re: Indices for select count(*)? - Mailing list pgsql-general

From	Peter Eisentraut
Subject	Re: Indices for select count(*)?
Date	December 21, 2005 20:40:07
Msg-id	200512212239.58696.peter_e@gmx.net Whole thread Raw
In response to	Indices for select count(*)? (Alexander Scholz <alexander.scholz1@freenet.de>)
List	pgsql-general

Tree view

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.

pgsql-general by date:

From: "Joshua D. Drake"
Date: 21 December 2005, 20:36:43
Subject: Re: Memory Question

From: Peter Eisentraut
Date: 21 December 2005, 20:42:57
Subject: Re: view or index to optimize performance

Re: Indices for select count(*)? - Mailing list pgsql-general

Previous

Next