Re: bad planning with 75% effective_cache_size

From: Filippos <filippos(dot)kal(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: bad planning with 75% effective_cache_size
Date: 2012-04-15 20:01:59
Message-ID: 1334520119128-5642356.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

could you try to set the statistics parameter to 1000 (ALTER TABLE SET
STATISTICS) for these tables, then run analyze and try again?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/bad-planning-with-75-effective-cache-size-tp5620363p5642356.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2012-04-16 13:10:18 Re: scale up (postgresql vs mssql)
Previous Message Eyal Wilde 2012-04-15 12:43:27 Re: scale up (postgresql vs mssql)