Postgres Pro
Downloads
Home   >   mailing lists

Re: Why SELECT COUNT(*) takes so long? - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Why SELECT COUNT(*) takes so long?
Date
Msg-id 4C1EEF4D-067B-4A4A-9BEB-F12FB88A7F3F@thebuild.com
Whole thread Raw
In response to Why SELECT COUNT(*) takes so long?  (Matthias Apitz <guru@unixarea.de>)
List pgsql-general
Tree view 

> On Sep 13, 2020, at 23:09, Matthias Apitz <guru@unixarea.de> 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@thebuild.com

pgsql-general by date:

Previous
From: Matthias Apitz
Date:
Subject: Why SELECT COUNT(*) takes so long?
Next
From: Magnus Hagander
Date:
Subject: Re: Reg:CHARSET_COVERSION_LATIN_TO_UTF8