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

Re: Largeobject Access Controls (r2460)

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "Greg Smith" <greg(at)2ndquadrant(dot)com>, "KaiGai Kohei" <kaigai(at)ak(dot)jp(dot)nec(dot)com>, "Robert Haas" <robertmhaas(at)gmail(dot)com>, "KaiGai Kohei" <kaigai(at)kaigai(dot)gr(dot)jp>, "Takahiro Itagaki" <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, <pgsql-hackers(at)postgresql(dot)org>, "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
Subject: Re: Largeobject Access Controls (r2460)
Date: 2010-01-25 19:06:54
Message-ID: 4B5D976E020000250002EBC7@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-hackers
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>  
>> Did you happen to notice anything about pg_dump's memory
>> consumption?
>  
> Not directly, but I was running 'vmstat 1' throughout.  Cache
> space dropped about 2.1 GB while it was running and popped back up
> to the previous level at the end.
 
I took a closer look, and there's some bad news, I think.  The above
numbers were from the ends of the range.  I've gone back over and
found that while it dropped about 2.1 GB almost immediately, cache
usage slowly dropped throughout the dump, and bottomed at about 6.9
GB below baseline.
 
-Kevin

In response to

Responses

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2010-01-25 19:12:14
Subject: Re: plpython3 perf
Previous:From: Michael MeskesDate: 2010-01-25 19:01:50
Subject: Re: ECPG patch 4.1, out-of-scope cursor support in native mode

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