Re: [PERFORM] Avoid long-running transactions in a long-runningstored procedure?

good, though. Thanks, David Crane -Original Message- From: Ow Mun Heng [mailto:[EMAIL PROTECTED] Sent: Thursday, February 14, 2008 8:31 PM To: [EMAIL PROTECTED] Cc: pgsql-performance@postgresql.org; David Crane Subject: Re: [PERFORM] Avoid long-running transactions in a long-runnings

[PERFORM] Avoid long-running transactions in a long-running stored procedure?

t need anything like SERIALIZATION transaction isolation of the online system from the entire load job. Thanks for any ideas, David Crane DonorsChoose.org

[PERFORM] Can I Determine if AutoVacuum Does Anything?

actor = 0.04 autovacuum_analyze_scale_factor = 0.02 autovacuum_vacuum_cost_delay = 10 autovacuum_vacuum_cost_limit = -1 I was suspicious that the stat_row_level might not work because stat_block_level is off. But I see pg_stat_user_tables.n_tup_ins, pg_stat_user_tables.n_tup_upd and pg_st