Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iAtNf-0007E6-SR for pgsql-performance@arkaria.postgresql.org; Thu, 19 Sep 2019 10:09:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iAtNe-0007vJ-Ac for pgsql-performance@arkaria.postgresql.org; Thu, 19 Sep 2019 10:09:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iAtNe-0007v3-0b for pgsql-performance@lists.postgresql.org; Thu, 19 Sep 2019 10:09:42 +0000 Received: from mout.kundenserver.de ([217.72.192.73]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iAtNZ-0007ZO-Eu for pgsql-performance@lists.postgresql.org; Thu, 19 Sep 2019 10:09:41 +0000 Received: from [10.8.0.75] ([185.40.248.10]) by mrelayeu.kundenserver.de (mreue106 [212.227.15.145]) with ESMTPSA (Nemesis) id 1MEVmm-1iPlUC0pcw-00FyQt for ; Thu, 19 Sep 2019 12:09:34 +0200 To: pgsql-performance@lists.postgresql.org From: Thomas Kellerer Subject: Surprising benchmark count(1) vs. count(*) Message-ID: Date: Thu, 19 Sep 2019 12:09:32 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:tEL0/gezJh+WbA1Dwnd+fCB7r7meiKZFg4Comc9qeQPj5AZi3Xy 5NJtAHorPLyik84hicPQDO5idtF7Q0DGyccnoEHOBtxhyvp5Osz2TmNcj0kRUJlrRLbsj/t gdirhS5EEfRgeIOgLdwwbI/4dTCks1y8RXwfuLtWa3ZjzvHXA0vsTndeqqDYwfu2RA5fXih DWHq9LsISm92MQV/NiWTA== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:1slknrGpcrU=:1cS+3FBt+3eyVJ6TkZ7ek/ 1oOUqCZzgF5rI01uPZOuD3HTjnRXiGXeBH9JF+1y3oNA1k8+cty9nBndCmbaNIXte6L/ZIUnI lQkN98isk5m280DEhHbWGcuT8Q7JmAL+8ZqlWOV/C+0b9HJY+PxRYGCj4lGwAt602hEEKCRdC 9tIKrR2Vm8mM3Z5Bd3hRp7n8AykxcexQiCRzMTB5lo6atbfqGjL8kMSjPf3Eq52jdHPhOjb6i oSw852xcYd/kQ+iMlweu3Ca/+zRjhYhgHkCvlHZMxc1RRpGQ2k5bF8fIUu9TzP/bfZAOnNiT3 l9Rbn9Xrk9udCzY/Zvh183yxHzNyXhrmFUxWGDD+zxs4GrHXuEJQAwCzSlawtm2w5227kRQGR eDccLJoFslmhBGgIRYATnc5QMsXJF1VsSMi0QQK7YqMWCOnTL3zr96Itlyt6eHk83KRMZ/9WQ DUbz+H05fPdjZba8MRbfjUf+qP47eaDp/zuhch01U1ppSKY0JAFTFkK7P0PWlv+0Q+GFrFspe UjTPasVkxE1w1FkJju9ahk4t0/RHD4I0YWSwVDec+5GEY4H5ULRhAdTGiICqZBpcQ5H87Y6ca EzI3qOrOQLvrmcr95QDxGTxOWE5J/oWye4Z8XmEdWYKCG3Av+0GVI1UDgHqlFPorB9ZfHlyHA KZsuw9qHQotmYHB0MtOj3QSEvBSGDKcUJzEVaecnevPEcwhEvz2/JUP9wyJqYnfiaVMscMbGA l5PF70pUbmDLuR4Z0kUBR3rrZ3SRm8hW12f9IherAdQWBOnotZY+oLrrxX+wG5IpmuPz51E2+ w5qDXctoWo98rPukswxEe6RJ6CMW12B0QjN4emmfWT4gIPBZX0sYjJxclLtBw/vaJKqx9SMrz /cyiSjZqxjk/aMQ7RlcNphhbFvcLOvvhQ5mEk4W5s= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk https://blog.jooq.org/2019/09/19/whats-faster-count-or-count1/ Is there a reason why count(*) seems to be faster?