4 ms·
Which ones? I know you can in SQL Server but not as cleanly as this. It's done transparently by PG.
by why-el 7y ago
Which ones? I know you can in SQL Server but not as cleanly as this. It's done transparently by PG.
- tomnipotent 7y ago> but not as cleanly as this. SQL Server looks pretty clean to me. ALTER INDEX IX_name ON schema.table REBUILD WITH (ONLINE=ON);
- ken 7y agoI've not used it myself, but it was my understanding that Oracle did this. Phil Greenspun, in the mid-1990's [1]: > "In Oracle, readers never wait for writers or vice versa. I can serve my 18,000 daily users. I can EXPORT a consistent backup dump. I can update a 20,000 row table. I can rebuild an index. All simultaneously." [1]: http://philip.greenspun.com/wtr/oracle-tips.html http://philip.greenspun.com/wtr/oracle-tips.html
- nickpeterson 7y agoIn that context, I think he was referencing multi version concurrency control, but your point remains.