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
pgsql-performance by date
|Next:||From: Marcin Mirosław||Date: 2010-10-27 14:56:44|
|Subject: Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds|
|Previous:||From: Divakar Singh||Date: 2010-10-27 14:00:15|
|Subject: Re: Postgres insert performance and storage requirement compared to Oracle|