Forum OpenACS Q&A: Response to speed of different counts

"explain" is your friend.  Put the word "explain" before each SQL statement and feed it to pgsql.  You'll get the query plan that it will execute to answer your question. It may have very little to do with how you laid out your SQL.If you have trouble decrypting the EXPLAIN output, post it here.