サクサク読めて、アプリ限定の機能も多数!
トップへ戻る
TGS2024
www.depesz.com
Recently, on irc, there were couple of cases where someone wanted to use uuid as datatype for their primary key. I opposed, and tried to explain, but IRC doesn't really allow for longer texts, so figured I'll write a blogpost. First problem – UUID values are completely opaque. That means – uuids generated for table sessions will be indistinguishable from the ones for table users. If you're using n
Please read also about this change in Pg 9.1, and this change in Pg 9.2 posts, as they explain that since Pg 9.1 some of the limitations listed in this post are no longer there. END OF UPDATE Fight! But more seriously – people tend to use various data types, and there have been some myths about them, so let's see how it really boils down. First of all – All those data types are internally saved us
The BIG feature. The feature that made PostgreSQL leap from 8.4 to 9.0. Patch was written by Fujii Masao, and committed by Heikki Linnakangas on 15th of January 2010: Log Message: ----------- Introduce Streaming Replication. This includes two new kinds of postmaster processes, walsenders and walreceiver. Walreceiver is responsible for connecting to the primary server and streaming WAL to disk, whi
このページを最初にブックマークしてみませんか?
『select * from depesz;』の新着エントリーを見る
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く