Keith Gabryelski wrote:
> any pointers for me to educate myself on these things is greatly
> appreciated (a book?, google fu, web links?)
http://www.postgresql.org/docs/books/
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
-Kevin
--
Sent via pgsql-admin mailing list (pgsql
Benjamin Krajmalnik wrote:
I ordered some massive servers, and in the course of benchmarking them
following their instructions it exposed apparent hardware issues -- so
the 2 massive servers as well as one of the smaller ones got shipped
back to the supplier for them to check it out. Had I a
manage postgres 9's postgres process's
memory
On Sun, Feb 13, 2011 at 9:57 AM, Kevin Grittner
wrote:
Keith Gabryelski wrote:
> here is an example of one process's growth over time --
>
> USER PID %CPU %MEMVSZ RSS
> postgres 20533 0.0 0.3 647388 52216
On Sun, Feb 13, 2011 at 9:57 AM, Kevin Grittner wrote:
> Keith Gabryelski wrote:
>
> > here is an example of one process's growth over time --
> >
> > USER PID %CPU %MEMVSZ RSS
> > postgres 20533 0.0 0.3 647388 52216
> > [...]
> > postgres 20533 0.0 0.9 663532 144328
>
> Let's ge
Keith Gabryelski wrote:
> here is an example of one process's growth over time --
>
> USER PID %CPU %MEMVSZ RSS
> postgres 20533 0.0 0.3 647388 52216
> [...]
> postgres 20533 0.0 0.9 663532 144328
Let's get the non-problem out of the way first. RSS includes shared
memory. Ea
I've noticed my postgres processes have been increasing their memory usage.
this seems to happen because my clients applications are using connection
pooling and
until one of the clients forces a connection reset the postgres process does
not
release its memory.
I'd love to understand how to manag
