of the conversation.
breaks the flow
because it
toppost
Please don't
At 1:17p -0400 on 01 Jun 2007, Tyler Durden wrote:
> Yes, either case happens the same.
> I'm come recently from MySQL and it works in a different way.
> I find strange that a simple SELECT COUNT(...) is so slow with only
> 700 000 records.
> Has been a nightmare optimizing this tables/queries.
> Sorry about this silly question, but I'm new to Posgresql.
The much more knowledgable will correct me, but the abbr. version is
that it is for data integrity and correctness reasons and the
inherent way in which the MVCC model works. If it's any condolence,
I believe that Oracle also suffers with this particular query, but I
haven't seen any benchmarks to prove that (I think because Oracle
expressly forbids benchmarks and comparisons in their license, but
don't quote me on that).
For a complete discussion, go this page and look for the thread with
the subject 'Performance of count(*)'
http://archives.postgresql.org/pgsql-performance/2007-03/threads.php
I believe that may help.
Kevin