Re: [HACKERS] Slow count(*) again...
От
Robert Haas
Тема
Re: [HACKERS] Slow count(*) again...
Дата
Msg-id
AANLkTi=V9J0Z-QTM=yJUctR7ECFRE3CJYB8NPXcxzuTO@mail.gmail.com
Ответ на
Re: [HACKERS] Slow count(*) again... (Mladen Gogala)
Список
Дерево обсуждения
Re: Why we don't want hints Chris Browne <cbbrowne@acm.org>
Re: Why we don't want hints Rob Wultsch <wultsch@gmail.com>
Re: Why we don't want hints Josh Berkus <josh@agliodbs.com>
Re: Why we don't want hints Scott Marlowe <scott.marlowe@gmail.com>
On Thu, Feb 3, 2011 at 7:39 PM, Mladen Gogala wrote: > reality. As a matter of fact, Oracle RDBMS on the same machine will > regularly beat PgSQL in performance. > That has been my experience so far. I even posted counting query results. It sure is, but those count queries didn't run faster because of query planner hints. They ran faster because of things like index-only scans, fast full index scans, asynchronous I/O, and parallel query. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
В списке pgsql-performance по дате отправления
