Planner estimates cost of 'like' a lot lower than 
Author Message
 Planner estimates cost of 'like' a lot lower than

Precisely the point! There "shouldn't" be an issue with SMP boxes other
than OS differences that may result in one OS more efficiently utilizing
additional processors, yet there were striking differences in the
execution of my queries when I dropped the index after moving my system
from a single processor to a dual processor box using the identical
software configuration.

At the time, I *thought* it may have been a PostgreSQL issue, but it
just as well may have been a Linux issue. Your similar situation on BSD
leads me to believe that it may in fact be an issue with PostgreSQL
after all.

Disturbing isn't it? ;)


> > I ran into a similar problem on RedHat Linux v6.1 on Intel, kernel
> > 2.2.12-20, PostgreSQL 6.5.3 when moving a system from a single processor
> > development box over to a dual processor production server. Dropping one
> > of the indexes on a lookup table with roughly 68,000 records on the
> > production box resulted in roughly a 3 fold increase in query execution
> > speed. At the time, I thought it was an SMP issue, and have since been
> > extremely conservative in adding indexes on SMP boxes.

> I _am_ running it on an SMP box (FreeBSD 5.0-current from january
> this year), but isn't it a bit far-fetched to assume that this is
> an SMP issue? Is postgres even aware of running on an SMP box?
> (if it isn't, why should the planner estimates differ depending
> on if it is running on an SMP box or not?)

> Forgive me for sounding negative, but I fail to see the connection.
> Am I missing something?

>       _
> Mats Lofkvist

> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Sat, 10 Jan 2004 01:07:47 GMT
 [ 1 post ] 

 Relevant Pages 

1. Planner estimates cost of 'like' a lot lower than '='??

2. HELP: Estimated cost doesn't related to execution time

3. HELP: Estimated cost doesn't related to execution time

4. Row Estimate/ cost estimate

5. Urgent...Pb d'execution d'un lot DTS

6. Bulk Insert Generate lots of '??????'

7. BCP takes lot's of memory and doesn't release it

8. Problems with lower('?')

9. TButton in 'lowered' position

10. Cost as used in 'EXPLAIN PLAN'

11. **************!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!Help me !!!!!!!!!!!!!!!!!!!!!!!!'''''''''''''''''''''''*************

12. Planner's choice

Powered by phpBB® Forum Software