Re: [GENERAL] understanding postgres backend process memory usage

2016-04-18 Thread Day, David
Day, David Cc: [email protected] Subject: Re: [GENERAL] understanding postgres backend process memory usage Hi David, How many different table/objects do you read from and do you use bind variables? Each postmaster process keeps internal dictionary on objects and queries ran - If you h

Re: [GENERAL] understanding postgres backend process memory usage

2016-04-17 Thread Jony Cohen
Hi David, How many different table/objects do you read from and do you use bind variables? Each postmaster process keeps internal dictionary on objects and queries ran - If you have too many objects or queries planned you might take up too much ram. If this is indeed your situation, you might bene