Recent Posts

• Logical Replication from Postgres to Iceberg
  by plaur782on 4/23/2025, 1:12:24 PM with 1 comment
• Creating Histograms with Postgres
  by plaur782on 4/4/2025, 4:43:12 PM with 0 comments
• Transforming Data with DuckDB and Dbt
  by plaur782on 4/4/2025, 11:29:07 AM with 0 comments
• Maximizing Your Delta Scan Performance
  by plaur782on 3/21/2025, 3:45:14 PM with 1 comment
• Automatic Iceberg Maintenance Within Postgres
  by plaur782on 3/21/2025, 1:35:03 PM with 0 comments
• Parquet Bloom Filters in DuckDB
  by plaur782on 3/17/2025, 12:10:27 AM with 0 comments
• Postgres, Dbt, and Iceberg: Scalable Data Transformation
  by plaur782on 3/15/2025, 10:36:35 AM with 0 comments
• PgBouncer is useful, important, and fraught with peril
  by plaur782on 2/20/2025, 11:22:35 AM with 0 comments
• Postgres Compatability Index
  by plaur782on 2/17/2025, 12:50:13 PM with 1 comment
• Incremental Archival from Postgres to Parquet for Analytics
  by plaur782on 2/14/2025, 4:47:38 PM with 0 comments
• Geoparquet 2.0: Going Native
  by plaur782on 2/13/2025, 7:42:11 PM with 0 comments
• Scaling with PostgreSQL without boiling the ocean
  by plaur782on 2/9/2025, 3:26:58 PM with 4 comments
• Best place to learn to use PostgreSQL
  by plaur782on 1/25/2025, 12:47:22 PM with 0 comments
• Running TPC-H SF300 on a Raspberry Pi
  by plaur782on 1/20/2025, 6:00:55 PM with 1 comment
• Using DuckDB's Hilbert Function with GeoParquet
  by plaur782on 1/19/2025, 3:52:22 PM with 1 comment
• PostgreSQL is the Database Management System of the Year 2024
  by plaur782on 1/14/2025, 11:37:57 AM with 17 comments
• Database Trends: A 2024 Review and a Look Ahead
  by plaur782on 1/12/2025, 5:51:44 PM with 0 comments
• Vertical Stacking as the Relational Model Intended: Union All by Name
  by plaur782on 1/10/2025, 5:48:59 PM with 1 comment
• DuckDB: Query Processing Is King
  by plaur782on 1/5/2025, 9:05:52 PM with 1 comment
• Overture Maps Transportation theme is now GA
  by plaur782on 12/19/2024, 1:55:02 PM with 0 comments
• DuckDB Node Neo Client
  by plaur782on 12/18/2024, 7:19:50 PM with 0 comments
• Speed Up Compound Full-Text Searches in PostgreSQL by 300x
  by plaur782on 12/14/2024, 4:23:20 PM with 1 comment
• Full Text Search in Milliseconds with Rails and PostgreSQL
  by plaur782on 12/13/2024, 7:52:45 PM with 0 comments
• Query Your Snowflake Managed Iceberg Tables with DuckDB
  by plaur782on 12/13/2024, 1:52:46 PM with 0 comments
• Shrinking a Postgres Table
  by plaur782on 12/12/2024, 2:08:53 PM with 1 comment
• Django and Postgres for the Busy Rails Developer
  by plaur782on 12/11/2024, 2:56:29 PM with 12 comments
• The DuckDB Avro Extension
  by plaur782on 12/10/2024, 1:08:50 AM with 0 comments
• DuckDB: Running TPC-H SF100 on Mobile Phones
  by plaur782on 12/9/2024, 3:15:51 PM with 0 comments
• Postgres Partitioning with a Default Partition
  by plaur782on 12/6/2024, 3:54:52 PM with 1 comment
• CSV Files: Dethroning Parquet as the Ultimate Storage File Format – Or Not?
  by plaur782on 12/5/2024, 5:33:50 PM with 0 comments
• Pg_parquet – Postgres to Parquet Interoperability
  by plaur782on 11/28/2024, 8:39:12 PM with 0 comments
• Some of My Favorite PostgreSQLisms
  by plaur782on 11/26/2024, 3:29:35 PM with 1 comment
• Crunchy Data Warehouse: Postgres with Iceberg for Analytics
  by plaur782on 11/23/2024, 2:39:47 PM with 0 comments
• Iceberg Tables in Postgres with Crunchy Data Warehouse
  by plaur782on 11/22/2024, 11:56:48 AM with 0 comments
• PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released!
  by plaur782on 11/21/2024, 2:13:41 PM with 2 comments
• Easy Totals and Subtotals in Postgres with Rollup and Cube
  by plaur782on 11/19/2024, 1:40:27 PM with 0 comments
• 2024 Ruby on Rails Community Survey Result
  by plaur782on 11/17/2024, 10:20:47 PM with 0 comments
• Using CTID Based Pagination for Data Cleanups in Postgres
  by plaur782on 11/12/2024, 8:06:04 PM with 0 comments
• Postgres and Citus and Partman for Your IoT Database
  by plaur782on 10/5/2024, 1:06:49 PM with 0 comments
• Performance Gains with Postgres 17B-Tree Bulk Scans
  by plaur782on 9/26/2024, 10:56:03 AM with 1 comment
• Building Postgres Extensions: Dropping Extensions and Cleanup
  by plaur782on 9/20/2024, 8:55:02 PM with 0 comments
• Postgres Window Functions for Data Analysis
  by plaur782on 9/18/2024, 5:08:15 PM with 1 comment
• PostGIS Meets DuckDB: Crunchy Bridge for Analytics Goes Spatial
  by plaur782on 9/11/2024, 5:21:19 PM with 0 comments
• Postgres Materialized Views from Parquet in S3
  by plaur782on 9/7/2024, 4:14:11 PM with 0 comments
• Understanding the Postgres Hackers Mailing List
  by plaur782on 8/30/2024, 12:46:54 PM with 1 comment
• How the VC Ecosystem Broke the LP Ecosystem
  by plaur782on 8/18/2024, 2:30:11 PM with 0 comments
• Postgres Powered by DuckDB: The Modern Data Stack in a Box
  by plaur782on 8/17/2024, 10:43:58 AM with 0 comments
• Postgres feature you're not using – CTEs a.k.a. WITH clauses
  by plaur782on 8/16/2024, 6:37:32 PM with 15 comments