On 04/28/2014 08:47 AM, Karl Denninger wrote: > The odd thing is that I am getting better performance with a 128k record > size on this application than I get with an 8k one! Not only is the > system faster to respond subjectively and can it sustain a higher TPS > load objectively but the I/O busy percentage as measured during > operation is MARKEDLY lower (by nearly an order of magnitude!)
Thanks for posting your experience! I'd love it even more if you could post some numbers to go with. Questions: 1) is your database (or the active portion thereof) smaller than RAM? 2) is this a DW workload, where most writes are large writes? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
