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

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds
Date: 2010-10-27 14:53:22
Message-ID: cone.1288191202.754179.5695.1000@shelca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Pavel Stehule writes:

> increase statistics on columns. The estimation is totally out.

Stats when I ran the above was at 250.
Will try 500.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Marcin Mirosław 2010-10-27 14:56:44 Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds
Previous Message Divakar Singh 2010-10-27 14:00:15 Re: Postgres insert performance and storage requirement compared to Oracle