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

2005-09-29 Thread Jim C. Nasby
On Tue, Sep 27, 2005 at 09:07:41AM -0500, boinger wrote: > -> Index Scan using strafe_group on tasks_applied > (cost=0.00..6.02 rows=1 width=22) (actual time=0.042..0.043 rows=0 > loops=1188) > > Index Cond: ((("outer".modcode)::text = > (tasks_applied.modcode):

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 >

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

2005-09-27 Thread Dawid Kuroczko
On 9/26/05, boinger <[EMAIL PROTECTED]> wrote: Hello.I'm not sure if this is a question suited for here, the -sql list, orthe -performance list, so if I'm mis-posting, please direct me to theright list.I was unable to come up with anything relevant from the archives (though...I am not too sure wher

[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