Bruno Wolff III schrieb:
>
> On Tue, Oct 01, 2002 at 14:18:50 +0200,
> Michael Contzen <[EMAIL PROTECTED]> wrote:
> > Here the table:
> >
> > mc=# \d egal
> > Table "public.egal"
> > Column | Type | Modifiers
> > +-+---
> > i | integer |
> >
> > mc=# selec
On Tue, Oct 01, 2002 at 14:18:50 +0200,
Michael Contzen <[EMAIL PROTECTED]> wrote:
> Here the table:
>
> mc=# \d egal
> Table "public.egal"
> Column | Type | Modifiers
> +-+---
> i | integer |
>
> mc=# select count(*) from egal;
> count
> -
"Michael Contzen" <[EMAIL PROTECTED]> writes:
> [ select distinct takes a long time on 7+ million rows ]
What do you have sort_mem set to? The default value is mighty small,
and that would translate directly to poor performance in DISTINCT.
Still though, the speed differential against Oracle is
Hello,
I posted some observations to the performance of postgres some weeks
ago.
The problem with the poor performance of "select distinct" still exists,
but I tried to worked out some reproducable results in a less complicated
way than in my first postings.
'select distinct' preforms on Orac