PostgreSQL Study Notes

According to previous colleagues, this database is faster than oracle. I want to perform a test.

The test content is very simple. The same table structure and the same amount of data are counted several times to compare to the average time.

The first is the table structure, which has three fields: month_id, password, and user_no, which are varchar, varchar, and number. 30207104 data records. It's not big, but it's not small. It's quite impressive for me.

The first is PostgreSQL. View the result directly:

11 seconds, good speed.

Let's look at Oracle:

14 seconds, a little disappointing.

Although the comparison efficiency should be viewed by the execution plan, because it is two different databases, the comparability of the execution plan is not very large, so this approach is used for comparison.

But at least it proves a little. This pure free database PG can rival the commercial oracle in terms of performance. It is indeed a good choice for companies with insufficient funds. However, I believe that if it is nosql, it should be more efficient. Please study later.