Re: Extremely slow DELETE with cascade foreign keys

2017-12-05 Thread Rodrigo Rosenfeld Rosas
Em 05-12-2017 14:43, Alvaro Herrera escreveu: Rodrigo Rosenfeld Rosas wrote: explain analyze delete from field_values where transaction_id=226; QUERY PLAN

Re: Extremely slow DELETE with cascade foreign keys

2017-12-05 Thread Rodrigo Rosenfeld Rosas
Em 05-12-2017 14:27, Tom Lane escreveu: Rodrigo Rosenfeld Rosas <rr.ro...@gmail.com> writes: Hi, I think something changed recently in my development environment as I don't recall deletes being so slow before. I've created a new dump and restored to a new database, ran VACUUM FULL A

Extremely slow DELETE with cascade foreign keys

2017-12-05 Thread Rodrigo Rosenfeld Rosas
Hi, I think something changed recently in my development environment as I don't recall deletes being so slow before. I've created a new dump and restored to a new database, ran VACUUM FULL ANALYSE and a simple delete takes forever as you can see here: explain analyze delete from