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