3 ms·
DB design and implementation has always fascinated me. How can they build a concurrent index when ten of thousands of records are in and perhaps thousands are t
by yeukhon 9y ago
DB design and implementation has always fascinated me. How can they build a concurrent index when ten of thousands of records are in and perhaps thousands are throwing out (although in seriousness deleting a row is always a bad idea).
- ddorian43 9y agoYou can read the explanation: https://www.postgresql.org/docs/9.5/static/sql-createindex.html#SQL-CREATEINDEX-CONCURRENTLY https://www.postgresql.org/docs/9.5/static/sql-createindex.h...