Re: DELETE Query Hang

2019-11-12 Thread Rob Sargent
> 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

2019-11-12 Thread DrakoRod
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

2019-11-12 Thread Rob Sargent
> 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