From 8c084df1ae80eee451a2b0eb349ff334ed28bab6 Mon Sep 17 00:00:00 2001 From: Martin Kagamino Lehoux Date: Mon, 6 Oct 2025 19:21:07 +0200 Subject: Update script reference and build files --- Makefile | 2 ++ config/_default/hugo.toml | 1 + content/posts/postgres-aggregation-speed/index.md | 4 ++-- 3 files changed, 5 insertions(+), 2 deletions(-) diff --git a/Makefile b/Makefile index 64189a3..e6ca2da 100644 --- a/Makefile +++ b/Makefile @@ -1,4 +1,5 @@ deploy: + rm -rf public/ hugo rsync --rsync-path="sudo rsync" -avz --delete public/ ubuntu@feed.kagamino.dev:/var/www/kagamino_blog/ @@ -6,5 +7,6 @@ dev: hugo server -D build: + rm -rf public/ hugo -D -b http://localhost:8000/ python -m http.server -d public/ diff --git a/config/_default/hugo.toml b/config/_default/hugo.toml index 51c1e5e..59787e5 100644 --- a/config/_default/hugo.toml +++ b/config/_default/hugo.toml @@ -3,6 +3,7 @@ copyright = "{year}" # To make 2007 - 2022. Just add before {y languageCode = 'en-us' title = "Kagamino's Blog" enableRobotsTXT = true +ignoreFiles = ["__pycache__"] # List Config summaryLength = 15 diff --git a/content/posts/postgres-aggregation-speed/index.md b/content/posts/postgres-aggregation-speed/index.md index 4c0b760..d1a26ff 100644 --- a/content/posts/postgres-aggregation-speed/index.md +++ b/content/posts/postgres-aggregation-speed/index.md @@ -2,7 +2,7 @@ title: PostgreSQL aggregation processing speed draft: false date: 2025-10-06 -lastmod: +lastmod: 2025-10-06 description: Comparison of aggregation function speed, on the database and in a host language categories: - PostgreSQL @@ -268,7 +268,7 @@ I don't really know why `composite text` is that slow in both benchmarks. ## Resources -- [Benchmarking script](test.py) +- [Benchmarking script](tests.py) - [Postgres JSON functions](https://www.postgresql.org/docs/current/functions-json.html) - [Postgres aggregation functions](https://www.postgresql.org/docs/current/functions-aggregate.html) - [Psycopg](https://www.psycopg.org/) -- cgit v1.3