[GENERAL] Re: how to calculate or know seq_scan scan how many blocks every time

hello everyone who can explain it ?thanks! -- View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-calculate-or-know-seq-scan-scan-how-many-blocks-every-time-tp5717892p5718082.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via

[GENERAL] how to calculate or know seq_scan scan how many blocks every time

hello: i know oracle scatter read blocks,can set db_file_multiblock_read_count every time, i see postgres,it exists scatter read blocks,it is seq_scan,how to know scan many bloks every time? -- View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-calculate-or-know-

[GENERAL] postgresql ask for someparameters

hello everyone: i found database crashed,i checked log,it indicated error: CONTEXT: xlog redo insert: rel 48777166/22362/48778276; tid 2/2 i wanted to know:what's meaning of real? and what's meaning of 48777166/22362/48778276 ?what's meaning of tid 2/2 ? please tell m

Re: [GENERAL] postgresql log indicate too many execute S_2:COMMIT

my postgres version is 9.1.2.my machine is dell R710.3000 sessions connect to database concurrently,then doing some insert,delete,update. your meaning my database bottleneck is disk io slowly.i use local disk.i know transaction log need to wirte to disk. thanks.i will monitor it. -

Re: [GENERAL] postgresql standby using pg_archivecleanup don't work

hello: i try it,but it nothing in pg_log.it still don't work! -- View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-standby-using-pg-archivecleanup-don-t-work-tp5669340p5672191.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent

[GENERAL] postgresql log indicate too many execute S_2:COMMIT

Hello: I test postgresql database performance recently,i set log_min_duration_statement=1000; i monitor pg_log file,i find too many execue S_2:commit 10.0.44.21:30170:2012-04-28 11:38:46.340 CSTLOG: duration: 1050.679 ms execute S_2: COMMIT 10.0.44.21:30208:2012-04-28 11:38:46.340 CSTLOG: d

[GENERAL] postgresql standby using pg_archivecleanup don't work

i have one parimary ,two standby. one standby using stream replication connect to primary.another standby using basebackup,then recovery database --cp archivelog from primary using crontab.i want to delete old archivelog from standby.but configure pg_archivecleanup don't work,meantime no error in p

[GENERAL] what happens when concurrent index create

i read documents,i find it that concurrent index create don't lock write.but need scan table twice.it explain is following as: It scans the table once to initially build the index, then makes a second pass to look for things added after the first pass. please explain 1. what happens when concu