Postgres Pro
Downloads
Home   >   mailing lists

Re: bad planning with 75% effective_cache_size - Mailing list pgsql-performance

From Filippos
Subject Re: bad planning with 75% effective_cache_size
Date
Msg-id 1334520119128-5642356.post@n5.nabble.com
Whole thread Raw
In response to Re: bad planning with 75% effective_cache_size  (Istvan Endredy <istvan.endredy@gmail.com>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow fulltext query plan
Next
From: Merlin Moncure
Date:
Subject: Re: scale up (postgresql vs mssql)