Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 467DF133798F
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 27 Oct 2010 11:56:59 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 20088-07
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 27 Oct 2010 14:56:52 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from hermes.mejor.pl (hermes.mejor.pl [193.238.12.139])
	by mail.postgresql.org (Postfix) with ESMTP id 55AA21336FA7
	for <pgsql-performance@postgresql.org>;
	Wed, 27 Oct 2010 11:56:51 -0300 (ADT)
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=mejor.pl;
	s=cokolwiek;
	h=Content-Transfer-Encoding:Content-Type:In-Reply-To:References:Subject:CC:To:MIME-Version:From:Date:Message-ID;
	bh=X2wkqR6QE1S+eXwb3/gT3r+6SgQYJLaOU0r2mHGnsOE=;
	b=unGXJfSLzds83CKX+naTgC8Ymgp97ZB0dl025a9HrJwNsTHqV/Sky1VBENeIuiQ9By45d0EZlng3e5wmt6ulzPsoUuYrS9/qyfj0B3eCrwlWq5rP/0wXNmeVZc3gv2lI;
Received: from 127-goc-33.acn.waw.pl ([94.75.108.127] helo=[192.168.138.87])
	by hermes.mejor.pl with esmtpsa (TLSv1:DHE-RSA-CAMELLIA256-SHA:256)
	(Exim 4.72) (envelope-from <marcin@mejor.pl>)
	id 1PB7Qj-0001sY-J3; Wed, 27 Oct 2010 16:56:45 +0200
Message-ID: <4CC83DAC.5000600@mejor.pl>
Date: Wed, 27 Oct 2010 16:56:44 +0200
From: =?UTF-8?B?TWFyY2luIE1pcm9zxYJhdw==?= <marcin@mejor.pl>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.11) Gecko/20101020 Lightning/1.0b3pre Mnenhy/0.8.3
	Thunderbird/3.1.5
MIME-Version: 1.0
To: Francisco Reyes <lists@stringsutils.com>
CC: Pavel Stehule <pavel.stehule@gmail.com>,
	Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds
References: <cone.1288183283.263738.5695.1000@shelca>
	<AANLkTimzhZr2ZjAQFRP100nrEM=1xqHN=xOa13OYC25=@mail.gmail.com>
	<cone.1288191202.754179.5695.1000@shelca>
In-Reply-To: <cone.1288191202.754179.5695.1000@shelca>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.61 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_LOW=-0.7, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201010/471
X-Sequence-Number: 40889

W dniu 27.10.2010 16:53, Francisco Reyes pisze:
> Pavel Stehule writes:
> 
>> increase statistics on columns. The estimation is totally out.
> 
> Stats when I ran the above was at 250.
> Will try 500.


Please paste: ANALYZE VERBOSE argrades
Regards