Re: performance difference in count(1) vs. count(*)?

Markus Bertheau <twanger@xxxxxxxxxxxxxx> writes:
> is there a difference performance-wise between select count(1) and
> select count(*)?

Nope.  In fact, the latter is converted to the former during parsing.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html