Re: [PERFORM] EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT

>Hi, >we are seeing cases of EXPLAIN INSERT INTO foo SELECT ... taking over an hour, >with disk I/O utilization (percent of time device is busy) at 100% the whole >time, although I/O bandwidth is not saturated. This is on PostgreSQL 9.1.13. >What could cause this? Note that there is no ANALYZE. I

[PERFORM] slow server : s_lock and _bt_checkkeys on perf top

Hello All, Master db size 1.5 TB All postgres 9.1.13 installed from RHEL package. It has streaming replica and slony replica to another servers. Server performance is slower than usual, before that, there's a big query got cancelled and then performance get slow. No sign of IO wait. on sar, it'

[PERFORM] EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT

Hi, we are seeing cases of EXPLAIN INSERT INTO foo SELECT ... taking over an hour, with disk I/O utilization (percent of time device is busy) at 100% the whole time, although I/O bandwidth is not saturated. This is on PostgreSQL 9.1.13. What could cause this? Note that there is no ANALYZE. Is it