Search Postgresql Archives

Re: Why SELECT COUNT(*) takes so long?

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

Subject: Re: Why SELECT COUNT(*) takes so long?
From: Christophe Pettus <xof@xxxxxxxxxxxx>
Date: Sun, 13 Sep 2020 23:11:31 -0700
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <20200914060944.GA2050@r314251-amd64>
References: <20200914060944.GA2050@r314251-amd64>


> On Sep 13, 2020, at 23:09, Matthias Apitz <guru@xxxxxxxxxxx> wrote:
> Why a SELECT COUNT(*) of the
> full table takes around 1 minute:

There's an explanation here:

	https://wiki.postgresql.org/wiki/Slow_Counting

--
-- Christophe Pettus
   xof@xxxxxxxxxxxx

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

References:
- Why SELECT COUNT(*) takes so long?
  - From: Matthias Apitz

Prev by Date: Why SELECT COUNT(*) takes so long?
Next by Date: Re: Dirty buffers with suppress_redundant_updates_trigger
Previous by thread: Why SELECT COUNT(*) takes so long?
Next by thread: Effective IO Concurrency
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