On Thu, Feb 3, 2011 at 7:39 PM, Mladen Gogala <mladen.gogala@xxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance