Latest posts from Joe Conway
Kubernetes + Postgres Cluster From Scratch on Rocky 8
How to create a Kubernetes cluster from scratch, including getting it to run with cgroup v2 and swap turned on.
8 min read%20(1).jpg)
Musings of a PostgreSQL Data Pontiff Episode 2 - Hot Magick; Analytics and Graphical Output with PL/R
Welcome to Episode 2 of the "Musings of a PostgreSQL Data Pontiff" series! In this installment I’m aiming to achieve three objectives.
20 min read
Musings of a PostgreSQL Data Pontiff Episode 1
This is the first in a series of blogs on the topic of using PostgreSQL for "data science". I put that in quotes because I would not consider myself to be a practicing "data scientist", per se. Of course I'm not sure there is a universally accepted definition of "data scientist". This article provides a nice illustration of my point.
6 min read.png)
Deep PostgreSQL Thoughts: Resistance to Containers is Futile
Recently I ran across grand sweeping statements that suggest containers are not ready for prime time as a vehicle for deploying your databases. The definition of "futile" is something like "serving no useful purpose; completely ineffective". See why I say this below, but in short, you probably are already, for all intents and purposes, running your database in a "container". Therefore, your resistance is futile.
9 min read
Deep PostgreSQL Thoughts: The Linux Assassin
When Linux detects that the system is using too much memory, it will identify processes for termination and, well, assassinate them. The OOM killer has a noble role in ensuring a system does not run out of memory, but this can lead to unintended consequences.
11 min read
Postgres and Crypto Supply Chain of Integrity
How can you get PostgreSQL to use FIPS 140-2 crypto? The answer, to some extent, depends on how rigorously you need to be able to prove your answer. If the proof required is more than a casual check, the process is not well documented as far as I can tell. Therefore I will attempt to address that deficiency here.
9 min read
Election Night Prediction Modeling using PL/R in Postgres
I was sent a link to a tweet regarding election night forecasting and of course the default questions was... could be run under PL/R inside Postgres. Like about everything else at Crunchy Data we believe all things are better with Postgres.
10 min read.png)
PostgreSQL Node Metrics: Don't Fly Blind
Monitor your PostgreSQL container node and get host metrics with the Postgres extension pgnodemx.
13 min read
Hope Is Not A Strategy: How Hardware Issues Affect Your PostgreSQL Data
Learn how the HPE SSD issues can impact your PostgreSQL data, and what strategies you can take to protect your data.
3 min read
PostgreSQL Deep Dive: PostgreSQL Defaults and Impact on Security - Part 2
CVE-2018-1058 discusses how a PostgreSQL user can create trojans with unexpected results. Learn how to prevent this along with other security concepts.
10 min read
PostgreSQL Deep Dive: PostgreSQL Defaults and Impact on Security - Part 1
Explore how the PostgreSQL extension crunchy_check_access helps you to understand default PostgreSQL security settings and how it impacts your users.
25 min read
PostgreSQL Deep Dive: How Your Data Model Affects Storage
Your PostgreSQL data model directly affects how much data is stored on disk. Additionally, your ingest rate and retention could affect whether you require 10TB or 100TB of storage! This deep dive can help you save orders of magnitude of disk space before using sharding or other distributed models.
16 min read
Using R Analytic Functions in PostGIS
Introduction to Spatial Analytics with PostgreSQL, PostGIS, PL/R and R Programming Language. Example use of R Analytic functions in PostgreSQL and PostGIS.
8 min read
Preprocessing Data for Spatial Analysis with PostGIS and PL/R
Introduction to Spatial Analytics with PostgreSQL, PostGIS, PL/R and R Programming Language. Demonstration of preprocessing of Geospatial data using PostGIS.
15 min readSpatial Analytics with PostGIS, PL/R and R
Introduction to Spatial Analytics with PostgreSQL, PostGIS, PL/R and R. First in series of posts introduces PL/R and provides background for sample analysis.
10 min read
Announcing the PostgreSQL STIG
Introduction to PostgreSQL DISA Security Technical Implementation Guide
3 min read
