Skip site navigation (1) Skip section navigation (2)

Re: Postgres Connections Requiring Large Amounts of Memory

From: Dawn Hollingsworth <dmh(at)airdefense(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres Connections Requiring Large Amounts of Memory
Date: 2003-06-16 08:57:35
Message-ID: 1055753856.5467.57.camel@kaos (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
We have just recently hired a database consultant familiar with Postgres
and just on his cursory glance we are not doing anything really crazy.

There are two things which might be considered off the beaten path

1. We have tables that have over 500 columns which we continually insert
into and select from.

2. Our stored procedures take more than 16 parameters so in the file
config.h the value INDEX_MAX_KEYS was increased to 100.


On Mon, 2003-06-16 at 20:45, Tom Lane wrote:
> Dawn Hollingsworth <dmh(at)airdefense(dot)net> writes:
> > PostgreSQL Version: 7.2.3
> > My problem is that the memory used by the connections appears to grow
> > over time, especially when the amount of data entering the system is
> > increased.
> We have fixed memory-leak problems in the past, and I wouldn't be
> surprised if some remain, but you'll have to give a lot more detail
> about what you're doing if you want help.  A leak that persists across
> transaction boundaries is fairly surprising --- I think I can safely
> say that there are none in the normal code paths.  I'm guessing you must
> be using some off-the-beaten-path feature.
> 			regards, tom lane
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

In response to


pgsql-performance by date

Next:From: Manfred KoizarDate: 2003-06-16 10:31:08
Subject: Re: 7.3 vs 7.2 - different query plan, bad performance
Previous:From: Dawn HollingsworthDate: 2003-06-16 08:32:17
Subject: Postgres Connections Requiring Large Amounts of Memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group