Re: Memory bloating

From: Micah Anderson <micah(at)colltech(dot)com>
To: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Memory bloating
Date: 2000-10-03 19:01:43
Message-ID: 20001003140143.H19937@psasolar.colltech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ross,

I put debug level to 2 and let it go a cycle (which I define as bringing the
CPU load to at least 20 and then seeing it drop down again), about 45
minutes or so. The logfile is pretty big so I dont want to send it to you in
email, but I didn't really see anything unusual (but then again, I dont know
what unusual would be), most everything was selects. I counted 19 UPDATE
lines, which is VERY few, and 25 DELETE, amidst about 2500 SELECTs.

Micah

On Tue, Oct 03, 2000 at 12:26:53PM -0500, Ross J. Reedstrom wrote:
> On Tue, Oct 03, 2000 at 11:55:45AM -0500, Micah Anderson wrote:
> > Hello,
> >
> > We are using postgresql exclusively for our database backend for a
> > high-traffic site, sustaining 3-4 pages per second, in many cases
> > bursting well over that. At least half of those accesses are pgsql
> > SELECT, we rarely, if at all, use DELETE. It seems worst on tables with
> > more than about 1000 rows or 1000 hits an hour, or both.
> >
>
> Hmm, how about UPDATE? The exploding files and VACUUM stats indicate that
> you're creating no longer valid tuples _somehow_. Any recent changes in
> SQL scripts? I'd be suspicious of a 'view' page that got cloned from an
> 'edit' page, and is updating the 'modified' field, as an example.
>
> You could turn on a higher level of logging, and capture the actual
> queries, for a time, and find the culprit that way. Use of varchar isn't
> the problem: there's got to be either UPDATE or DELETE going on.
>
> Ross
> --
> Open source code is like a natural resource, it's the result of providing
> food and sunshine to programmers, and then staying out of their way.
> [...] [It] is not going away because it has utility for both the developers
> and users independent of economic motivations. Jim Flynn, Sunnyvale, Calif.

--
Micah Anderson
Collective Technologies
www.colltech.com

"To be and not to do is not to be at all"

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-10-03 19:01:57 Re: Memory bloating
Previous Message Kane Tao 2000-10-03 18:07:21 Re: Memory bloating