Re: PostgreSQL performance on FreeBSD

2014-08-13 Thread Alan Cox
On Tue, Aug 12, 2014 at 1:09 PM, John Baldwin wrote: > On Wednesday, July 16, 2014 1:52:45 pm Adrian Chadd wrote: > > Hi! > > > > > > On 16 July 2014 06:29, Konstantin Belousov wrote: > > > On Fri, Jun 27, 2014 at 03:56:13PM +0300, Konstantin Belousov wrote: > > >> Hi, > > >> I did some measurem

Re: PostgreSQL performance on FreeBSD

2014-08-13 Thread Alan Cox
On Wed, Aug 13, 2014 at 4:58 AM, David Chisnall wrote: > On 12 Aug 2014, at 19:09, John Baldwin wrote: > > > OTOH, I have actually seen junk profiling _improve_ performance in > certain > > cases as it forces promotion of allocated pages to superpages since all > pages > > are dirtied. (I have

Re: PostgreSQL performance on FreeBSD

2014-08-13 Thread David Chisnall
On 12 Aug 2014, at 19:09, John Baldwin wrote: > OTOH, I have actually seen junk profiling _improve_ performance in certain > cases as it forces promotion of allocated pages to superpages since all pages > are dirtied. (I have a local hack that adds a new malloc option to > explicitly > memse