Search Postgresql Archives

Re: Indices for select count(*)?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: Indices for select count(*)?
From: Peter Eisentraut <peter_e@xxxxxxx>
Date: Wed, 21 Dec 2005 22:39:58 +0100
Cc: Alexander Scholz <alexander.scholz1@xxxxxxxxxx>
In-reply-to: <dobcn0$24ur$1@xxxxxxxxxxxx>
References: <do9sl9$1tbi$1@xxxxxxxxxxxx> <20051221061433.GB19943@xxxxxxxxxxxxxxxxxxx> <dobcn0$24ur$1@xxxxxxxxxxxx>
User-agent: KMail/1.8.2

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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Newbie Question: FAQ for database optimization?
  - From: Alexander Scholz
- Re: Newbie Question: FAQ for database optimization?
  - From: A. Kretschmer
- Indices for select count(*)?
  - From: Alexander Scholz

Prev by Date: Re: Memory Question
Next by Date: Re: view or index to optimize performance
Previous by thread: Indices for select count(*)?
Next by thread: Re: Indices for select count(*)?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux