PostgreSQL contains many important functions. Many of them are very famous. Others can be very useful, but not widely appreciated. The following are our preferred PostgreSQL functions. You may not have seen them carefully, but you should actually do so because they can

Now that MySQL 8 and PostgreSQL 10 have been released, it is time to review how these two open source relational databases compete with each other. Before these versions, it was generally believed that Postgres performed better in the feature set because of its "academic" style

If you have used Postgres for some performance optimization, you may have used EXPLAIN. EXPLAIN shows you the execution plan generated by PostgreSQL planner for the statements provided. It indicates that the table involved in the statement will use sequential scanning, indexing

At Amplitude, our goal is to provide easy-to-use interactive product analysis services, so that everyone can find their answers to product questions. In order to provide a good user experience, Amplitude needs to quickly provide these answers. So, when one of us

Analyze the optimization techniques that can be used in different situations in PostgreSQL, and learn how to count in parallel in a distributed database. Everyone counts optimizations - but not always fast. This article will carefully study how PostgreSQL optimizes counting. If you know this

I like pizza. I'm kidding. I like pizza. Especially if it is free. I even like things that look like free pizza. One day, a package came to my mailbox, which was wrapped in a pizza box. I will give Etsy shopkeeper five stars

How to use PostgreSQL functions and triggers in Golang? Triggers in PostgreSQL are a simple but powerful mechanism that can reflect the changes taking place in tables. The following describes how to write PostgreSQL triggers in Go

The locking mechanism is very important in PostgreSQL (also for other modern RDBMSs). For database application developers (especially those involved in high concurrency code), they need to be very familiar with locks. For some problems, locks need to be focused on

In the past few months, I have been thinking about and trying to implement the transaction function of lua script in Redis. Not many people understand my idea, so I will explain it to you through some history. MySQL and Postgres in 1998-2003, if you

Olery was founded almost five years ago. The single product (Olery Reputation) started from Ruby agent development. Over time, we began to focus on a series of different products and applications. Today, our products include not only (Olery) Reputation, but also O

You may not know that PostgreSQL supports local indexing of table data, do you? Its advantage is that it can speed up the reading of the indexed data without adding additional overhead For the data read out repeatedly according to the given WHERE clause, the best

PostgreSQL 9.3 uses a new union type! The introduction of the Lateral Union is relatively low-key, but it implements powerful new queries that previously needed to be written In this article, I will introduce a channel that cannot be implemented in PostgreSQL 9.2

POSTGRESQL is an object relational database developed by a group of network developers from around the world. It is an open source version that can replace commercial databases such as Oracle and Informix. POSTGRESQL was originally developed by the University of California, Berkeley. In 1996, a group

PostgreSQL 9.4 is loading a new function called jsonb, which is a new type of data that can store JSON data that supports GIN indexing. In other words, the most important thing about this function in the upcoming update is that if it is not even important, then put Postgres in

Compare two relational databases from the perspective of a data analyst. 0. What is this article about? I work as a data analyst in a global professional service company (you must have heard of it). I worked for about 10 years. I deal with data, database software, database hardware

When developing a Web application, you often need to add a search function. Even without knowing what to search for, I drew a magnifying glass on the sketch. Search is a very important function, so Lucene based tools like elastic search and SOLR have become very popular. They are very

This afternoon I wanted to test DragonFly dports. Suddenly, I thought why not compare the performance of PostgreSQL under BSD and Linux. For this reason, I set some standards to compare the performance differences on different operating systems. I use the same hardware and software to

When I heard many people say how great Docker is and how many trendy children are using it, I decided to try it in my development environment. In the following article, I will explain how to establish Postgres, Elasticsearch and Redis in Mac OS X

The next generation of asynchronous multiple master database replication system Bucardo 5 was released. This version removes the restriction of two database sources in the old version, allowing more source databases (i.e. primary databases) and more target databases (i.e. backup databases). Bucardo can also copy

In the first part, we discussed the depth detection when creating collections and inserting JSON objects. In this section, we will overwrite the saved data and build a WHERE clause from the MongDB query to retrieve the data we have written. Saving data to a collection is simple. First of all, I