Re: out of memory

>
> Some one know why this is happening?
>
> I change the OS to 64 bits and now the oom-killer not hapend but Postgres is
> still showing out of memory
>
> Linux SERVER 2.6.18-92.el5 #1 SMP Tue Apr 29 13:16:15 EDT 2008 x86_64 x86_64
> x86_64 GNU/Linux
> Red Hat Enterprise Linux Server release 5.2 (Tikanga)
> PostgreSQL 8.1.15
> 32GB RAM
>
> My postgresql.conf:
> # - Memory -
>
> shared_buffers = 1048576                        # min 16 or
> max_connections*2, 8KB each
> temp_buffers = 1024                     # min 100, 8KB each
> max_prepared_transactions = 20         # can be 0 or more
> # note: increasing max_prepared_transactions costs ~600 bytes of shared
> memory
> # per transaction slot, plus lock space (see max_locks_per_transaction).
> work_mem = 1024                 # min 64, size in KB
> maintenance_work_mem = 65536            # min 1024, size in KB
> max_stack_depth = 2048                  # min 100, size in KB
>

What about the shmmax and shmall kernel parametters?
Which values you are managing?

--
Emanuel Calvo Franco
www.emanuelcalvofranco.com.ar