* Dan Harris (fbsd@xxxxxxxxxxxxxxx) wrote: > On 10/7/10 11:47 AM, Aaron Turner wrote: >> Basically, each connection is taking about 100MB resident. As we need >> to increase the number of threads to be able to query all the devices >> in the 5 minute window, we're running out of memory. > I think the first thing to do is look into using a connection pooler > like pgpool to reduce your connection memory overhead. Yeah.. Having the number of database connections be close to the number of processors is usually recommended. Stephen
Attachment:
signature.asc
Description: Digital signature
