Our Blog

Ongoing observations by End Point Dev people

Blog posts by

David Christensen

Detecting gaps in time-series data in PostgreSQL

October 26, 2020

Using CTEs to do a binary search of large tables with non-indexed correlated data

October 2, 2020

Improving max() performance in PostgreSQL: GROUP BY vs. CTE

June 30, 2020

Bucardo 5.6.0 Released

March 1, 2020

Cloudflare and Vue SSR; Client Hydration Failures

June 11, 2019

Vue, Font Awesome, and Facebook/Twitter Icons

July 12, 2018

Instant TLS Upgrades Through Proxy Magic!

June 14, 2018

PostgreSQL Point-in-time Recovery: An Unexpected Journey

January 15, 2016

PgConf 2015 NYC Recap

April 6, 2015

PGConf.US NYC: "Choosing a Logical Replication System"

January 22, 2015

MySQL to PostgreSQL Migration Tips

November 26, 2014

Significant Whitespace in an Interchange UserTag

March 18, 2014

Slony Migration experience version 1.2 to version 2.2

November 6, 2013

PostgreSQL Autovacuum Issues In EOL Postgres

July 17, 2013

Postgres Open 2012

July 31, 2012

Integration Experiences

June 13, 2012

Byte-swap an entire file using perl

April 20, 2012

PG West 2011 Re-cap

October 7, 2011

Headed out to PgWest next week

September 20, 2011

Remove specific CGI variables using Apache

August 10, 2011

Announcing pg_blockinfo!

July 14, 2011

DBD::Pg moves to Git!

June 14, 2011

Presenting at PgEast

March 11, 2011

SSH: piping data in reverse

March 1, 2011

GNU Screen + SSH_AUTH_SOCK; my new approach

February 23, 2011

Pausing Hot Standby Replay in PostgreSQL 9.0

February 12, 2011

Using nginx to transparently modify/debug third-party content

February 6, 2011

Character encoding in perl: decode_utf8() vs decode('utf8')

December 31, 2010

Using “diff” and “git” to locate original revision/source of externally modified files

December 18, 2010

PostgreSQL 9.0 High Performance Review

November 30, 2010

PostgreSQL odd checkpoint failure

September 14, 2010

PostgreSQL: per-version .psqlrc

July 28, 2010

PostgreSQL: Dynamic SQL Function

July 27, 2010

PostgreSQL: Migration Support Checklist

July 22, 2010

PostgreSQL 8.4 on RHEL 4: Teaching an old dog new tricks

May 19, 2010

Continuing an interrupted git-svn clone

May 13, 2010

PostgreSQL startup Debian logging failure

May 5, 2010

Make git grep recurse into submodules

April 26, 2010

Tip: Find all non-UTF-8 files

April 9, 2010

PostgreSQL tip: arbitrary serialized rows

March 8, 2010

PostgreSQL tip: dump objects into a new schema

February 16, 2010

GNU diff: changing the output filenames

February 15, 2010

PostgreSQL tip: using pg_dump to extract a single function

January 31, 2010

Slony: Cascading Subscriptions

January 28, 2010

Postgres SQL Backup Gzip Shrinkage, aka Don’t Panic!!!

January 9, 2010

Look Ma, I made an iPhone Enterprise Application!

August 3, 2009

Subverting Subversion for Fun and Profit

April 7, 2009

Interchange jobs caveat

March 10, 2009

Emacs Tip of the Day: ediff-revision

March 9, 2009

Know your tools under the hood

September 11, 2008

Stepping into version control

September 5, 2008

Popular Tags

All Tags

Archive