Re: Extremely slow DELETE with cascade foreign keys

2017-12-05 Thread Tom Lane
Alvaro Herrera writes: > 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: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 Alvaro Herrera
Rodrigo Rosenfeld Rosas wrote: > explain analyze delete from field_values where transaction_id=226; > QUERY PLAN > --- >  Delete on

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 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 ANALYSE and 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