Hacker News new | ask | show | jobs
by daneel_w 48 days ago
> So you open transaction, insert multiple rows, commit?

Pretty much, yes. High volume rapid multi-row INSERTs. Nothing special involved in the DDL or how the data goes into the table. Vacuuming the table (whether automatically or between every 10-20m rows) makes no difference. The indices still penalize the performance substantially the larger they grow.