t...@exquisiteimages.com writes: > I started an Analyze command on a database Wednesday evening at around > 9:00PM. it is now Friday morning at 8:00 and it is still running. > ... > I did try to execute: > SELECT pg_cancel_backend(4029); > and > SELECT pg_terminate_backend(4029); > but neither had any effect.
Hm, that's interesting. Can you get a stack trace from that process? https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend > I am running PostgreSQL version 9.3 on Ubuntu 14.04 with 128GB of > memory, 800GB PCIe SSD for Database files, 1TB SATA SSD for WAL, 512GB > SATA SSD for system files. 9.3.what exactly? (You do know that 9.3.x is out of support, so even if this investigation reveals a bug, we're not going to fix it in 9.3.x. I'm willing to look anyway on the chance that there's a bug that also affects later versions.) regards, tom lane
