"Kevin Grittner" <kevin.gritt...@wicourts.gov> wrote: > Mark Kirkwood <mark.kirkw...@catalyst.net.nz> wrote: > >> Here's a simplified example using synthetic data (see attached to >> generate if desired): > > Doesn't work for me: Edited scripts to change hard-coded directory. Issue confirmed. > If you run pmap -d on the pid, what does the last line look like? $ pmap -d 5869|grep '^mapped' ; ps aux|grep '^kgrittn 5869 ' mapped: 1132044K writeable/private: 1084480K shared: 38436K kgrittn 5869 101 35.4 1139664 1094784 ? Rs 10:01 0:20 postgres: kgrittn test [local] EXPLAIN This wasn't necessarily at the peak. Attached is `vmstat 1` output during the EXPLAIN. About 1.1 GB private writeable memory consumed on my HEAD build on kubuntu 32 bit. -Kevin
kgrittn@kgrittn-desktop:~/work$ vmstat 1 procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu---- r b swpd free buff cache si so bi bo in cs us sy id wa 0 0 204500 229800 10520 2135820 1 1 11 3 2 10 3 1 95 0 0 0 204500 229668 10520 2135764 0 0 0 0 339 930 0 0 99 0 0 0 204500 225700 10520 2140276 0 0 0 0 400 1083 3 5 92 0 0 0 204500 225700 10520 2140376 0 0 0 0 280 769 1 1 98 0 1 0 204500 213416 10532 2137572 0 0 1452 452 594 613 18 1 72 9 8 0 204496 170380 10532 2138260 0 0 0 0 854 2013 55 7 37 0 1 0 204496 122268 10532 2142536 0 0 0 16 914 1420 50 6 43 0 2 0 205100 82712 10532 2135580 0 604 0 604 1029 458 48 3 50 0 1 0 206032 82208 10532 2090832 32 936 32 936 6430 545 50 6 45 1 2 0 206348 83324 10544 2041104 0 316 0 772 1442 1151 48 4 49 0 1 0 206808 82332 10544 1992428 0 460 0 460 1129 821 47 4 48 0 1 0 206852 83200 10548 1941136 0 44 4 160 1499 782 48 3 49 1 1 0 206908 81340 10548 1891868 0 56 0 56 1555 1082 49 3 48 0 1 0 206912 84068 10532 1837684 0 4 144 4 1515 967 49 3 45 3 1 0 206904 82936 10516 1784644 64 0 504 0 1629 960 48 12 35 6 1 1 206900 82208 10492 1731108 32 0 1092 292 1736 1077 49 4 37 9 2 0 206900 83912 10372 1673624 0 0 244 4 1977 1239 50 7 40 2 2 0 206900 81836 10128 1620852 0 0 0 0 902 863 47 5 48 0 1 0 206912 82332 9084 1563548 0 12 0 12 2364 457 46 6 47 0 1 0 207276 83200 8576 1507156 0 364 0 364 2466 541 48 4 48 0 2 0 207280 82332 8420 1447548 0 4 0 440 2424 959 47 8 45 0 1 0 207344 83820 8332 1384576 0 64 0 64 2342 1391 50 8 42 0 1 0 207344 82828 8272 1323772 0 0 16 0 2279 615 48 5 45 1 1 0 207344 83820 8244 1259092 0 0 56 0 1697 668 46 8 44 3 1 0 207344 81696 8268 1195708 76 0 512 0 1713 655 47 10 28 15 1 0 207408 81340 8252 1158556 0 64 388 520 764 514 46 2 50 2 0 0 207408 1214204 8396 1158640 0 0 252 140 878 710 31 16 46 9 0 0 207408 1214344 8400 1158948 0 0 16 0 404 567 1 3 94 1 0 0 207408 1214344 8400 1158928 0 0 0 0 268 470 0 0 99 0 0 0 207408 1214344 8400 1158912 0 0 0 0 356 458 0 0 100 0 0 1 207408 1214344 8408 1158960 0 0 8 0 256 482 0 0 99 0
-- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
