Wells Oliver wrote:
> Do you have any recommendations on a pg connection pooler?
If the software you're using includes a connection pool, that is
often the best choice; if not (or it doesn't work well) both pgpool
and pgbouncer have their followings.
In my view the most important things are
On May 31, 2011, at 11:31 AM, Kevin Grittner wrote:
You're probably overcommitting memory and running afoul of the oom
killer.
You've got an actual 12MB, but you can easily allocate up to
shared_buffers + (user_connections * work_mem), which is 18.5 GB. I
would start by reducing shared_buggers
Wells Oliver wrote:
> This has happened twice over the last couple of nights:
>
> 2011-05-30 02:08:27 PDT LOG: server process (PID 29979) was
> terminated by signal 9: Killed
> 2011-05-30 02:08:31 PDT FATAL: could not create shared memory
> segment: Cannot allocate memory
> To reduce the