On Mon, Dec 9, 2024 at 6:03 AM Lars Aksel Opsahl <lars.ops...@nibio.no> wrote:
> In one case, we processed a total of 750 cells, with an overall runtime of > 40 hours. However, one specific cell took over 12 hours to complete, most > of which was spent on removing small areas by deleting edges in PostGIS > Topology. The root cause of this delay is related to removal of dead rows. > Can you please expand exactly what you mean by "removal of dead rows" here, and what the exact issue you are facing is? > By introducing periodic COMMIT statements and VACUUM (FULL) operations > Vacfull is a pretty rough solution, and almost always not the correct tool for the job, IMHO. Yes there are very good reason for the way removal for dead rows work now, > but is there any chance of adding an option when creating table to disable > this behavior for instance for unlogged tables ? > It's still not clear exactly what the ask is here, but there is little chance we would design an alternative MVCC system just to accommodate this use case. Cheers, Greg
