How we upgraded our 4 TB main application Postgres database [https://retool.com/blog/how-we-upgraded-postgresql-database/] - 2022-04-20 15:51:48 - public:aguynamedryan pg - 1 | id:1091997 -
Home | YugabyteDB [https://www.yugabyte.com/] - 2021-06-07 23:58:36 - public:aguynamedryan pg, rdbms, try - 3 | id:684305 -
pganalyze/pg_query: Ruby extension to parse, deparse and normalize SQL queries using the PostgreSQL query parser [https://github.com/pganalyze/pg_query] - 2021-06-07 23:45:47 - public:aguynamedryan gem, pg, ruby - 3 | id:684301 -
psql Tips [https://mydbanotebook.org/psql_tips_all.html] - 2021-04-16 17:10:33 - public:aguynamedryan cli, pg, tips, try - 4 | id:683421 -
Running Postgres in Docker - why and how? - CYBERTEC [https://www.cybertec-postgresql.com/en/running-postgres-in-docker-why-and-how/] - 2021-04-16 16:54:35 - public:aguynamedryan docker, pg - 2 | id:683407 -
Scaling out Postgres with the Citus open source shard rebalancer [https://www.citusdata.com/blog/2021/03/13/scaling-out-postgres-with-citus-open-source-shard-rebalancer/] - 2021-04-16 16:54:20 - public:aguynamedryan pg, scale - 2 | id:683406 -
Performance differences between Postgres and MySQL [https://arctype.com/blog/performance-difference-between-postgresql-and-mysql/] - 2021-04-16 16:53:42 - public:aguynamedryan mysql, pg - 2 | id:683405 -
Querying JSON Data in PostgreSQL [https://aaronbos.dev/posts/query-postgresql-json] - 2021-04-16 16:49:14 - public:aguynamedryan json, pg - 2 | id:683400 -
PostgreSQL: What is a checkpoint? - CYBERTEC [https://www.cybertec-postgresql.com/en/postgresql-what-is-a-checkpoint/] - 2021-04-16 16:48:48 - public:aguynamedryan dive, pg - 2 | id:683399 -
When to use tablespaces in PostgreSQL - CYBERTEC [https://www.cybertec-postgresql.com/en/when-to-use-tablespaces-in-postgresql/] - 2021-04-01 02:44:05 - public:aguynamedryan dive, pg - 2 | id:678583 -
Hierarchical Structures in PostgreSQL [https://hoverbear.org/blog/postgresql-hierarchical-structures/] - 2021-01-20 22:19:40 - public:aguynamedryan data, pg - 2 | id:488445 -
SQL Optimizations in PostgreSQL: IN vs EXISTS vs ANY/ALL vs JOIN - Percona Database Performance Blog [https://www.percona.com/blog/2020/04/16/sql-optimizations-in-postgresql-in-vs-exists-vs-any-all-vs-join/] - 2021-01-20 22:18:34 - public:aguynamedryan performance, pg - 2 | id:488444 -
Using PostgreSQL and SQL to Randomly Sample Data [https://info.crunchydata.com/blog/randomly-sampling-data-using-sql-and-postgresql] - 2020-10-28 16:22:58 - public:aguynamedryan data, pg, stats, try - 4 | id:436596 -
pg_squeeze: Optimizing PostgreSQL storage - Cybertec [https://www.cybertec-postgresql.com/en/pg_squeeze-optimizing-postgresql-storage/] - 2020-10-14 16:16:36 - public:aguynamedryan performance, pg - 2 | id:416631 -
graphile/postgraphile: Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database! [https://github.com/graphile/postgraphile] - 2020-08-20 19:07:43 - public:aguynamedryan pg, try - 2 | id:366375 -
tpope/vim-dadbod: dadbod.vim: Modern database interface for Vim [https://github.com/tpope/vim-dadbod] - 2020-05-06 16:54:46 - public:aguynamedryan db, pg, vim - 3 | id:310049 -
My Favorite PostgreSQL Extensions - Part Two | Severalnines [https://severalnines.com/database-blog/my-favorite-postgresql-extensions-part-two] - 2020-05-06 16:54:13 - public:aguynamedryan pg - 1 | id:310048 -
My Favorite PostgreSQL Extensions - Part One | Severalnines [https://severalnines.com/database-blog/my-favorite-postgresql-extensions-part-one] - 2020-05-06 05:16:32 - public:aguynamedryan pg - 1 | id:310019 -
PostgreSQL Gets a Parallel Processing Boost [https://www.datanami.com/2020/04/27/postgresql-gets-a-parallel-processing-boost/] - 2020-05-03 16:35:16 - public:aguynamedryan performance, pg - 2 | id:309959 -
PostgreSQL troubleshooting extension | pg_show_plans - CYBERTEC [https://www.cybertec-postgresql.com/en/detailed-look-on-the-new-postgresql-troubleshooting-extension-pg_show_plans/] - 2020-04-15 15:58:19 - public:aguynamedryan performance, pg - 2 | id:292959 -
A Beginners Guide to Basic Indexing | James Bannister [https://bannister.me/blog/a-beginners-guide-to-basic-indexing/] - 2020-04-15 15:57:44 - public:aguynamedryan performance, pg - 2 | id:292958 -
PostGraphile | PostgreSQL Schema Design [https://www.graphile.org/postgraphile/postgresql-schema-design/] - 2020-04-03 16:11:23 - public:aguynamedryan pg - 1 | id:291020 -
pg_show_plans: Watching execution plans in PostgreSQL LIVE - Cybertec [https://www.cybertec-postgresql.com/en/pg_show_plans-watching-execution-plans-in-postgresql-live/] - 2020-04-01 20:28:34 - public:aguynamedryan explain, performance, pg - 3 | id:290994 -
Useful Queries For PostgreSQL Index Maintenance - Percona Database Performance Blog [https://www.percona.com/blog/2020/03/31/useful-queries-for-postgresql-index-maintenance/] - 2020-04-01 20:27:53 - public:aguynamedryan performance, pg - 2 | id:290993 -
PostgreSQL command line cheatsheet [https://gist.github.com/Kartones/dd3ff5ec5ea238d4c546] - 2020-04-01 20:25:39 - public:aguynamedryan cheatsheet, cli, pg - 3 | id:290992 -
pgagroal [https://agroal.github.io/pgagroal/] - 2020-03-18 20:12:32 - public:aguynamedryan pg - 1 | id:290821 -
PostgreSQL Date and Time Data Types Explained – nanmu42 [https://nanmu.me/en/posts/2020/postgresql-date-and-time-data-types-explained/] - 2020-03-18 20:11:04 - public:aguynamedryan pg - 1 | id:290820 -
An Overview of Generated Columns for PostgreSQL | Severalnines [https://severalnines.com/database-blog/overview-generated-columns-postgresql] - 2020-03-18 20:10:54 - public:aguynamedryan pg - 1 | id:290819 -
PostgreSQL is the worlds' best database - 2ndQuadrant | PostgreSQL [https://www.2ndquadrant.com/en/blog/postgresql-is-the-worlds-best-database/] - 2020-03-18 20:10:33 - public:aguynamedryan pg - 1 | id:290818 -
PostgreSQL and Databases in general: Parallelism, what next? [https://amitkapila16.blogspot.com/2020/02/this-blog-post-is-about-journey-of.html] - 2020-02-26 16:24:17 - public:aguynamedryan concurrency, pg - 2 | id:283238 -
Preparing your Postgres data for scale-out - DEV Community [https://dev.to/heroku/preparing-your-postgres-data-for-scale-out-km] - 2020-02-26 16:23:22 - public:aguynamedryan data, pg, scale, shard - 4 | id:283237 -
mgartner/pg_flame: A flamegraph generator for Postgres EXPLAIN ANALYZE output. [https://github.com/mgartner/pg_flame] - 2020-02-21 03:38:50 - public:aguynamedryan performance, pg - 2 | id:283166 -
Similarity in Postgres and Rails using Trigrams · pganalyze [https://pganalyze.com/blog/similarity-in-postgres-and-ruby-on-rails-using-trigrams] - 2019-12-06 18:44:15 - public:aguynamedryan dp, pg, strings - 3 | id:279046 -
Discovering less-known PostgreSQL 12 features - Cybertec [https://www.cybertec-postgresql.com/en/discovering-less-known-postgresql-12-features/] - 2019-12-04 18:59:05 - public:aguynamedryan pg - 1 | id:279045 -
Making Mystery-Solving Easier with auto_explain [http://richyen.com/postgres/2019/11/06/auto_explain.html] - 2019-11-17 03:20:18 - public:aguynamedryan debug, explain, pg - 3 | id:279034 -
Architecting petabyte-scale analytics by scaling out Postgres on Azure with the Citus extension [https://techcommunity.microsoft.com/t5/Azure-Database-for-PostgreSQL/Architecting-petabyte-scale-analytics-by-scaling-out-Postgres-on/ba-p/969685] - 2019-11-17 03:19:59 - public:aguynamedryan pg, scale - 2 | id:279033 -
Achieving k-anonymity with PostgreSQL [https://blog.taadeem.net///english/2019/11/07/achieving-k-anonymity-with-postgresql] - 2019-11-17 03:19:34 - public:aguynamedryan hipaa, pg - 2 | id:279032 -
Use GitHub Actions for Rails CI with Postgres [https://andycroll.com/ruby/github-actions-ci-for-rails-with-postgresql/] - 2019-11-10 17:05:39 - public:aguynamedryan ci, github, pg, rails, ruby - 5 | id:279028 -
aquametalabs/aquameta [https://github.com/aquametalabs/aquameta] - 2019-10-25 21:28:29 - public:aguynamedryan odd, pg - 2 | id:279021 -
Trace Query Processing Internals with Debugger – Highgo Software Inc. [https://www.highgo.ca/2019/10/03/trace-query-processing-internals-with-debugger/] - 2019-10-11 19:13:57 - public:aguynamedryan pg - 1 | id:279008 -
Tech preview: Improving COPY and bulkloading in PostgreSQL 12 - Cybertec [https://www.cybertec-postgresql.com/en/tech-preview-improving-copy-and-bulkloading-in-postgresql-12/] - 2019-10-09 15:30:09 - public:aguynamedryan csv, pg, read - 3 | id:277340 -
A Primer on PostgreSQL Upgrade Methods - Cybertec [https://www.cybertec-postgresql.com/en/a-primer-on-postgresql-upgrade-methods/] - 2019-10-09 15:21:58 - public:aguynamedryan pg - 1 | id:279004 -
Introducing PostgreSQL Anonymizer [http://blog.taadeem.net///english/2018/10/29/Introducing-PostgreSQL-Anonymizer] - 2019-10-04 21:42:44 - public:aguynamedryan pg - 1 | id:277496 -
Postgres 11 - A First Look [http://www.craigkerstiens.com/2018/09/20/postgresql-11-a-first-look/] - 2019-10-04 21:42:44 - public:aguynamedryan pg - 1 | id:277619 -
SELECT DISTINCT ON in PostgreSQL | Geeky Tidbits [https://www.geekytidbits.com/postgres-distinct-on/] - 2019-10-04 21:42:44 - public:aguynamedryan pg - 1 | id:277603 -
pgCenter - stress free Postgres stats. [http://blog.dataegret.com/2018/10/pgcenter-stress-free-postgres-stats.html] - 2019-10-04 21:42:44 - public:aguynamedryan pg - 1 | id:277602 -
ankane/dexter [https://github.com/ankane/dexter] - 2019-10-04 21:42:44 - public:aguynamedryan pg, read - 2 | id:277592 -
Ideas for scaling PostgreSQL to multi-terabyte and beyond - Cybertec [https://www.cybertec-postgresql.com/en/ideas-for-scaling-postgresql-to-multi-terabyte-and-beyond/] - 2019-10-04 21:42:44 - public:aguynamedryan pg, read - 2 | id:277581 -
Fun with SQL: Unions in Postgres [https://www.citusdata.com/blog/2018/09/27/fun-with-sql-unions-in-postgres/] - 2019-10-04 21:42:44 - public:aguynamedryan pg - 1 | id:277580 -
PostgreSQL: The Versatile INSERT [https://pgdash.io/blog/postgres-insert.html] - 2019-10-04 21:42:44 - public:aguynamedryan pg - 1 | id:277579 -