diff options
| -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/) |