On Thu, May 8, 2014 at 3:04 AM, Phan Công Minh <cp...@hsr.ch> wrote: > Hello PostgreSQL community , > > I'm doing benchmark between column store and traditional row-oriented store. > I would like to know if there is any way to measure memory consummed by a > query execution?
In linux you can look at the memory usage for a particular backend in /proc/[pid]/smaps. Get the pid with pg_backend_pid() or from pg_stat_activity. For more info, check out http://www.depesz.com/2012/06/09/how-much-ram-is-postgresql-using/ - Clinton > > Thanks > Minh, > -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
