Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds

From: Marcin Mirosław <marcin(at)mejor(dot)pl>
To: Francisco Reyes <lists(at)stringsutils(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds
Date: 2010-10-27 14:56:44
Message-ID: 4CC83DAC.5000600@mejor.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Francisco Reyes 2010-10-27 15:14:05 Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds
Previous Message Francisco Reyes 2010-10-27 14:53:22 Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds