* 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.
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2004-06-18 17:01:51|
|Subject: Re: Major differences between oracle and postgres performance - what can I do ? |
|Previous:||From: Gary Cowell||Date: 2004-06-18 15:47:21|
|Subject: Re: Major differences between oracle and postgres performance - what can I do ?|