Re: Major differences between oracle and postgres performance - what can I do ?

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Gary Cowell <gary_cowell(at)yahoo(dot)co(dot)uk>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Major differences between oracle and postgres performance - what can I do ?
Date: 2004-06-18 16:30:03
Message-ID: 20040618163003.GM11196@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> [... thinks for awhile ...] It seems possible that they may use sort
> code that knows it is performing a DISTINCT operation and discards
> duplicates on sight. Given that there are only 534 distinct values,
> the sort would easily stay in memory if that were happening.

Could this optimization be added to PostgreSQL? It sounds like a very
reasonable thing to do. Hopefully there wouldn't be too much complexity
needed to add it.

Stephen

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-06-18 17:01:51 Re: Major differences between oracle and postgres performance - what can I do ?
Previous Message Gary Cowell 2004-06-18 15:47:21 Re: Major differences between oracle and postgres performance - what can I do ?