Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group