[PERFORM] Slow create temp table

2014-07-30 Thread Clinton Adams
Greetings, Any help regarding a sporadic and mysterious issue would be much appreciated. A pgsql function for loading in data is occasionally taking 12+ hours to complete versus its normal 1-2 hours, due to a slow down at the CREATE TEMP TABLE step. During slow runs of the function, the temp tabl

Re: [PERFORM] Check memory consumption of postgresql query

2014-05-08 Thread Clinton Adams
On Thu, May 8, 2014 at 3:04 AM, Phan Công Minh 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