subject:"\[PERFORM\] Bad performance with hashjoin"

Re: [PERFORM] Bad performance with hashjoin

2004-09-11 Thread Tom Lane

Vitaly Belman <[EMAIL PROTECTED]> writes: > What am I to do? Reduce random_page_cost and/or increase effective_cache_size. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PRO

[PERFORM] Bad performance with hashjoin

2004-09-11 Thread Vitaly Belman

Here's the query: --- SELECT * FROM bv_reviews r, bv_votes v WHERE r.vote_id = v.vote_id AND v.book_id = 113 --- bv_votes has around 7000 rows with the