Tag Archives: counter

ScyllaDB 1.7 要支援 Cassandra 的 Counter 了

Counter 是 Cassandra 裡一個特別的資料型態,總算是要 porting 進 ScyllaDB 了:「Scylla 1.7 introduces experimental support for counters」。 由於資料結構的特殊性,在文章裡有提到想像得到的限制: once deleted, counter column value cannot be used again—this is a consequence of the fact that counters can only be incremented or decremented, they cannot … Continue reading

Posted in Computer, Database, Murmuring, Network, Software | Tagged , , , , , , | Leave a comment

Amazon EC2 上的 gettimeofday 與 clock_gettime 的效能

看到「Two frequently used system calls are ~77% slower on AWS EC2」這篇在講 gettimeofday 與 clock_gettime 的效能,另外搜資料時發現應該也是作者提問的「gettimeofday() not using vDSO?」這篇。 在 EC2 比較新的機器上用 tsc 應該是沒問題的 (在 2015 的時候官方就這樣建議了): it seems tsc support in Xen has improved with version 4.0 and with improved … Continue reading

Posted in AWS, Cloud, Computer, Hardware, Linux, Murmuring, Network, OS, Software | Tagged , , , , , , , , , , , , , | Leave a comment

PostgreSQL 9.5 釋出,UPSERT!

PostgreSQL 9.5 正式發行,這次新增了大家期待已久的 UPSERT 功能:「PostgreSQL 9.5: UPSERT, Row Level Security, and Big Data」。 SQL:2003 正式定義出 UPSERT,被稱為 Merge,不過看網路上一般還是比較習慣 UPSERT 這個用法: A relational database management system uses SQL MERGE (also called upsert) statements to INSERT new records or UPDATE existing records depending … Continue reading

Posted in Computer, Database, Murmuring, PostgreSQL, Programming, Software | Tagged , , , , , , , , , , , | Leave a comment