Re: [GENERAL] PostgreSQL with ZFS on Linux

2014-01-16 Thread Preston Hagar
On Thu, Jan 16, 2014 at 3:22 AM, Sébastien Lorion wrote: > Hello, > > Since ZFS on Linux (http://zfsonlinux.org/) has been declared production > ready last March (v0.6.1), I am curious if anyone is using it with > PostgreSQL on production servers (either main or backup) and if so, what is > their

Re: [GENERAL] Question about memory usage

2014-01-10 Thread Preston Hagar
On Fri, Jan 10, 2014 at 12:19 PM, Tom Lane wrote: > >> Preston Hagar writes: >> >>> tl;dr: Moved from 8.3 to 9.3 and are now getting out of memory errors >> >>> despite the server now having 32 GB instead of 4 GB of RAM and the >> workload &g

Re: [GENERAL] Question about memory usage

2014-01-10 Thread Preston Hagar
On Fri, Jan 10, 2014 at 11:09 AM, Steve Atkins wrote: > > On Jan 10, 2014, at 8:35 AM, Preston Hagar wrote: > > > tl;dr: Moved from 8.3 to 9.3 and are now getting out of memory errors > despite the server now having 32 GB instead of 4 GB of RAM and the workload > and number

[GENERAL] Question about memory usage

2014-01-10 Thread Preston Hagar
tl;dr: Moved from 8.3 to 9.3 and are now getting out of memory errors despite the server now having 32 GB instead of 4 GB of RAM and the workload and number of clients remaining the same. Details: We have been using Postgresql for some time internally with much success. Recently, we completed a