COPY in PostgreSQL: Moving data between servers
More than copy data between a file and a table: a pretty cool feature was added to PostgreSQL. You can send data directly to the UNIX pipe.
A formula to calculate "pgbench" scaling factor for target DB size
This blog post shows you how to calculate pgbench scaling factors for target database size in PostgreSQL.
Preparing data for machine learning in PostgreSQL
Most of the code related to machine learning available today is overloaded. Why not prepare the data in SQL? It's easier & more flexible.
Security matters - hiding a table column - restrict column access
How to restrict column access. The best option for hiding table columns in a non-destructive way is the rule system.
Creating 1 million users in PostgreSQL
“How many users can you have in PostgreSQL?” - “Well, as many as you want.” Here's how to easily create a large number of database users.
Using "lightweight" functional indexes - BRIN
When it alters columns in queries, Postgres loses statistics, and it can cause slow queries. Fix it with BRIN functional indexes.
How we built our cluster in a box
During this year's pgconf.eu we displayed a "cluster in a box" demo case with Patroni. Many of you inquired about how […]
Verifying PostgreSQL replicas
How to verify replicas in PostgreSQL: After building a new replica there's no easy way to tell if everything is fine with the new replica.
Visualizing data in PostgreSQL with R Shiny
R is excellent for data analysis and graphics. Here's how to write an R application visualize data in a PostgreSQL database with R Shiny
PostgreSQL Showcase project - helping newcomers to get on track with Postgres
A collection of easy to follow SQL samples, from basics to advanced, which shows how to use PostgreSQL and its features.