PostgreSQL: ltree vs. WITH RECURSIVE
WITH RECURSIVE in PostgreSQL is efficient. However, ltree does have its strengths as well. Let us take a closer look. | Improve performance
Binary data performance in PostgreSQL
by
Laurenz Albe |
05.2020 A frequently asked question in this big data world is whether it is better to store binary data inside […]
CREATE CAST: Casting integer to IP in PostgreSQL
How to store and process IP addresses in an efficient way. To do so PostgreSQL provides us with data types by casting integer.
Import stock market data into PostgreSQL
The internet is full of people who want to import stock market data into a database. How can data be imported into PostgreSQL nicely?
Reducing the number of columns with bit
How to reduce the number of columns using bitfields in PostgreSQL. "bit” can be used just as a normal char data type.
