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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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