{ "subreddit": "r/PostgreSQL", "page": "https://redlisten.com/r/postgresql", "updated": "2026-11-12T00:55:59.893Z", "members": 90236, "activity": { "posts_last_24_hours": 0, "posts_per_hour": 0.1, "comments_per_hour": 0.8, "newest_post_utc": 1794328920.248, "newest_comment_utc": 1794349717.611 }, "top_threads_this_week": [ { "title": "Query optimization", "score": 23, "comments": 15, "created_utc": 1794080254.579, "snippet": "Moving my project from MS Sql to PostrgesSql, Need to run mass update query, ClientDelivery table has 1,054,155 records In MsSql query takes about 10 seconds, In PostgresSql it actually never...", "url": "https://www.reddit.com/r/PostgreSQL/comments/1xqewsr/query_optimization/" }, { "title": "Xata is joining ClickHouse", "score": 19, "comments": 4, "created_utc": 1794244811.007, "snippet": "", "url": "https://www.reddit.com/r/PostgreSQL/comments/1xrxnff/xata_is_joining_clickhouse/" }, { "title": "pg_fts: Open source BM25 extension for full-text search and boolean, phrase, NEAR, prefix, fuzzy, and regex queries", "score": 18, "comments": 2, "created_utc": 1794281283.124, "snippet": "For anyone interested in BM25 search and especially legal opinion search, Greg Burd has been very active developing pg\\fts https://github.com/gburd/pg\\fts a PostgreSQL extension for full-text...", "url": "https://www.reddit.com/r/PostgreSQL/comments/1xscgv2/pg_fts_open_source_bm25_extension_for_fulltext/" }, { "title": "How a Postgres committer got started: a one-line patch that doesn't even carry his name (Magnus Hagander on the Talking Postgres podcast)", "score": 11, "comments": 3, "created_utc": 1793999409.748, "snippet": "I recently recorded a Talking Postgres episode with Magnus Hagander, a Postgres committer, core team member, and longtime PGConf EU organizer, about how he got started in Postgres. A few things we...", "url": "https://www.reddit.com/r/PostgreSQL/comments/1xpo9sl/how_a_postgres_committer_got_started_a_oneline/" }, { "title": "A month with WalShadow", "score": 10, "comments": 1, "created_utc": 1793975624.761, "snippet": "WalShadow replicates data from Postgres to ClickHouse via physical WAL, and not logical replication. This blog talks about the latency, handling of restarts, stops etc., and issues encountered...", "url": "https://www.reddit.com/r/PostgreSQL/comments/1xpea7z/a_month_with_walshadow/" }, { "title": "PostgresSQL Training", "score": 9, "comments": 18, "created_utc": 1793997391.895, "snippet": "Hello, I’ve inherited a data lake that is all done in postgres. I’ve done a little bit of DBA stuff in the past, but it was all SQL or Oracle. Any recommendations on training to learn how to pull...", "url": "https://www.reddit.com/r/PostgreSQL/comments/1xpnggt/postgressql_training/" }, { "title": "PostgreSQL 18 on a 512 MiB VM: testing two low-memory configurations", "score": 6, "comments": 6, "created_utc": 1794328920.248, "snippet": "I've been experimenting with PostgreSQL 18 tuning for memory-constrained VPS deployments, particularly where the database needs to leave enough RAM for a small application. I wanted to compare two...", "url": "https://www.reddit.com/r/PostgreSQL/comments/1xsrqrz/postgresql_18_on_a_512_mib_vm_testing_two/" }, { "title": "PostgreSQL related events between Nov 09 - Dec 08", "score": 5, "comments": 2, "created_utc": 1794234814.511, "snippet": "In the age of AI I think personal connections are even more important than before. That's why I try to help promoting events where people can meet in-person or virtually and discuss the topics...", "url": "https://www.reddit.com/r/PostgreSQL/comments/1xrt6u3/postgresql_related_events_between_nov_09_dec_08/" }, { "title": "[RAG / pgvector] How do you handle vector chunks when a document is soft-deleted?", "score": 1, "comments": 5, "created_utc": 1794311649.764, "snippet": "", "url": "https://www.reddit.com/r/PostgreSQL/comments/1xskyvc/rag_pgvector_how_do_you_handle_vector_chunks_when/" }, { "title": "What actually changed when I moved a client workflow from Sheets to a real database", "score": 1, "comments": 3, "created_utc": 1793975024.751, "snippet": "", "url": "https://www.reddit.com/r/PostgreSQL/comments/1xpe1u2/what_actually_changed_when_i_moved_a_client/" } ], "newest_posts": [ { "title": "PostgreSQL 18 on a 512 MiB VM: testing two low-memory configurations", "score": 6, "comments": 6, "created_utc": 1794328920.248, "url": "https://www.reddit.com/r/PostgreSQL/comments/1xsrqrz/postgresql_18_on_a_512_mib_vm_testing_two/" }, { "title": "How to compare PostgreSQL schemas across environments and catch drift early", "score": 0, "comments": 3, "created_utc": 1794312197.914, "url": "https://www.reddit.com/r/PostgreSQL/comments/1xsl5im/how_to_compare_postgresql_schemas_across/" }, { "title": "[RAG / pgvector] How do you handle vector chunks when a document is soft-deleted?", "score": 1, "comments": 5, "created_utc": 1794311649.764, "url": "https://www.reddit.com/r/PostgreSQL/comments/1xskyvc/rag_pgvector_how_do_you_handle_vector_chunks_when/" }, { "title": "SKIP LOCKED is the easy part of a Postgres queue. What do you do about the worker that dies mid-job?", "score": 0, "comments": 15, "created_utc": 1794300263.027, "url": "https://www.reddit.com/r/PostgreSQL/comments/1xshvwo/skip_locked_is_the_easy_part_of_a_postgres_queue/" }, { "title": "pg_fts: Open source BM25 extension for full-text search and boolean, phrase, NEAR, prefix, fuzzy, and regex queries", "score": 18, "comments": 2, "created_utc": 1794281283.124, "url": "https://www.reddit.com/r/PostgreSQL/comments/1xscgv2/pg_fts_open_source_bm25_extension_for_fulltext/" }, { "title": "Xata is joining ClickHouse", "score": 19, "comments": 4, "created_utc": 1794244811.007, "url": "https://www.reddit.com/r/PostgreSQL/comments/1xrxnff/xata_is_joining_clickhouse/" }, { "title": "PostgreSQL related events between Nov 09 - Dec 08", "score": 5, "comments": 2, "created_utc": 1794234814.511, "url": "https://www.reddit.com/r/PostgreSQL/comments/1xrt6u3/postgresql_related_events_between_nov_09_dec_08/" }, { "title": "Query optimization", "score": 23, "comments": 15, "created_utc": 1794080254.579, "url": "https://www.reddit.com/r/PostgreSQL/comments/1xqewsr/query_optimization/" }, { "title": "Our Postgres lock was supposed to keep two jobs apart. Ten minutes into long runs, it quietly stopped existing, and the log said it was released cleanly every time.", "score": 0, "comments": 14, "created_utc": 1794052790.145, "url": "https://www.reddit.com/r/PostgreSQL/comments/1xq4pmx/our_postgres_lock_was_supposed_to_keep_two_jobs/" }, { "title": "I built a native macOS Postgres client because they all suck", "score": 0, "comments": 16, "created_utc": 1794039992.579, "url": "https://www.reddit.com/r/PostgreSQL/comments/1xq1fib/i_built_a_native_macos_postgres_client_because/" } ], "words_this_week": [ { "word": "built", "titles": 7 }, { "word": "open", "titles": 5 }, { "word": "clickhouse", "titles": 4 }, { "word": "source", "titles": 4 }, { "word": "extension", "titles": 4 }, { "word": "search", "titles": 4 }, { "word": "pgvector", "titles": 4 }, { "word": "actually", "titles": 4 }, { "word": "client", "titles": 4 }, { "word": "database", "titles": 4 }, { "word": "minutes", "titles": 4 }, { "word": "app", "titles": 4 } ], "preview": "This is a preview. Every post and comment in r/PostgreSQL, live, as JSON or RSS on the same paths a Reddit client uses, plus keyword streams to Slack, Discord, webhook or email, needs a free key: https://app.redlisten.com/?signup=1&utm_source=redlisten&utm_medium=subreddit", "docs": "https://redlisten.com/docs", "attribution": "Source: Redlisten, https://redlisten.com/r/postgresql" }