On Thu, Jul 25, 2013 at 6:23 AM, McKinzie, Alan (Alan)
wrote:
> FYI – I am using smem (on a linux server) to monitor the memory allocated to
> our Database connections. In an attempt to lower our memory footprint, I
> lowered our setting for work_mem from 1MB down to 500kB (in addition I
> enabl
"McKinzie, Alan (Alan)" writes:
> I am trying to understand how memory is allocated/used by our Postgresql
> Database connections. From reading the documentation it appears that
> work_mem and temp_buffers are the 2 largest contributors (and work_mem usage
> can grow) to the memory utilized by
It is always better to run performance script and database on different
machines.
>From DBT5 documentation it doesn't seems like you can connect to remote
host.
If yo found you can use that.
If it is not present then:-
Use wrapper tools like pg_bench tool which samrat has suggested .
where you
I am trying to understand how memory is allocated/used by our Postgresql
Database connections. From reading the documentation it appears that work_mem
and temp_buffers are the 2 largest contributors (and work_mem usage can grow)
to the memory utilized by the Database connections. In addition,
>I want test the PostgreSQL performance using DBT5, where my PostgreSQL
running on server (say >192.168.56.101) and want to test the performance
executing DBT5 on other machine (say 192.168.56.102).
>My aim is test the database performance excluding overhead to testing tool
running on same machine.
