AgensGraph: Allowing the familiar developing environment for PostgreSQL
For the recent few years, a lot of developers, data analysts, and operators working with PostgreSQL were hungry for change. Known as one of the best…
Why AgensGraph: PostgreSQL Compatibility
Why AgensGraph: PostgreSQL Compatibility For the recent few years, a lot of developers, data analysts, and operators working with PostgreSQL were hungry for…
Constant Values in PostgreSQL
To get some records you want from the database or to store data into the database, you should use some constant values (literals) when…
PostgreSQL internals: JSONB type and its indexes
After the JSON datatype became one of the primitive data types in PostgreSQL, there have been many improvements and many related materials have been…
Enhancive PostgreSQL opens up the New Way
The Potential of PostgreSQL The EnterpriseDB’s PostgreSQL software is being enhanced, adding a host of tools to the PostgreSQL to challenge big commercial database….
What is PostGIS?
PostGIS is a spatial data type for PostgreSQL. Non-spatial types have functions that do things to them (substring(), trim(), cos() , etc.) and indexes to…
PostgreSQL’s Indexes
We use the index to increase the performance of the queries. If the required rows are relatively smaller than the table, it can take advantage…
Reviews on Uber’s Choice – Migrating from PostgreSQL to MySQL
The recently announced Uber’s blog post, entitled “Why Uber Engineering Switched from Postgres to MySQL[1]”, is a huge issue at PostgreSQL communities, but also other…
RelCache in PostgreSQL
Postgres Database contains one or more schemas and schema contains objects including relations. Schema is a kind of namespace, so relations and other objects exist…
PostgreSQL Solves The Data Dilemma of Medical Center
PostgreSQL is widely considered to be the world’s most advanced open source database. PostgreSQL was established at the University of California, Berkeley in 1986 and…