Home
Blogs
General
Postgres
Comment
Events
FAQ
Favorites
Articles
Books
Documents
Hobbies
Kids
Movies
Music
Periodicals
News Sources
Quotes
Sayings
Television
Videos
Artistic
Humorous
Serious
News
Presentations
PG Overview
PG Features
PG Internals
PG Misc.
PG Project
General
Selecting
Press
Résumé
Search
Travel Map
Contact
Private Area
Postgres Blog Index: Ordered by Category
View Detail
View Chronological Index
Community
Postgres Developer Meetings
PgCon Developer Meeting Concluded
Recruiters A'Callin
I Feel Sorry for Closed-Source Developers
So You Want to Be a Committer?
Growing Postgres User Groups
Email Snippets: Entertaining Links
Email Snippets: Community Management
Email Snippets: Reliability
Email Snippets: Philosophy
Email Snippets: SQL Craziness
Email Snippets: Self-deprecation
A Postgres Song?
Do We Have a Plan?
Why People Contribute to Postgres and Open Source
Development Process Article
The Pain of Software Development
User Testimonial Video at PG East
Don't Confuse Companies with Community
Growing Patch Committers
Community Communication
Development Developments
Postgres Globe
Conference
Conference Report
Conference Report
The 9.2 Sleeper Feature
Video of Postgres 9.2 Features
Lots O' Conferences
Upcoming Conferences
Celko Speaking in Prague
What Makes a Great Conference Site
Speaking in the Dominican Republic
Upcoming Events
Report from PGDay Austin
Report from Montreal's ConFoo Conference
Staying Close to Home
The USA Is Planning a Triple Play
The Travel Faucet
I'm Back
The Marathon Begins
The Postgres Fall Conference Lineup
Need a Conference Welcome Video?
Yeah, I'm at MySQLCon
A Conference A Month
PgEast at the Hotel Pennsylvania
Report from SCALE
An Event Every Month
Conference Report
PG West Selectivity Talk
Back from Moscow
Baltimore, Bolivia, Boston, Moscow, San Francisco
Speaking in New York City
SURGE Conference
OSCON 2010 Report
Speaking in New York City
PG East: Hotel
PG East: What to Expect
More Philadelphia Action
Postgres Is Hot In Philadelphia
Reflections on PGCon
The Great Netbook Giveaway Redux
OpenSQL Camp Report
Back From PG West
Conference Schedule Resumed
Event Attendance Cancellations
Report from Brasilia
Linuxworld Wrapup, Swag
OSCON Wrapup
OSCON Report
Attending OSCON
Upcoming Presentations
Traveling Every Month
PGCon Impressions
Attending FOSDEM in Brussels
Documentation
The Backend Flowchart Is Back
The Importance of High-Quality Documentation
Postgres Documentation
Postgres 9.1 Draft Release Notes
Pretty Docs
9.0 Release Notes Ready
9.0 Release Notes Creation
Seeking Documentation Proofreading Assistance
8.4 Release Notes
Working on 8.4 Release Notes
Reading Through the Manual
News
Video Interview
PgLife Averages Thirty Active Users
PgLife Is Now Live
9.3 Release Notes Ready for Beta
Starting on 9.3 Release Notes
Twenty-One Hours to Exploit
My Blog Changes
Teaching Again at Drexel
Postgres Pool Party
Report from PGCon
Parallel Query Report from the PGCon Developer Meeting
Postgres 9.2 Draft Release Notes Published
Starting on 9.2 Release Notes
The New Postgres Era
Postgres Getting Increased Attention
New Server
Coming to Boston
Intel Pushes Out Firmware Update For 320 Series SSDs
No RSVPs, No Party
EnterpriseDB Looking for Beta Testers
Postgres Now the Default Database for Mac OS X Server
No Postgres Booth at OSCon
Postgres Pool Party
MVCC Webcast this Wednesday
Postgres 9.1 in the News
Important Postgres 9.1 Features
Postgres 9.1 Is Coming
Security Meeting in Maryland
Completed User Testimonial Videos from PG East
One Week to the Postgres Pool Party
Postgres Coming to the International Space Station
PostgreSQL 9.0 Illustrated
Another Drexel University Course
Postgres Pool Party
Creeping to Beta
9.0 Status Report
Postgres University Course Material
Wanted: New Project Slogan
Oops, Confusing Press Release
Postgres 9.0 Coming
European Union Recognizes PostgreSQL
Security Enhanced Postgres
New Security Talk
School Is Out
JPUG Tenth Anniversary
Award
Busy Week
Partial Progress in Proofreading the Postgres Manual
Professor Momjian
Back to Email
Release Date Poll
My Goals for the Next Two Months
Postgres 8.4 Beta1
Oracle to Buy Sun
Philadelphia Tour After PG East
Online Training
Query Source Code Flow Diagram Completed
Query Source Code Flow
Preparation for 8.4, Travel
Final Feature Decisions for 8.4
Security-Enhanced Postgres
Webcast Series
Slogging Toward 8.4
Postgres News Activity
Webcasts
Approaching 8.4 Beta
Spacewalk to Postgres
Less Travel
Attending OpenSQL Camp
Back to Work
TODO TO-Gone
OSCON Grand Prize
Appointed to PgUS Board
Russian Chat Session
pgpool PG Pool Party
Master/Slave Replication
The Photo Reply
Commit Fest Done
PGCon Developer's Meeting
Porting from Oracle to Postgres
May Commit-Fest Going Well
First 8.4 Commit-Fest Done
First Commit-Fest
Postgres 8.4 Development Started
Back From London
8.3RC2 Needed
Start
Performance
250
Tps
The Externality of Index Creation
Timing Query Internals
Timing a Query
Speeding Up by Condensing
The Effectiveness of effective_cache_size
Measuring Free Memory and Kernel Cache Size on Linux
Caching Levels
Sorting Performance Improvement for Postgres 9.2
Let's See work_mem
Scalability What?
Parallelism Is Coming
Scalability Improvements Are Coming
What Every Data Programmer Needs to Know about Disks
Benchmark Comparison
Pg upgrade
Pg_Upgrade Now Handles Invalid Indexes
Pg_Upgrade Faster, Again!
Pg_Upgrade Bug with Invalid Concurrently-Created Indexes
Pg_Upgrade Performance Improvements
Automatic Upgrades?
The Evolution of Pg_Upgrade
Pg_Upgrade and Optimizer Statistics
Pg_Upgrade Improvements Coming in Postgres 9.2
Bug Fix for Pg_Upgrade from Postgres 8.3
Pg_Upgrade Will Always Be a Hack
Changes to Pg_Upgrade In Postgres 9.1
Pg_Upgrade Fix Now Released in Postgres 9.0.4
Critical Fix for Pg_upgrade/Pg_migrator Users
Pg_Migrator Included in Postgres 9.0, Renamed to Pg_Upgrade
Pg_Migrator Done for 8.4, New Video
Pg_Migrator 8.4.1 Released
Setback for Pg_Migrator
Pg_Migrator 8.4 Final Released Last Week
Pg_Migrator Release Candidate 1
Challenges of Pg_Migrator
Pg_Migrator Beta 1 Released
PG_Migrator Progress
PG_Migrator Alpha Released
PG_Migrator Status
Presentation
New Presentation Online
PostgreSQL's Place in the New World Order
Vacation, What Vacation?
CTE Presentation at ConFoo; Slides Now Online
Part 1 of
Virtualizing Postgres
Now Online
Presentations Updated
Unlocking the Postgres Lock Manager
Slides Now Online
New Optimizer Presentation Now Online
Video Presentation from Brazil Now Online
MySQLCon Keynote Video Now Online
MVCC Unmasked
Now Online
Two New Presentations
Updated Presentation: The Magic of Hot Streaming Replication
PG East: Slides
Presentation License
Thoughts
Good Enough?
Postgres Is Good Enough
Postgres as a Data Platform
Table Partitioning Needs Improvement
The Middleware Porting Challenge
The Future of Relational Databases
Parallelism Roadmap
Postgres: The B-52 of Databases
"You Lock Your Data in Postgres — We Cannot Fail"
99.9% Useful
Postgres Drinking Game
Software Patents: Why the Status Quo Continues?
Open Source Leadership
NoSQL Databases as the New Scripting Language
Increasing Database Reliability
The Most Important Postgres CPU Instruction
More Lessons From My Server Migration
A Cautionary Lesson from Perl 6
Release Size Analysis
One Million Strong
Radical But Useful Source Code Reformatting
Postgres Wisdom
Why Postgres Switched To Git
Mysql Is a Database
Video
Postgres 9.0 Feedback on Slashdot
Mirror, Mirror On The Wall, Which Is The Best Open Source DB Of Them All?
Reliability Humor
Form Follows Failure
ORMs and Their Discontents
Financial Disincentive
Learning from NoSQL
Settling for NoSQL
MVCC For Programming Languages
Why Blog?
Python Driver Confusion
Removal of Personal Copyrights
Caring for Your (PG) Introvert
Threats to Postgres
The Next Postgres Adoption Wave
The
International
MySQL Soap Opera
Elephant Roads: PostgreSQL Patches and Variants
Coding Simplicity
Reaching Out to Middleware Users
Professionalism at PGCon
Old School
What Have We Forgotten About Growing?
Pet Peeves
Quixotic?
The Optimal Number of Database Performance Settings
Processing Email
Reading Email During Trips
Postgres Email Activity
Perl For Development Scripts
Elephants Can Count Too
The Kitchen Sink Has Arrived?
What Do You Do?
The MySQL Soap Opera
Database House Of Cards
Postgres Development Visualized
Postgres Is Hot
Coverity Security Scan
Big Joke
Tip
Matching Server and Client Constraints
Dynamic Columns
Partial Indexes
Expression Indexes
All Operators Call Functions
Passing Arguments to Functions
Creating Virtual Columns
Null
Summary (Part 11/11)
Null
s in Arrays and
Row
Expressions (Part 10/11)
Handling Growth with Postgres: 5 Tips From Instagram
Mapping
Null
s to Strings (Part 9/11)
Null
s and Aggregates (Part 8/11)
Ordering and Indexing
Null
s (Part 7/11)
Comparing
Null
s (Part 6/11)
Pg_Upgrade Now Supports Parallel Copy/Link
The
Not In
Null
Trap (Part 5/11)
The Three-Valued Logic of
Null
s (Part 4/11)
The Non-Value of
Null
s (Part 3/11)
Explicit and Implicit
Null
Generation (Part 2/11)
Null
s Make Things Easier? (Part 1/11)
Programatic Control of postgresql.conf Settings
You Added What JSON Features in Postgres 9.2?
Reload Is Powerful
Unix Domain Socket Location
Centralizing Connection Parameters
Monitoring Postgres from the Command Line
Turn off the drive write cache! Turn on the cache! Huh?
Memory Overcommit
I Don't Need Swap Space
Generating Random Data Via
Sql
Want a Free Remote Database?
Dud, Flood, & Bud
Matching Client and Server Languages
What Are
Oids
The Double Quote Trap
Cluster, Cluster, Schema, Schema
Transactional
Ddl
I Don't Need Backups, I Use
Raid1
!
Template1 Me!
Why Use Multiple Schemas?
Take a Dip in the Pooler
When to Use Multiple Clusters, Databases, or Schemas?
Avoiding Logical Dump Pitfalls
Multiple Databases and Global Objects
Selecting All Columns and TOAST
Don't Ignore shared_preload_libraries
Three Ways to Install Postgres
Why You Should Care About Libpq
Limiting Postgres Connections
Virtualizing Postgres
Postgres Memory Surprises
Revisiting Memory Reporting
Toast
Queries
Toast
-y Goodness
What Is a GUC Variable?
External Monitoring Tools
Surrogate Keys Can Become Natural Keys
Reliable Writes
Why Is standard_conforming_strings Enabled in Postgres 9.1?
Finding Xmax
Database Reliability
Postgres on Amazon's EC2
New Replication Option
VM Me
SSDs For Your Database?
Where Did My Error Come From?
Lists and Recursion and Trees (Oh, my!)
Ccache Usage
Postgres Blog Index: Ordered by Category
Postgres Developer Meetings
PgCon Developer Meeting Concluded
Conference Report
The Backend Flowchart Is Back
Video Interview
250 
Pg_Upgrade Now Handles Invalid Indexes
New Presentation Online
Good Enough?
Matching Server and Client Constraints
RSS