Request a Demo
Home   >   mailing lists

Surprising benchmark count(1) vs. count(*) - Mailing list pgsql-performance

From Thomas Kellerer
Subject Surprising benchmark count(1) vs. count(*)
Date
Msg-id df354b76-a645-73fc-9645-4508e5291d71@gmx.net
Whole thread Raw
Responses Re: Surprising benchmark count(1) vs. count(*)
List pgsql-performance
Tree view 
https://blog.jooq.org/2019/09/19/whats-faster-count-or-count1/

Is there a reason why count(*) seems to be faster?

pgsql-performance by date:

Previous
From: Michael Lewis
Date:
Subject: Re: pg12 - migrate tables to partitions structure
Next
From: Laurenz Albe
Date:
Subject: Re: Surprising benchmark count(1) vs. count(*)