Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 2E3C2635B01 for ; Wed, 10 Mar 2010 05:11:18 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 24444-01-7 for ; Wed, 10 Mar 2010 09:11:03 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f227.google.com (mail-ew0-f227.google.com [209.85.219.227]) by mail.postgresql.org (Postfix) with ESMTP id 474F6635B05 for ; Wed, 10 Mar 2010 05:11:07 -0400 (AST) Received: by ewy27 with SMTP id 27so3805064ewy.34 for ; Wed, 10 Mar 2010 01:11:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:cc:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=69wdoPZm/Az8Jr3S0bgnzKc4mmWxC+JEuKYksFP3OTc=; b=qVRtMFP09PKwZzHPs5Xpd6u5vO+KYRnlA2EpFfJ69y3PNLqAGv8BhCeOV4wMainJbj SlOvaqmKIK2Q8VkJXzpNNd3RhsvDYf2/Dvq+nLEwQJOmY6udN6sC4KvWBsIemDTvPDGg vqdhYxCG/zJ6eOckn33zmPoiOlUsw6p3hiI94= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; b=i0HfDy6JyyET17LiHvzXymGdzLjXckOqLzaGOjSc2Ltpzg+8M9P1FYEyAT6CFPDB3j SGqELqAxBci7E++LQU1tbtJ4iGoTe1sfkPw6bXYpEnVg5PrAcsUCpbQxfqtD4qnaE8hL BYE8GF7zAJiteq1lHWEfKEYM05hnFp/+fyers= Received: by 10.213.104.89 with SMTP id n25mr4819044ebo.78.1268212265850; Wed, 10 Mar 2010 01:11:05 -0800 (PST) Received: from [0.0.0.0] (5357DA75.cable.casema.nl [83.87.218.117]) by mx.google.com with ESMTPS id 15sm3713054ewy.8.2010.03.10.01.11.04 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 10 Mar 2010 01:11:04 -0800 (PST) Message-ID: <4B976229.7030407@gmail.com> Date: Wed, 10 Mar 2010 10:11:05 +0100 From: Yeb Havinga User-Agent: Thunderbird 2.0.0.23 (Windows/20090812) MIME-Version: 1.0 To: sverhagen@wps-nl.com CC: pgsql-performance@postgresql.org Subject: Re: Strange workaround for slow query References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.069 tagged_above=-10 required=5 tests=AWL=-1.070, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201003/103 X-Sequence-Number: 37928 Hello Sander, Can you post the explain plan output of these queries? > SELECT * FROM events_events LEFT OUTER JOIN events_event_types ON > eventType_id=events_event_types.id WHERE severity=20 AND (eventType_id > IN (71)) ORDER BY datetime DESC limit 50; > > SELECT * FROM events_events LEFT OUTER JOIN events_event_types ON > eventType_id=events_event_types.id WHERE severity=70 AND (eventType_id > IN (71, 999)) ORDER BY datetime DESC LIMIT 50; > regards Yeb Havinga