diff options
| author | Martin Kagamino Lehoux <martin@lehoux.net> | 2025-10-06 19:21:07 +0200 |
|---|---|---|
| committer | Martin Kagamino Lehoux <martin@lehoux.net> | 2025-10-06 19:30:11 +0200 |
| commit | 8c084df1ae80eee451a2b0eb349ff334ed28bab6 (patch) | |
| tree | 97c0e4861536bf75de591684c531dee072e13f82 | |
| parent | 2ea63cf9f2b5739245e6b91033f9e41fea6a3971 (diff) | |
Update script reference and build files
| -rw-r--r-- | Makefile | 2 | ||||
| -rw-r--r-- | config/_default/hugo.toml | 1 | ||||
| -rw-r--r-- | content/posts/postgres-aggregation-speed/index.md | 4 |
3 files changed, 5 insertions, 2 deletions
@@ -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/) |