Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tqtx0-0002EG-HF for pgsql-performance@arkaria.postgresql.org; Thu, 03 Jan 2013 23:11:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tqtwz-0007WH-Kb for pgsql-performance@arkaria.postgresql.org; Thu, 03 Jan 2013 23:11:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tqtwy-0007W8-US for pgsql-performance@postgresql.org; Thu, 03 Jan 2013 23:11:49 +0000 Received: from wizmail.org ([2a00:1940:107::2:0:0]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tqtwv-000598-KL for pgsql-performance@postgresql.org; Thu, 03 Jan 2013 23:11:48 +0000 Received: from [46.33.133.68] (helo=ebony.jgh.adsl.wizards.co.uk) from_AS 51561 by wizmail.org with esmtpsa (TLSv1:DHE-RSA-CAMELLIA256-SHA:256) (Exim 4.82_RC117) id 1Tqtwr-00026p-VX (return-path ); Thu, 03 Jan 2013 23:11:42 +0000 Message-ID: <50E6102C.1090406@wizmail.org> Date: Thu, 03 Jan 2013 23:11:40 +0000 From: Jeremy Harris User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.21) Gecko/20090320 Fedora/2.0.0.21-1.fc9 Thunderbird/2.0.0.21 Mnenhy/0.7.5.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Simple join doesn't use index References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 01/03/2013 10:54 PM, Alex Vinnik wrote: > I have implemented my first app using PG DB and thought for a minute(may be > two) that I know something about PG but below problem totally destroyed my > confidence :). Please help me to restore it. https://wiki.postgresql.org/wiki/SlowQueryQuestions -- Jeremy -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance