Re: [PERFORM] Hanging query on a fresh restart

On Friday, November 13, 2015 3:41 PM, Jim Nasby wrote: > On 11/10/15 3:42 PM, Jason Jho wrote: >> We using Postgres 9.3.10 >> What is the most confusing part in all of this is why a DROP >> SCHEMA CASCADE and a fresh pg_restore would somehow fix the >> problem. Even a

Re: [PERFORM] Recursive query performance issue

Had the issue again today. Here is vmstat : procs ---memory-- ---swap-- -io -system-- cpu r b swpd free buff cache si sobibo in cs us sy id wa 24 0 0 1591718656 605656 49937033600 0 37100 7 1 93 0 25 0