Re: atrocious update performance

while you weren't looking, Tom Lane wrote:

[trace]

`strace -p 21882` run behind the below query and plan ... below that.

# explain update account.cust set prodid = tempprod.prodid, subprodid =
tempprod.subprodid where origid = tempprod.debtid;
QUERY PLAN
-------------------------------------------------------------------------
Merge Join (cost=0.00..232764.69 rows=4731410 width=252)
Merge Cond: (("outer".origid)::text = ("inner".debtid)::text)
-> Index Scan using ix_origid on cust (cost=0.00..94876.83
rows=4731410 width=236)
-> Index Scan using ix_debtid on tempprod (cost=0.00..66916.71
rows=4731410 width=26)
(4 rows)

----------

recv(9, "Q\0\0\0}explain update account.cust"..., 8192, 0) = 126
gettimeofday({1079482151, 106228}, NULL) = 0
brk(0) = 0x82d9000
brk(0x82db000) = 0x82db000
open("/var/lib/pgsql/data/base/495616/6834170", O_RDWR|O_LARGEFILE) = 8
_llseek(8, 212402176, [212402176], SEEK_SET) = 0
write(8, "\342\1\0\0\0\314\374\6\24\0\0\0\214\7pG\360\177\1\200\320"...,
32768) = 32768
close(8) = 0
open("/var/lib/pgsql/data/base/495616/16635", O_RDWR|O_LARGEFILE) = 8
read(8, "\0\0\0\0\20\0\0\0\1\0\0\0\24\0\360\177\360\177\1\200b1"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834168", O_RDWR|O_LARGEFILE) = 10
_llseek(10, 60817408, [60817408], SEEK_SET) = 0
write(10, "\342\1\0\0`\334\5\7\24\0\0\0t\0010x\360\177\1\200\330\377"...,
32768) = 32768
close(10) = 0
read(8, "\334\1\0\0h\217\270n\24\0\0\0H\0H|\360\177\1\200(at)\376\220"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834165", O_RDWR|O_LARGEFILE) = 10
_llseek(10, 130777088, [130777088], SEEK_SET) = 0
write(10, "\342\1\0\0<\341\7\7\24\0\0\0004\t0I\360\177\1\200\330\377"...,
32768) = 32768
close(10) = 0
open("/var/lib/pgsql/data/base/495616/16595", O_RDWR|O_LARGEFILE) = 10
read(10, "\334\1\0\0\360\216\270n\24\0\0\0X\0(at)y\0\200\1\200\320\371"...,
32768) = 32768
open("/var/lib/pgsql/data/base/495616/6834168", O_RDWR|O_LARGEFILE) = 11
_llseek(11, 145915904, [145915904], SEEK_SET) = 0
write(11, "\342\1\0\0\300\350\n\7\24\0\0\0\224\6\310Z\360\177\1\200"...,
32768) = 32768
close(11) = 0
open("/var/lib/pgsql/data/base/495616/16614", O_RDWR|O_LARGEFILE) = 11
read(11, "\0\0\0\0\24\231P\306\16\0\0\0\24\0\360\177\360\177\1\200"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834166", O_RDWR|O_LARGEFILE) = 12
_llseek(12, 148570112, [148570112], SEEK_SET) = 0
write(12, "\342\1\0\0\274\365\22\7\24\0\0\0X\3\234o\360\177\1\200"...,
32768)
= 32768
close(12) = 0
_llseek(11, 98304, [98304], SEEK_SET) = 0
read(11, "\0\0\0\0\24\231P\306\16\0\0\0\34\0\234\177\360\177\1\200"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834163", O_RDWR|O_LARGEFILE) = 12
_llseek(12, 251789312, [251789312], SEEK_SET) = 0
write(12, "\342\1\0\0l\366\23\7\24\0\0\0\364\10\260J\360\177\1\200"...,
32768)
= 32768
close(12) = 0
_llseek(11, 32768, [32768], SEEK_SET) = 0
read(11, "\340\1\0\0\324\231\273\241\24\0\0\0\234\5\330\26\360\177"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834165", O_RDWR|O_LARGEFILE) = 12
_llseek(12, 117309440, [117309440], SEEK_SET) = 0
write(12, "\342\1\0\0d\36)\7\24\0\0\0000\tHI\360\177\1\200\330\377"...,
32768)
= 32768
close(12) = 0
open("/var/lib/pgsql/data/base/495616/1259", O_RDWR|O_LARGEFILE) = 12
_llseek(12, 32768, [32768], SEEK_SET) = 0
read(12, "\334\1\0\0\324v-p\24\0\0\0000\3\304\3\0\200\1\200<\377"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834173", O_RDWR|O_LARGEFILE) = 13
_llseek(13, 247824384, [247824384], SEEK_SET) = 0
write(13, "\342\1\0\0h *\7\24\0\0\0\204\4dm\360\177\1\200\340\377"...,
32768)
= 32768
close(13) = 0
open("/var/lib/pgsql/data/base/495616/16613", O_RDWR|O_LARGEFILE) = 13
read(13, "\0\0\0\0\20\0\0\0\1\0\0\0\24\0\360\177\360\177\1\200b1"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834168", O_RDWR|O_LARGEFILE) = 14
_llseek(14, 204472320, [204472320], SEEK_SET) = 0
write(14, "\342\1\0\0\314\272:\7\24\0\0\0\324\t\354K\360\177\1\200"...,
32768)
= 32768
close(14) = 0
read(13, "\340\1\0\0X\231\273\241\24\0\0\0\370\6Dk\360\177\1\200"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834166", O_RDWR|O_LARGEFILE) = 14
_llseek(14, 152010752, [152010752], SEEK_SET) = 0
write(14, "\342\1\0\0p\277<\7\24\0\0\0\364\n\220I\360\177\1\200\334"...,
32768) = 32768
close(14) = 0
open("/var/lib/pgsql/data/base/495616/16610", O_RDWR|O_LARGEFILE) = 14
read(14, "\0\0\0\0\10\317\27\t\16\0\0\0\24\0\360\177\360\177\1\200"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834170", O_RDWR|O_LARGEFILE) = 15
_llseek(15, 86441984, [86441984], SEEK_SET) = 0
write(15, "\342\1\0\0\330B?\7\24\0\0\0\370\6 N\360\177\1\200\310\377"...,
32768) = 32768
close(15) = 0
_llseek(14, 98304, [98304], SEEK_SET) = 0
read(14, "\340\1\0\0,l\257\241\24\0\0\0(\0\250\177\360\177\1\200"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834166", O_RDWR|O_LARGEFILE) = 15
_llseek(15, 121896960, [121896960], SEEK_SET) = 0
write(15, "\342\1\0\0\264\303?\7\24\0\0\0\234\tHP\360\177\1\200\334"...,
32768) = 32768
close(15) = 0
_llseek(14, 65536, [65536], SEEK_SET) = 0
read(14, "\334\1\0\0\310u\252n\23\0\0\0\234\20\320=\360\177\1\200"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834173", O_RDWR|O_LARGEFILE) = 15
_llseek(15, 41549824, [41549824], SEEK_SET) = 0
write(15, "\342\1\0\0\0\312B\7\24\0\0\0\234\7\350T\360\177\1\200\330"...,
32768) = 32768
close(15) = 0
open("/var/lib/pgsql/data/base/495616/1249", O_RDWR|O_LARGEFILE) = 15
_llseek(15, 229376, [229376], SEEK_SET) = 0
read(15, "O\1\0\0\214\241\200\0\23\0\0\0\364\3\0\4\0\200\1\200\200"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834163", O_RDWR|O_LARGEFILE) = 16
_llseek(16, 57147392, [57147392], SEEK_SET) = 0
write(16, "\342\1\0\0004\320G\7\24\0\0\0\374\7\200P\360\177\1\200"...,
32768)
= 32768
close(16) = 0
_llseek(15, 163840, [163840], SEEK_SET) = 0
read(15, "\21\1\0\0\214\3\224R\23\0\0\0\364\3\0\4\0\200\1\200\200"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834163", O_RDWR|O_LARGEFILE) = 16
_llseek(16, 241893376, [241893376], SEEK_SET) = 0
write(16, "\342\1\0\0\220TK\7\24\0\0\0,\t`I\360\177\1\200\330\377"...,
32768)
= 32768
close(16) = 0
_llseek(12, 0, [0], SEEK_SET) = 0
read(12, "O\1\0\0\350\340\316,\23\0\0\0X\3\230\3\0\200\1\200d\304"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834171", O_RDWR|O_LARGEFILE) = 16
_llseek(16, 88702976, [88702976], SEEK_SET) = 0
write(16, "\342\1\0\0\324\326K\7\24\0\0\0`\v\370E\360\177\1\200\334"...,
32768) = 32768
close(16) = 0
_llseek(14, 32768, [32768], SEEK_SET) = 0
read(14, "\0\0\0\0\10\317\27\t\16\0\0\0\234\20\320=\360\177\1\200"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834173", O_RDWR|O_LARGEFILE) = 16
_llseek(16, 152043520, [152043520], SEEK_SET) = 0
write(16, "\342\1\0\0\220fU\7\24\0\0\0l\n\320K\360\177\1\200\334\377"...,
32768) = 32768
close(16) = 0
_llseek(15, 0, [0], SEEK_SET) = 0
read(15, "\0\0\0\0\20\0\0\0\1\0\0\0\364\3\0\4\0\200\1\200\200\377"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834163", O_RDWR|O_LARGEFILE) = 16
_llseek(16, 70025216, [70025216], SEEK_SET) = 0
write(16, "\342\1\0\0\370\rk\7\24\0\0\0 \10\250O\360\177\1\200\330"...,
32768)
= 32768
close(16) = 0
read(15, "\0\0\0\0\20\0\0\0\1\0\0\0\364\3\0\4\0\200\1\200\200\377"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834163", O_RDWR|O_LARGEFILE) = 16
_llseek(16, 152764416, [152764416], SEEK_SET) = 0
write(16, "\342\1\0\0008\222m\7\24\0\0\0\370\10\230J\360\177\1\200"...,
32768)
= 32768
close(16) = 0
open("/var/lib/pgsql/data/base/495616/16630", O_RDWR|O_LARGEFILE) = 16
read(16, "\0\0\0\0\20\0\0\0\1\0\0\0\24\0\360\177\360\177\1\200b1"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834163", O_RDWR|O_LARGEFILE) = 17
_llseek(17, 143753216, [143753216], SEEK_SET) = 0
write(17, "\342\1\0\0\314!w\7\24\0\0\0\20\t\10J\360\177\1\200\330"...,
32768)
= 32768
close(17) = 0
read(16, "\340\1\0\0\340\204\264\241\24\0\0\0H\2Ty\360\177\1\200"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834170", O_RDWR|O_LARGEFILE) = 17
_llseek(17, 192512000, [192512000], SEEK_SET) = 0
write(17, "\342\1\0\0`\253y\7\24\0\0\0\250\7\330G\360\177\1\200\324"...,
32768) = 32768
close(17) = 0
open("/var/lib/pgsql/data/base/495616/16390", O_RDWR|O_LARGEFILE) = 17
read(17, "\334\1\0\0t\242\23p\24\0\0\0\0\2\210\2\0\200\1\200\24\377"...,
32768) = 32768
open("/var/lib/pgsql/data/base/495616/16396", O_RDWR|O_LARGEFILE) = 18
_llseek(18, 0, [32768], SEEK_END) = 0
open("/var/lib/pgsql/data/base/495616/6834168", O_RDWR|O_LARGEFILE) = 19
_llseek(19, 63471616, [63471616], SEEK_SET) = 0
write(19, "\342\1\0\0\2444\200\7\24\0\0\0$\10\240O\360\177\1\200\330"...,
32768) = 32768
close(19) = 0
_llseek(18, 0, [0], SEEK_SET) = 0
read(18, "\0\0\0\0\20\0\0\0\1\0\0\0$\0\240}\0\200\1\200h\3770\1\320"...,
32768) = 32768
brk(0) = 0x82db000
brk(0x82dd000) = 0x82dd000
open("/var/lib/pgsql/data/base/495616/6834166", O_RDWR|O_LARGEFILE) = 19
_llseek(19, 64290816, [64290816], SEEK_SET) = 0
write(19, "\342\1\0\0<\265\200\7\24\0\0\0d\t`Q\360\177\1\200\334\377"...,
32768) = 32768
close(19) = 0
open("/var/lib/pgsql/data/base/495616/16605", O_RDWR|O_LARGEFILE) = 19
read(19, "\0\0\0\0\20\0\0\0\1\0\0\0\24\0\360\177\360\177\1\200b1"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834163", O_RDWR|O_LARGEFILE) = 20
_llseek(20, 152731648, [152731648], SEEK_SET) = 0
write(20, "\342\1\0\0\264=\206\7\24\0\0\0\370\10\230J\360\177\1\200"...,
32768) = 32768
close(20) = 0
read(19, "\0\0\0\0\20\0\0\0\1\0\0\0\264\3pq\360\177\1\200\300\363"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834170", O_RDWR|O_LARGEFILE) = 20
_llseek(20, 150274048, [150274048], SEEK_SET) = 0
write(20, "\342\1\0\0\230\310\212\7\24\0\0\0\210\7lO\360\177\1\200"...,
32768)
= 32768
close(20) = 0
open("/var/lib/pgsql/data/base/495616/16398", O_RDWR|O_LARGEFILE) = 20
read(20, "\0\0\0\0\20\0\0\0\1\0\0\0\264\3`_\0\200\1\200\334\377H"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834166", O_RDWR|O_LARGEFILE) = 21
_llseek(21, 260046848, [260046848], SEEK_SET) = 0
write(21, "\342\1\0\0\4\322\220\7\24\0\0\0\264\2\320r\360\177\1\200"...,
32768) = 32768
close(21) = 0
open("/var/lib/pgsql/data/base/495616/16639", O_RDWR|O_LARGEFILE) = 21
read(21, "\0\0\0\0\20\0\0\0\1\0\0\0\24\0\360\177\360\177\1\200b1"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834170", O_RDWR|O_LARGEFILE) = 22
_llseek(22, 174424064, [174424064], SEEK_SET) = 0
write(22, "\342\1\0\0\200\\\225\7\24\0\0\0D\t$H\360\177\1\200\330"...,
32768)
= 32768
close(22) = 0
read(21, "\0\0\0\0\20\0\0\0\1\0\0\0\200\t\254c\360\177\1\200\344"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834163", O_RDWR|O_LARGEFILE) = 22
_llseek(22, 109084672, [109084672], SEEK_SET) = 0
write(22, "\342\1\0\0\310\335\226\7\24\0\0\0 \10\250O\360\177\1\200"...,
32768) = 32768
close(22) = 0
open("/var/lib/pgsql/data/base/495616/16392", O_RDWR|O_LARGEFILE) = 22
read(22, "\0\0\0\0\20\0\0\0\1\0\0\0X\3\350\3\0\200\1\200h\3770\1"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834170", O_RDWR|O_LARGEFILE) = 23
_llseek(23, 200900608, [200900608], SEEK_SET) = 0
write(23, "\342\1\0\0\314\344\232\7\24\0\0\0\344\7\304G\360\177\1"...,
32768)
= 32768
close(23) = 0
open("/var/lib/pgsql/data/base/495616/16606", O_RDWR|O_LARGEFILE) = 23
read(23, "\0\0\0\0\20\0\0\0\1\0\0\0\24\0\360\177\360\177\1\200b1"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834168", O_RDWR|O_LARGEFILE) = 24
_llseek(24, 85426176, [85426176], SEEK_SET) = 0
write(24, "\342\1\0\0\30\345\232\7\24\0\0\0\264\7\360V\360\177\1\200"...,
32768) = 32768
close(24) = 0
read(23, "\0\0\0\0\20\0\0\0\1\0\0\0H\1 {\360\177\1\200P\377 \0(at)\377"...,
32768) = 32768
open("/var/lib/pgsql/data/base/495616/6834166", O_RDWR|O_LARGEFILE) = 24
_llseek(24, 156729344, [156729344], SEEK_SET) = 0
write(24, "\342\1\0\0\260e\233\7\24\0\0\0\30\n\334M\360\177\1\200"...,
32768)
= 32768
close(24) = 0
open("/var/lib/pgsql/data/base/495616/16400", O_RDWR|O_LARGEFILE) = 24
read(24, "\0\0\0\0\20\0\0\0\1\0\0\0H\1,u\0\200\1\200\334\377H\0\270"...,
32768) = 32768
open("/var/lib/pgsql/data/base/495616/6834168", O_RDWR|O_LARGEFILE) = 25
_llseek(25, 92995584, [92995584], SEEK_SET) = 0
write(25, "\342\1\0\0\244i\235\7\24\0\0\0\360\ttO\360\177\1\200\324"...,
32768) = 32768
close(25) = 0
open("/var/lib/pgsql/data/base/495616/16607", O_RDWR|O_LARGEFILE) = 25
read(25, "\0\0\0\0\264\341\v\t\16\0\0\0\24\0\360\177\360\177\1\200"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834170", O_RDWR|O_LARGEFILE) = 26
_llseek(26, 209387520, [209387520], SEEK_SET) = 0
write(26, "\342\1\0\0<m\237\7\24\0\0\0\\\7\214H\360\177\1\200\320"...,
32768)
= 32768
close(26) = 0
read(25, "N\1\0\0X\227`\236\23\0\0\0\334\0\320|\360\177\1\200\340"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834168", O_RDWR|O_LARGEFILE) = 26
_llseek(26, 108363776, [108363776], SEEK_SET) = 0
write(26, "\342\1\0\0\334\375\251\7\24\0\0\0\24\10`K\360\177\1\200"...,
32768)
= 32768
close(26) = 0
brk(0) = 0x82dd000
brk(0x82de000) = 0x82de000
open("/var/lib/pgsql/data/base/495616/16384", O_RDWR|O_LARGEFILE) = 26
read(26, "N\1\0\0\244\1H\332\23\0\0\0\360\0\244N\0\200\1\200\270"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834173", O_RDWR|O_LARGEFILE) = 27
_llseek(27, 85000192, [85000192], SEEK_SET) = 0
write(27, "\342\1\0\0\364\0\254\7\24\0\0\0008\txQ\360\177\1\200\334"...,
32768) = 32768
close(27) = 0
read(11, "\334\1\0\0\344\3422.\23\0\0\0t\1\320e\360\177\1\200\244"...,
32768)
= 32768
mmap2(NULL, 266240, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
=
0x404b8000
open("/var/lib/pgsql/data/base/495616/6834163", O_RDWR|O_LARGEFILE) = 27
_llseek(27, 255524864, [255524864], SEEK_SET) = 0
write(27, "\342\1\0\0\34\3\256\7\24\0\0\0\374\10\200J\360\177\1\200"...,
32768) = 32768
close(27) = 0
open("/var/lib/pgsql/data/base/495616/16640", O_RDWR|O_LARGEFILE) = 27
read(27, "\0\0\0\0\20\0\0\0\1\0\0\0\24\0\360\177\360\177\1\200b1"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834170", O_RDWR|O_LARGEFILE) = 28
_llseek(28, 202047488, [202047488], SEEK_SET) = 0
write(28, "\342\1\0\0\240\20\263\7\24\0\0\0\220\7\30H\360\177\1\200"...,
32768) = 32768
close(28) = 0
_llseek(27, 98304, [98304], SEEK_SET) = 0
read(27, "\0\0\0\0\20\0\0\0\1\0\0\0\34\0\224\177\360\177\1\200\350"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834168", O_RDWR|O_LARGEFILE) = 28
_llseek(28, 141524992, [141524992], SEEK_SET) = 0
write(28, "\342\1\0\0$\36\274\7\24\0\0\0p\10(L\360\177\1\200\324\377"...,
32768) = 32768
close(28) = 0
_llseek(27, 32768, [32768], SEEK_SET) = 0
read(27, "\0\0\0\0\20\0\0\0\1\0\0\0\314\5\330\7\360\177\1\200\234"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834166", O_RDWR|O_LARGEFILE) = 28
_llseek(28, 149422080, [149422080], SEEK_SET) = 0
write(28, "\342\1\0\0\250\36\274\7\24\0\0\0\214\3\230n\360\177\1\200"...,
32768) = 32768
close(28) = 0
_llseek(22, 65536, [65536], SEEK_SET) = 0
read(22, "\0\0\0\0\20\0\0\0\1\0\0\0\370\2(\22\0\200\1\200h\3770\1"...,
32768)
= 32768
brk(0) = 0x82de000
brk(0x82e2000) = 0x82e2000
open("/var/lib/pgsql/data/base/495616/6834165", O_RDWR|O_LARGEFILE) = 28
_llseek(28, 125075456, [125075456], SEEK_SET) = 0
write(28, "\342\1\0\0\0\237\274\7\24\0\0\0<\t\0I\360\177\1\200\330"...,
32768)
= 32768
close(28) = 0
read(27, "\0\0\0\0\20\0\0\0\1\0\0\0\314\3\3301\360\177\1\200\234"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834166", O_RDWR|O_LARGEFILE) = 28
_llseek(28, 199000064, [199000064], SEEK_SET) = 0
write(28, "\342\1\0\0\304&\301\7\24\0\0\0\310\nlJ\360\177\1\200\334"...,
32768) = 32768
close(28) = 0
_llseek(22, 32768, [32768], SEEK_SET) = 0
read(22, "\0\0\0\0\20\0\0\0\1\0\0\0X\3\350\3\0\200\1\200h\3770\1"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834168", O_RDWR|O_LARGEFILE) = 28
_llseek(28, 146145280, [146145280], SEEK_SET) = 0
write(28, "\342\1\0\0\224\252\303\7\24\0\0\0\200\2 r\360\177\1\200"...,
32768)
= 32768
close(28) = 0
open("/var/lib/pgsql/data/base/495616/16652", O_RDWR|O_LARGEFILE) = 28
read(28, "\0\0\0\0\20\0\0\0\1\0\0\0\24\0\360\177\360\177\1\200b1"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834170", O_RDWR|O_LARGEFILE) = 29
_llseek(29, 244252672, [244252672], SEEK_SET) = 0
write(29, "\342\1\0\0\0003\310\7\24\0\0\0\260\0074H\360\177\1\200"...,
32768)
= 32768
close(29) = 0
read(28, "\340\1\0\0\30*\262\241\24\0\0\0\210\4\224r\360\177\1\200"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834163", O_RDWR|O_LARGEFILE) = 29
_llseek(29, 2228224, [2228224], SEEK_SET) = 0
write(29, "\342\1\0\0h\264\310\7\24\0\0\0\34\10\300O\360\177\1\200"...,
32768)
= 32768
close(29) = 0
open("/var/lib/pgsql/data/base/495616/1247", O_RDWR|O_LARGEFILE) = 29
read(29, "\0\0\0\0\244\5\201\0\v\0\0\0H\3\224\3\0\200\1\200h\377"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834163", O_RDWR|O_LARGEFILE) = 30
_llseek(30, 20316160, [20316160], SEEK_SET) = 0
write(30, "\342\1\0\0(at)\270\312\7\24\0\0\0P\10\210N\360\177\1\200\330"...,
32768) = 32768
close(30) = 0
open("/var/lib/pgsql/data/base/495616/16612", O_RDWR|O_LARGEFILE) = 30
read(30, "\0\0\0\0\20\0\0\0\1\0\0\0\24\0\360\177\360\177\1\200b1"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834173", O_RDWR|O_LARGEFILE) = 31
_llseek(31, 12058624, [12058624], SEEK_SET) = 0
write(31, "\342\1\0\0\340\301\320\7\24\0\0\0l\7 N\360\177\1\200\334"...,
32768) = 32768
close(31) = 0
read(30, "\0\0\0\0\20\0\0\0\1\0\0\0\320\2\0u\360\177\1\200p\372 "..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834168", O_RDWR|O_LARGEFILE) = 31
_llseek(31, 281968640, [281968640], SEEK_SET) = 0
write(31, "\342\1\0\0$\317\331\7\24\0\0\0\270\1,w\360\177\1\200\334"...,
32768) = 32768
close(31) = 0
open("/var/lib/pgsql/data/base/495616/16418", O_RDWR|O_LARGEFILE) = 31
read(31, "\0\0\0\0\20\0\0\0\1\0\0\0\320\2\354a\0\200\1\200\324\377"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834170", O_RDWR|O_LARGEFILE) = 32
_llseek(32, 336003072, [336003072], SEEK_SET) = 0
write(32, "\342\1\0\0\264Z\340\7\24\0\0\0D\0104H\360\177\1\200\330"...,
32768)
= 32768
close(32) = 0
open("/var/lib/pgsql/data/base/495616/16641", O_RDWR|O_LARGEFILE) = 32
read(32, "\0\0\0\0\\\242I\0\10\0\0\0\24\0\360\177\360\177\1\200b"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834166", O_RDWR|O_LARGEFILE) = 33
_llseek(33, 138903552, [138903552], SEEK_SET) = 0
write(33, "\342\1\0\0\300u\355\7\24\0\0\0\334\4\10h\360\177\1\200"...,
32768)
= 32768
close(33) = 0
_llseek(32, 98304, [98304], SEEK_SET) = 0
read(32, "\0\0\0\0\\\242I\0\10\0\0\0\34\0\334\177\360\177\1\200\350"...,
32768) = 32768
open("/var/lib/pgsql/data/base/495616/6834165", O_RDWR|O_LARGEFILE) = 33
_llseek(33, 6062080, [6062080], SEEK_SET) = 0
write(33, "\342\1\0\0t~\360\7\24\0\0\0\4\10PP\360\177\1\200\330\377"...,
32768) = 32768
close(33) = 0
_llseek(32, 32768, [32768], SEEK_SET) = 0
read(32, "\0\0\0\0\200\20\276\0\v\0\0\0\0\17,S\360\177\1\200\344"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834163", O_RDWR|O_LARGEFILE) = 33
_llseek(33, 17596416, [17596416], SEEK_SET) = 0
write(33, "\342\1\0\0\314\376\360\7\24\0\0\0\24\10\360O\360\177\1"...,
32768)
= 32768
close(33) = 0
open("/var/lib/pgsql/data/base/495616/1255", O_RDWR|O_LARGEFILE) = 33
_llseek(33, 458752, [458752], SEEK_SET) = 0
read(33, "\0\0\0\0\270\10\276\0\v\0\0\0\300\1\370\1\0\200\1\2000"..., 32768)
=
32768
brk(0) = 0x82e2000
brk(0x82e4000) = 0x82e4000
brk(0) = 0x82e4000
brk(0x82e6000) = 0x82e6000
brk(0) = 0x82e6000
brk(0x82e7000) = 0x82e7000
open("/var/lib/pgsql/data/base/495616/6834168", O_RDWR|O_LARGEFILE) = 34
_llseek(34, 242122752, [242122752], SEEK_SET) = 0
write(34, "\342\1\0\0\340\201\362\7\24\0\0\0\224\2\334r\360\177\1"...,
32768)
= 32768
close(34) = 0
read(15, "\0\0\0\0\320r\37\0\5\0\0\0\364\3\0\4\0\200\1\200\200\377"...,
32768)
= 32768
brk(0) = 0x82e7000
brk(0x82e8000) = 0x82e8000
open("/var/lib/pgsql/data/base/495616/6834166", O_RDWR|O_LARGEFILE) = 34
_llseek(34, 242810880, [242810880], SEEK_SET) = 0
write(34, "\342\1\0\0d\202\362\7\24\0\0\0P\3\304o\360\177\1\200\334"...,
32768) = 32768
close(34) = 0
open("/var/lib/pgsql/data/base/495616/16629", O_RDWR|O_LARGEFILE) = 34
read(34, "\0\0\0\0\20\0\0\0\1\0\0\0\24\0\360\177\360\177\1\200b1"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834165", O_RDWR|O_LARGEFILE) = 35
_llseek(35, 33292288, [33292288], SEEK_SET) = 0
write(35, "\342\1\0\0\234\231\375\7\24\0\0\0(\10xO\360\177\1\200\330"...,
32768) = 32768
close(35) = 0
read(34, "\340\1\0\0\244\204\264\241\24\0\0\0H\2Ty\360\177\1\200"..., 32768)
=
32768
brk(0) = 0x82e8000
brk(0x82e9000) = 0x82e9000
brk(0) = 0x82e9000
brk(0x82eb000) = 0x82eb000
brk(0) = 0x82eb000
brk(0x82ec000) = 0x82ec000
brk(0) = 0x82ec000
brk(0x82ed000) = 0x82ed000
open("/var/lib/pgsql/data/base/495616/6834163", O_RDWR|O_LARGEFILE) = 35
_llseek(35, 4456448, [4456448], SEEK_SET) = 0
write(35, "\342\1\0\0\364\31\376\7\24\0\0\0\34\10\300O\360\177\1\200"...,
32768) = 32768
open("/var/lib/pgsql/data/base/495616/16647", O_RDWR|O_LARGEFILE) = 36
read(36, "\0\0\0\0\4\307}\0\v\0\0\0\24\0\360\177\360\177\1\200b1"..., 32768)
=
32768
brk(0) = 0x82ed000
brk(0x82ee000) = 0x82ee000
open("/var/lib/pgsql/data/base/495616/6834170", O_RDWR|O_LARGEFILE) = 37
_llseek(37, 265158656, [265158656], SEEK_SET) = 0
write(37, "\342\1\0\0(at)\34\377\7\24\0\0\0\224\7lG\360\177\1\200\324"...,
32768)
= 32768
read(36, "\336\1\0\0000\327V\272\24\0\0\0\210\5 j\360\177\1\200@"..., 32768)
=
32768
_llseek(35, 161415168, [161415168], SEEK_SET) = 0
write(35, "\342\1\0\0p\35\0\10\24\0\0\0D\t\320H\360\177\1\200\330"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/16408", O_RDWR|O_LARGEFILE) = 38
read(38, "\336\1\0\0\224\273V\272\24\0\0\0H\2h\2\0\200\1\2004\377"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/6834173", O_RDWR|O_LARGEFILE) = 39
_llseek(39, 133332992, [133332992], SEEK_SET) = 0
write(39, "\342\1\0\0\34\340(\10\24\0\0\0p\3\334l\360\177\1\200\330"...,
32768) = 32768
open("/var/lib/pgsql/data/base/495616/16604", O_RDWR|O_LARGEFILE) = 40
read(40, "\0\0\0\0\20\0\0\0\1\0\0\0\24\0\360\177\360\177\1\200b1"..., 32768)
=
32768
_llseek(39, 244875264, [244875264], SEEK_SET) = 0
write(39, "\342\1\0\0\264\343*\10\24\0\0\0L\2Ht\360\177\1\200\334"...,
32768)
= 32768
read(40, "\0\0\0\0\20\0\0\0\1\0\0\0\264\3pq\360\177\1\200\340\366"...,
32768)
= 32768
_llseek(37, 119635968, [119635968], SEEK_SET) = 0
write(37, "\342\1\0\0\350k.\10\24\0\0\0\334\6(N\360\177\1\200\324"...,
32768)
= 32768
_llseek(38, 65536, [65536], SEEK_SET) = 0
read(38, "\336\1\0\0\214\272V\272\24\0\0\0\334\0\370\0\0\200\1\200"...,
32768)
= 32768
_llseek(37, 103841792, [103841792], SEEK_SET) = 0
write(37, "\342\1\0\0\24t3\10\24\0\0\0\300\6(at)M\360\177\1\200\324\377"...,
32768) = 32768
_llseek(38, 32768, [32768], SEEK_SET) = 0
read(38, "\336\1\0\0\260\325V\272\24\0\0\0000\2\200\2\0\200\1\200"...,
32768)
= 32768
brk(0) = 0x82ee000
brk(0x82f0000) = 0x82f0000
brk(0) = 0x82f0000
brk(0x82f2000) = 0x82f2000
gettimeofday({1079482178, 920849}, NULL) = 0
brk(0) = 0x82f2000
brk(0x82f4000) = 0x82f4000
brk(0) = 0x82f4000
brk(0x82f6000) = 0x82f6000
brk(0) = 0x82f6000
brk(0x82fa000) = 0x82fa000
brk(0) = 0x82fa000
brk(0x8302000) = 0x8302000
_llseek(37, 79331328, [79331328], SEEK_SET) = 0
write(37, "\342\1\0\0\200\3747\10\24\0\0\0\300\0068N\360\177\1\200"...,
32768)
= 32768
open("/var/lib/pgsql/data/base/495616/16653", O_RDWR|O_LARGEFILE) = 41
read(41, "\0\0\0\0\20\0\0\0\1\0\0\0\24\0\360\177\360\177\1\200b1"..., 32768)
=
32768
open("/var/lib/pgsql/data/base/495616/6834168", O_RDWR|O_LARGEFILE) = 42
_llseek(42, 262144, [262144], SEEK_SET) = 0
write(42, "\342\1\0\0000\3758\10\24\0\0\0\0\6Xb\360\177\1\200\320"...,
32768)
= 32768
read(41, "\340\1\0\0\224*\262\241\24\0\0\0\210\4T+\360\177\1\200"..., 32768)
=
32768
brk(0) = 0x8302000
brk(0x8304000) = 0x8304000
gettimeofday({1079482178, 957454}, NULL) = 0
gettimeofday({1079482178, 957580}, NULL) = 0
send(6, "\4\0\0\0\334\3\0\0\7\0\0\0zU\0\0\0\220\7\0\1\0\0\0\16\0"..., 988,
0)
= 988
send(6, "\4\0\0\0\334\3\0\0\7\0\0\0zU\0\0\0\220\7\0\1\0\0\0\16\0"..., 988,
0)
= 988
send(6, "\4\0\0\0\334\3\0\0\7\0\0\0zU\0\0\0\220\7\0\1\0\0\0\16\0"..., 988,
0)
= 988
send(6, "\4\0\0\0\274\1\0\0\7\0\0\0zU\0\0\0\220\7\0\1\0\0\0\6\0"..., 444, 0)
=
444
send(9, "T\0\0\0#\0\1QUERY PLAN\0\0\0\0\0\0\0\0\0\0\31\377\377\377"..., 394,
0) = 394
recv(9, "X\0\0\0\4", 8192, 0) = 5
exit_group(0) = ?

/rls

--
Rosser Schwarz
Total Card, Inc.