Luke Lonergan wrote:
That says it's something else in the path. As you probably know there is a page lock taken, a copy of the tuple from the page, lock removed, count incremented for every iteration of the agg node on a count(*). Is the same true of a count(1)?
Sorry Luke - message 3 - I seem to be suffering from a very small working memory buffer myself right now, I think it's after a day of working with DB2 ... :-)
Anyway, as I read src/backend/parser/gram.y:6542 - count(*) is transformed into count(1), so these two are identical.
Cheers (last time tonight, promise!) Mark ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
