Sv: DELETE Query Hang

På tirsdag 12. november 2019 kl. 23:47:18, skrev DrakoRod < drakofla...@hotmail.com >: Hi folks! I Have a question, in a database are a table with many files (bytea) stored (I support this database a don't design it), but we need delete many rows (38000 rows ap

Re: DELETE Query Hang

> On Nov 12, 2019, at 4:01 PM, DrakoRod wrote: > > I understand, yep is a 9.5 version, Can I use query like this to execute > smaller batches?: > > DELETE FROM my_table > WHERE id IN ( >SELECT id >FROM logtable >LIMIT 10 > ); > > Thanks > I think you still want to qualify as yo

Re: DELETE Query Hang

I understand, yep is a 9.5 version, Can I use query like this to execute smaller batches?: DELETE FROM my_table WHERE id IN ( SELECT id FROM logtable LIMIT 10 ); Thanks - Dame un poco de fe, eso me bastará. Rozvo Ware Solutions -- Sent from: https://www.postgresql-archive.org

Re: DELETE Query Hang

> On Nov 12, 2019, at 3:47 PM, DrakoRod wrote: > > Hi folks! > > I Have a question, in a database are a table with many files (bytea) stored > (I support this database a don't design it), but we need delete many rows > (38000 rows approx), but I when execute query: > > BEGIN; > ALTER TABL

DELETE Query Hang

Hi folks! I Have a question, in a database are a table with many files (bytea) stored (I support this database a don't design it), but we need delete many rows (38000 rows approx), but I when execute query: BEGIN; ALTER TABLE my_file_table DISABLE TRIGGER ALL; DELETE FROM my_file_table WHERE i