PostgreSQL

PostgreSQL is the world’s most advanced open source object-relational database management system. It was developed by the PostgreSQL Global Development Group.

セッション状態のfailover
October 23, 2017
On the server side, high availability means having the ability to quickly failover to standby hardware, hopefully with no data loss. Failover...
IPv6を楽しむ
October 17, 2017
Now that everyone is using IPv6 ( ) it might be time to start playing with it. Postgres has had full IPv6 support for years, so Postgres is a good...
Odd Month Arithmetic
October 10, 2017
You might be aware of the interval data type, which allows mathematical operations on date, time, and timestamp values. This can lead to odd behavior...
タイムゾーンとの使用
October 03, 2017
If you often use the timestamp data type, you might not be making full use of it. In these queries: CREATE TABLE tztest (x TIMESTAMP ); INSERT INTO...
PostgreSQLのハッシュindexesは、現在、流行の真っただ中です
September 26, 2017
*/ Since I just committed the last pending patch to improve hash indexes to PostgreSQL 11, and since most of the improvements to hash indexes were...
PL/Java Adoption
September 19, 2017
PL/Java has been around since 2005, but it has regularly struggled to gain users. Unfortunately, a lot of these problems are specific to the Java...
When to Use Server-Side Logic
September 12, 2017
The use of server-side logic, particularly stored procedures, has been a highly contentious topic among database professionals for decades. The...
Which NoSQL Database for New Project?
2017年8月31日
Oh, how I love the title of this 2014 Slashdot request, "Which NoSQL Database For New Project?" The user already knows the type of clients (iPhones...
You Don't Need Every Feature of Your Previous Database
2017年8月08日
In a March blog post I talked about the mismatch between what people expect from Postgres in terms of hints, and what exists. In this blog post I...
Outer Joins and Where Clauses
July 19, 2017
*/ Postgres supports both traditional join syntax , which uses the where clause to specify joined columns, and ansi join syntax, that uses the word...