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

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@svana.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?