PostgreSQLのMVCC（Multi-Version Concurrency Control）では、各トランザクションが見るべきレコードのバージョンを効率的に見つける仕組みとして、以下のような方法が使われています。
- Heap Tuple:
Ryo Kanbayashi ryogrid
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| def basic_filter_message(username, message_text): | |
| if not message_text or len(message_text) < 8: return False | |
| patterns = [r"^(はい|ええ|うん|OK|了解|承知しました|わかりました|なるほど)$", r"^(ありがとうございます|ありがとう|どうも)$", | |
| r"^(お疲れ様です|おつかれさまです)$", r"^(お願いします|よろしくお願いいたします|よろしくです)$", | |
| r"^(笑|w+|草)$", r"^\s*（スタンプ）\s*$", r"^そうですね$|^ですねー$|^たしかに$"] | |
| for p in patterns: | |
| if re.fullmatch(p, message_text, re.IGNORECASE): return False | |
| return True | |
| # --- プロンプト作成関数 --- |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html lang="ja"> | |
| <head> | |
| <meta charset="UTF-8" /> | |
| <title>ブロック崩しゲーム</title> | |
| <style> | |
| body { | |
| margin: 0; | |
| overflow: hidden; |
ryogrid
/ pg18_dev_250405_io_uring_pgbench_results.txt
Last active
April 6, 2025 23:58
postgresのio_uringを有効にした時のパフォーマンスを見てみる
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 注意:まだベータにもなっていない段階のコードベースで、設定も精査せず、ベンチマーククライアントも同一マシンに置いて、とりあえず測定をしてみた、というだけのものなので、その程度のものであり、結果であるというところは、ご承知おき下さい。 | |
| ●前提情報 | |
| ■実施日 | |
| 2025/4/5 | |
| ■測定環境（自作デスクトップ） | |
| AMD Ryzen 7 5700X 8-Core Processor 4.50 GHz | |
| Memory 64GB | |
| WD_Black SN770 NVMe WDS100T3X0E 1TB M.2 PCI-Express Gen4 |
ryogrid
/ tracking-bug-report-status.gs
Last active
April 1, 2025 23:58
Google Apps Script for pgsql-bugs ML reported bugs statuses automatic tracking (statuses are assumed by LLM)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // --- Configuration --- | |
| // --- ここから設定 --- | |
| // 1. Your Google Cloud Project API Key for Vertex AI (Gemini API) | |
| // Google Cloudプロジェクトで生成したVertex AI API（Gemini API）のAPIキー | |
| const API_KEY = ''; // <-- ここにAPIキーを貼り付けてください (Paste your API key here) | |
| // 2. Your Google Cloud Project ID | |
| // Google CloudプロジェクトID | |
| const PROJECT_ID = ''; // <-- ここにプロジェクトIDを貼り付けてください (Paste your project ID here) |
ryogrid
/ .cursorrules
Created
March 29, 2025 02:43
— forked from fumiya-kume/.cursorrules
.cursorrules in 2025/01/11
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # .cursorrules | |
| # Development Steps for CLI Application in Go | |
| ## 1. Overall Design | |
| - Define the purpose and scope of the CLI application. | |
| - Identify the target audience and their needs. | |
| - Outline the main features and functionalities. | |
| - Create a high-level architecture diagram. | |
| - **Improve Specifications/Features:** |
ryogrid
/ Ollama_deepseek-r1_14b_hybrid_RAG_for_web_url.ipynb
Created
February 13, 2025 14:14
LLM with deepseek-r1:14b on Ollama
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <meta charset="utf-8"> | |
| <title>フルーツ合成パズルゲーム</title> | |
| <!-- Matter.js を CDN 経由で読み込み --> | |
| <script src="https://cdnjs.cloudflare.com/ajax/libs/matter-js/0.19.0/matter.min.js"></script> | |
| <style> | |
| body { margin: 0; font-family: sans-serif; } | |
| /* 上部の情報＆操作エリア */ |
ryogrid
/ answer_by_chatgpt1.md
Last active
November 16, 2024 14:23
postgresで各txnはアクセスすべきバージョンにどのように到達するか
ryogrid
/ citus-cluster-with-docker-compse-memo.md
Last active
November 13, 2024 16:25
citusをdocker-composeで動かす
- WSL Ubuntu 20.04 (WSL2)
- Docker version 24.0.5, build ced0996
- https://github.com/citusdata/docker/tree/4ea8a14e6db62adb903e698816588ded8f6ba402 をclone
- ローカルにベースイメージを登録
- $ cd docker
- $ docker build -t citusdata/citus:12.1.5 .
ryogrid
/ nostrp2p_on_termux.md
Last active
June 3, 2024 22:47
NostrP2P server on Android Smartphone
The other day, I wrote an articleshown below, and I was thinking about whether I could prepare or have a machine that can run the server continuously.
NostrP2P: Pure P2P Distributed Microblogging System - ryo_grid's tech articles
Then, I remembered that there is an app called Termux that creates a unique Linux environment within an Android device. So, I thought it would be a good idea to use an old Android smartphone to run the server, and when I tried it, it worked perfectly!
(The idea behind Termux is that since Android is a type of Linux, by changing the root location of the file system in the shell shown to the user with chroot and placing the necessary files, you can create a unique Linux userland.)
First, referring to the sites below, install Termux via the Fdroid app.
NewerOlder