Hi tom, sorry for my bad. My production server is 7.3.7, but the development is 7.3.1 and I ran the tests on 7.3.1.
It is courios that on 7.3.1 the query is not constantly bad. >From time to time it is running well. regards, ivan. Tom Lane wrote: > pginfo <[EMAIL PROTECTED]> writes: > > I am using pg 7.3.3 on RH 7.3, > > Are you certain the server is 7.3.3? This looks like a mergejoin > estimation bug that was present in 7.3 and 7.3.1, but should be fixed > in 7.3.2 and later. > > If it is 7.3.3, I'd like to see the pg_stats rows for > a_acc.ids_vid_doc and a_vid_doc.ids. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])