Re: Speed comparison to Oracle. Why was this query slower on pgsql?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Francisco Reyes <lists(at)natserv(dot)com>
Cc: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Speed comparison to Oracle. Why was this query slower on pgsql?
Date: 2002-02-22 21:43:28
Message-ID: 20020223084328.B3466@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Feb 22, 2002 at 01:53:40PM -0500, Francisco Reyes wrote:
> Is Oracle better at aggregate functions?
> Another point worth mentioning. The Oracle table has 40K records less.
> Postgresql has 770K, Oracld has 730K.

Posssibly. At the moment postgres will grab all the data from the table,
sort it, group it and then aggregate. Oracle is probably cleverer and just
aggregates directly. On that many rows it probably makes a difference.

HTH,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org>
http://svana.org/kleptog/
> If the company that invents a cure for AIDS is expected to make their
> money back in 17 years, why can't we ask the same of the company that
> markets big-titted lip-syncing chicks and goddamn cartoon mice?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Juan Jose Comellas 2002-02-22 21:57:58 Re: game db
Previous Message Medi Montaseri 2002-02-22 21:26:44 Re: Regular Expression for 'and' instead of 'or'