Surprising benchmark count(1) vs. count(*)

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Surprising benchmark count(1) vs. count(*)
Date: 2019-09-19 10:09:32
Message-ID: df354b76-a645-73fc-9645-4508e5291d71@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

https://blog.jooq.org/2019/09/19/whats-faster-count-or-count1/

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Laurenz Albe 2019-09-19 10:22:42 Re: Surprising benchmark count(1) vs. count(*)
Previous Message Michael Lewis 2019-09-18 20:56:22 Re: pg12 - migrate tables to partitions structure