Re: Still problems with memory swapping and server load

Hi!

I don't know exactly how to find the offending queries. All I was able
to come up with is check top-output, nail down the pid and then scan
over the logfile to get some queries - but of course there's lots of
queries using this very pid subsequently. How do I determine the
details? Right now all I could see was that all the queries where using
the begin|declare sql_cursor|fetch|close sql_cursor|end-pattern induced
by the odbc-driver, I presume. How do I pinpoint the specific offender?

Regards,

Markus

> -----Ursprüngliche Nachricht-----
> Von: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Gesendet: Mittwoch, 26. Juni 2002 16:59
> An: Markus Wollny
> Cc: pgsql-general(at)postgresql(dot)org
> Betreff: Re: [GENERAL] Still problems with memory swapping and server
> load
>
>
> "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de> writes:
> > I'm still "being hosed over big time" as Curt Sampson put
> it. It's still
> > the same machine and database: 1GB RAM, 4xPIII550Xeon,
> dumpall.sql is
> > ~300MB (see "[GENERAL] Urgent: Tuning strategies?"). It all
> starts with
> > a humble 8MB swap being used (I expect that's just the
> empty swap with
> > nothing in it but some system overhead). Then after a short
> time, memory
> > usage climbs slow but continuously until it hits physical
> RAM ceiling
> > and starts using swap - with not very nice results for the database.
>
> It sort of looks like you are seeing a memory-leak problem. I thought
> we'd largely eliminated that class of trouble in recent releases, but
> maybe there's still one or two left. Can you identify the exact query
> or queries that cause individual backends' memory usage to grow?
>
> regards, tom lane
>