Re: [BUGS] Big problems with query optimization

2001-05-06 Thread Tom Lane
[EMAIL PROTECTED] writes: > Release 7.0 > faqts=> explain select faqs.id from faqs, faq_keywords; > NOTICE: QUERY PLAN: > Nested Loop (cost=0.00..4908.80 rows=161320 width=8) > -> Seq Scan on faqs (cost=0.00..2.40 rows=40 width=4) > -> Seq Scan on faq_keywords (cost=0.00..82.33 rows=4033

[BUGS] Big problems with query optimization

2001-05-06 Thread pgsql-bugs
Dmitriy A. Anipko ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Big problems with query optimization Long Description I use a 7.0 release running under SunOS on SPARC. I found that there is no real way to perform queries to s