Re: Survey: Max TPS you've ever seen

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all!

> - checkpoint_segments 1000
> - checkpoint_completion_target 0.9
> - wal_buffers  256MB
> - shared_buffers 31 gb
> - max_connections 500

I see that some of you are using wal_buffers = 256MB.
I was under the impression that Postgres will not benefit from higher value than the segment size, i.e. 16MB. More than that will not do/help anything.

What's the reasoning behind setting it to higher than 16MB? Do I have old information?

Best regards, Martin

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux