[GENERAL] Performance woes relating to DISTINCT (I think)

2005-09-27 Thread boinger
Hello. I'm not sure if this is a question suited for here, the -sql list, or the -performance list, so if I'm mis-posting, please direct me to the right list. I was unable to come up with anything relevant from the archives (though...I am not too sure where to start so I may just have been lookin

Re: [GENERAL] Performance woes relating to DISTINCT (I think)

2005-09-27 Thread boinger
On 9/27/05, Dawid Kuroczko <[EMAIL PROTECTED]> wrote: > > QUERY PLAN > > -> GroupAggregate (cost=0.00..85168.65 rows=11 > width=22) > > (actual time=3149.916..45578.292 rows=515 loops=1) > > Hmm, planner expected 11 rows, got 515 > > > > (cost=0.00..85167.23 rows=107 width=22) (actual >