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

Re: Bug #715: Too much memory consuming with postmaster

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mhromada(at)elas(dot)sk, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #715: Too much memory consuming with postmaster
Date: 2002-07-19 13:56:47
Message-ID: 12398.1027087007@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)org writes:
> Big diffrence in performence between 7.1 and 7.2.1. In 7.2.1 postmaster grows up to 700 MB RAM and more while in 7.1 just up to 8 MB RAM.

You have not given nearly enough information to allow any useful
response to this complaint.

For starters, what are the schemas of the tables involved?  Have you
done ANALYZE (resp. VACUUM ANALYZE) recently?  What do you get from
EXPLAIN for the problem query on both systems?

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-07-19 13:59:42
Subject: Re: initdb problem
Previous:From: Stephan SzaboDate: 2002-07-19 13:53:55
Subject: Re: Bug #715: Too much memory consuming with postmaster

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