Re: [PERFORM] pgtune + configurations with 9.3

2014-11-23 Thread Johann Spies
I have done some tests using pgbench-tools with different configurations on our new server with 768G RAM and it seems for our purpose 32G shared_buffers would give the best results. Regards Johann On 17 November 2014 at 07:17, Stuart Bishop wrote: > On 15 November 2014 06:00, Mark Kirkwood > w

Re: [PERFORM] Yet another abort-early plan disaster on 9.3

2014-11-23 Thread Tomas Vondra
On 21.11.2014 19:38, Jeff Janes wrote: > > When I run this patch on the regression database, I get a case where > the current method is exact but the adaptive one is off: > > WARNING: ndistinct estimate current=676.00 adaptive=906.00 > > select count(distinct stringu1) from onek; > 676 > > It s