Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id C93E41C2F15 for ; Thu, 3 May 2012 12:42:55 -0300 (ADT) Received: from mail-pb0-f46.google.com ([209.85.160.46]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SPyBA-00060B-Eb for pgsql-performance@postgresql.org; Thu, 03 May 2012 15:42:55 +0000 Received: by pbbrp8 with SMTP id rp8so2636482pbb.19 for ; Thu, 03 May 2012 08:42:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; bh=hcV0yq1D04G/lnVNY95BWXKQSHF+m1plSJiBSvGADuw=; b=zK96nf9n3UFU0ZQeDhfP+WyZR/gu4RJMuReYIYTjVQhoI0z92wslkM6CaRFvJybjLY 6vCigsBEY8oFLaM97eWEKSV56nqyHesNRfG/SbQJPW5/So3O08YA4LdCdtlDj9EyPiUU FLRWxLZCgAir6NK7glQl08n7FuQhje57AecJyleZC359kXJxdjpwRpBfNSF+66RV4uIE BmUJwNRge48FnmuxmdN2y/Ljw3GgQaROMPE7SAMSAD6J01ieVIBQRgUU9biMinZ7ZHXo IEe7ER8kFkJ8FdIPNmnQtSHe6eGnpi9WPGGOCv5rpQE+1FnViS0VUO/5DoupJVQY83V4 gYng== Received: by 10.68.216.164 with SMTP id or4mr346980pbc.11.1336059759973; Thu, 03 May 2012 08:42:39 -0700 (PDT) Received: from [192.168.11.3] ([114.95.165.117]) by mx.google.com with ESMTPS id jv11sm5639689pbb.7.2012.05.03.08.42.36 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 03 May 2012 08:42:38 -0700 (PDT) Message-ID: <4FA2A766.106@gmail.com> Date: Thu, 03 May 2012 23:42:30 +0800 From: Rural Hunter User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:12.0) Gecko/20120428 Thunderbird/12.0.1 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Query got slow from 9.0 to 9.1 upgrade References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.5 (-) X-Archive-Number: 201205/35 X-Sequence-Number: 46859 This is very similar with my problem: http://postgresql.1045698.n5.nabble.com/index-choosing-problem-td5567320.html