Home
Blogs
General
Postgres
Comment
Events
FAQ
Favorites
Articles
Books
Children
Documents
Hobbies
Movies
Music
Periodicals
Quotes
Sayings
Television
Videos
Artistic
Humorous
Serious
News
Presentations
PG Admin.
PG Book
PG Extended
PG Internals
Open Source
PG Perform.
PG Project
PG SQL
Security
General
Selecting
Press
Résumé
Search
Travel Map
Contact
Private Area
↑
↑
Postgres Blog Index: Ordered by Category
View Detail
View Chronological Index
Administration
Safety Systems Can Reduce Safety
When Does a Commit Happen?
Visualizing Collations
What is an
Lsn
?
Taking Snapshots of Clusters Which Use Tablespaces
Moving Tables, Indexes, and Tablespaces Between Clusters
Why
Pgdata
Should Not Be at the Top of a Mount Point
Using Non-Login Roles
Trigger Me Writable
Moving Tablespaces
Switchover/Failover and Session Migration
Multi-Host Pg_dump
Monitoring Complexity
Tuning Autovacuum
Limiting Memory to Avoid the
Oom
Compressed Tablespaces
Using Docker with Postgres
Session State Failover
Logical Replication
Wal
Archive: Local or Remote?
The Hot Standby Tradeoff
Sent, Write, Flush, Replay?
Switchover vs. Failover
Incremental File System Backup
Wal
Archive Management
Getting the Most Out of
application_name
Dynamic Logging Control
Postgres Alerts
Beware of Antivirus Software with Postgres
Use Kill -9 Only in Emergencies
Controlling Autovacuum
What Are Timelines?
Monitoring Postgres from the Command Line
Dud, Flood, & Bud
Avoiding Logical Dump Pitfalls
Three Ways to Install Postgres
External Monitoring Tools
New Replication Option
Ccache Usage
Master/Slave Replication
Client
Controlling Server Variables at Connection Time
Connect Parameter Specification Options
Controlling Connection Parameters Using Environment Variables
Installing PL/v8
Multi-Host Libpq
When To Use Server-Side Logic
Matching Client and Server Constraints
Matching Client and Server Languages
Why You Should Care About Libpq
ORMs and Their Discontents
MVCC For Programming Languages
Community
No Travel
PgLife for Familiarization
Users vs. Developers
Long-Haul Behavior
"Get Off My Lawn"
Three-Year Cycle
Web Forums?
'You need to set a tone where everyone in the community feels valued'
A Business Card History of Postgres
My Daughter Speaks
Tom Lane Changes His Employer
The Purpose of the Core Team
PgPool Improves Reliability
PgCon Developer Meeting Concluded
Recruiters A'Callin
I Feel Sorry for Closed-Source Developers
Postgres Developer Meetings
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
Dinner Q&A
Percona Live Online
Las Vegas Event at re:Invent
Ibiza: A Different Type of Conference
Submitting Talks to Conferences
Video of Russian Interview
Interview in China
Why Attend Conferences?
Speaking in China
Postgres Party
Thirteen Conferences in Four Months
Lots-O-Travel
2016 Conferences
PgCon 2015 Developer Meeting Photo
2015 Postgres Conferences
Postgres Gets the Business
Integrated Cache Invalidation for Better Hit Rates
Visualizing Postgres Feature Growth
Explain
Output Generates Enthusiastic Applause
Five Events
Upcoming Conferences
PGCon Conference Report
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
Configuration
First Wins, Last Wins, Huh?
Programatic Control of postgresql.conf Settings
Reload Is Powerful
Centralizing Connection Parameters
What Is a GUC Variable?
The Optimal Number of Database Performance Settings
Data modeling
Can Case Comparison Be Controlled?
Force One Row
Storing Binary Data in the Database
Views vs. Materialized Views
Extensibility
Data Storage Options
Getting Object Creation Time
Data in the Database vs the File System
Allowing Only One Null
Use All Your Constraints
Passing Arguments to Functions
Creating Virtual Columns
You Added What
Json
Features in Postgres 9.2?
Transactional
Ddl
Surrogate Keys Can Become Natural Keys
Lists and Recursion and Trees (Oh, my!)
Documentation
Intermediate Certificates
Wal
and Xlog
Built-In Sharding Wiki Page
Postgres 9.6 Features
Postgres 9.5 Draft Release Notes
Postgres 9.3 Release Notes Updated
9.3 Release Notes Ready for Beta
Starting on 9.3 Release Notes
The Backend Flowchart Is Back
Postgres 9.2 Draft Release Notes Published
Starting on 9.2 Release Notes
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
Partial Progress in Proofreading the Postgres Manual
8.4 Release Notes
Working on 8.4 Release Notes
Query Source Code Flow Diagram Completed
Query Source Code Flow
TODO TO-Gone
Reading Through the Manual
Hardware
Hardware Acceleration for Databases
Huge Pages
Tablespaces on Transient Storage
Ssd
s and
effective_io_concurrency
Raid
Controllers and
Ssd
s
Das
vs
San
vs
Nas
Turn off the drive write cache! Turn on the cache! Huh?
Memory Overcommit
I Don't Need Swap Space
I Don't Need Backups, I Use
Raid1
!
Virtualizing Postgres
Postgres Memory Surprises
Revisiting Memory Reporting
Increasing Database Reliability
Intel Pushes Out Firmware Update For 320 Series SSDs
Reliable Writes
Database Reliability
Postgres on Amazon's EC2
VM Me
Indexing
Boolean Indexes
Global Indexes
Creating Descending Indexes
Index Order Does Matter
Expression Index Statistics and Joins
Statistics on Expression Indexes
Partial Indexes
Expression Indexes
The Externality of Index Creation
Internals
Avoiding Cache Wipe, Synchronized Scans
Why Do We Freeze?
Postgres Internals Website
Portability's Surprising Win
The Meaning of
Wal
A New Pgindent
PG-C
Raw Device Optimization
Double Buffering Blues
What Are Checkpoints?
Inside the
Wal
Column Storage Internals
All Operators Call Functions
What Are
Oids
Selecting All Columns and TOAST
The Most Important Postgres CPU Instruction
Toast
Queries
Toast
-y Goodness
MVCC Unmasked
Now Online
Finding Xmax
Where Did My Error Come From?
Reaching Out to Middleware Users
News
Postgres Marketing
Draft of Postgres 13 Release Notes
Release of pgcryptokey
Draft of Postgres 12 Release Notes
Draft of Postgres 11 Release Notes
Recent Interview
Draft of Postgres 10 Release Notes
Updated Blog Categories, Images
Yandex Mail Completes Three-Year Migration from Oracle to Postgres
Oracle Attacks Postgres in Russia
Postgres Pool Party
PgLife Is Six Months Old
Video Interview
PgLife Averages Thirty Active Users
PgLife Is Now Live
Twenty-One Hours to Exploit
My Blog Changes
Want a Free Remote Database?
Teaching Again at Drexel
Postgres Pool Party
Report from PGCon
The New Postgres Era
Postgres Getting Increased Attention
Sorting Performance Improvement for Postgres 9.2
New Server
Coming to Boston
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
School Is Out
JPUG Tenth Anniversary
Award
Busy Week
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
Preparation for 8.4, Travel
Final Feature Decisions for 8.4
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
OSCON Grand Prize
Appointed to PgUS Board
Russian Chat Session
pgpool PG Pool Party
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
NoSQL
Which NoSQL Database For New Project?
Postgres Gives Developers More Options with NoSQL
YeSQL: Battling the NoSQL Hype Cycle with Postgres
Dynamic Columns
The Future of Relational Databases
NoSQL Databases as the New Scripting Language
Learning from NoSQL
Settling for NoSQL
Null
Null
Summary (Part 11/11)
Null
s in Arrays and
Row
Expressions (Part 10/11)
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)
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)
Object bundles
Creating Extensions in Schemas
Cluster, Cluster, Schema, Schema
Template1 Me!
Why Use Multiple Schemas?
When to Use Multiple Clusters, Databases, or Schemas?
Multiple Databases and Global Objects
Performance
With ... Materialized
and Optimizer Control
Background Writes
Optimal Use of
Ssd
s
Does Postgres Support Compression?
Multi-Host Technologies
Performance Goalposts
Fast Enough?
Threaded Postgres
Why Use Multi-Master?
Compiled PL/pgSQL?
Wal
Directory Location
Windows and Shared Buffers
Micro-Optimizations
Optimizer Hints
Allocating
work_mem
The Memory Resource Triad
Oracle Real Application Clusters (RAC)
Query Planner Interview
Sharding Update from Asia
Vectorize Surprise
Index Everything
Future Optimizer Enhancements
Partitioning in Postgres 10 and Beyond
A Hierarchical Read-Scaling Architecture
Materialized Views and Foreign Data Wrappers
External Poolers
Wait Event Reporting
Still No Query Hints?
Going Deep on Stats
Performance Goalposts
Two More Interviews
Be Prepared for
Prepare
Cpu
s Are Slowing Us Down
Parallelism Roadmap
Handling Growth with Postgres: 5 Tips From Instagram
250
Tps
Generating Random Data Via
Sql
Timing Query Internals
Timing a Query
Speeding Up by Condensing
Parallel Query Report from the PGCon Developer Meeting
The Effectiveness of
effective_cache_size
Measuring Free Memory and Kernel Cache Size on Linux
Caching Levels
Take a Dip in the Pooler
Don't Ignore
shared_preload_libraries
Let's See
work_mem
Scalability What?
Parallelism Is Coming
Scalability Improvements Are Coming
What Every Data Programmer Needs to Know about Disks
SSDs For Your Database?
Benchmark Comparison
Pg upgrade
The Future of Major Version Upgrades
Zero Downtime Pg_upgrade
Pg_Upgrading Streaming Standbys
Pg_Upgrade Now Handles Invalid Indexes
Pg_Upgrade Now Supports Parallel Copy/Link
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
Lessons from the Online Conference Trenches
Databases, Containers, and the Cloud
The Democratization of Databases
Postgres 12 Features Presentation
Exploring Postgres Tips and Tricks
Updated Sharding Presentation
The Maze of Postgres Options
Postgres 11 Features Presentation
Will Postgres Live Forever?
Four New Security Talks
Reorganized Presentations
Postgres Window Magic
Postgres 10 Features Presentation
Postgres Videos
Non-Relational Postgres
Michael Stonebraker's Turing Award Lecture
Postgres 9.5 Features Presentation
Sharding Presentation
Postgres Rising in Russia
Two New Presentations
New Presentations
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
Two New Presentations
Updated Presentation: The Magic of Hot Streaming Replication
PG East: Slides
Presentation License
Security
Implementing Transparent Data Encryption in Postgres
Expanding Permission Letters
Permission Letters
Limiting Superuser Activity
Postgres Encryption Maze
Pooler Authentication
Synchronizing Authentication
Insufficient Passwords
Removable Certificate Authentication
Three Factors of Authentication
Fourteen Authentication Methods
Signing Rows
Client Row Access Control
Cryptographically Authenticated Rows
Foreign Data Wrappers and Passwords
Certificate Revocation Lists
Using
Ssl
Certificates
Creating
Ssl
Certificates
Ssl
Certificates and Certificate Authorities
Layers of Security
Unix Domain Socket Location
Limiting Postgres Connections
Security-Enhanced Postgres
New Security Talk
Considering Security-Enhanced Postgres
Sql
Trusted and Untrusted Languages
Order of
Select
Clause Execution
Imperative to Declarative to Imperative
Composite Values
At Time Zone
Confusion
Blocking
Ddl
Using
Xmin
in Queries
Percent_rank
vs.
Cumm_dist
Storing the Original Time Zone
PL/pgSQL's Good
Sql
Alignment
Identifier Case Sensitivity
The Decline of Hstore
Playing With IPv6
Odd Month Arithmetic
Use
With Time Zone
PL/Java Adoption
Postgres Keywords
Casting to Data Types
Referencing
Select
Column Aliases in
Where
Clauses
Characters Sets, Encodings, and Collations
Outer Joins and
Where
Clauses
The Double Quote Trap
Why Is
standard_conforming_strings
Enabled in Postgres 9.1?
Thoughts
Two Interviews
Database Interoperability at Risk
The High Value of Data
Tool Vendor/Support Options
SQL Replay for Replication?
Lock-In Is Not a Binary Decision
Corporate Backing
Breaking Backward Compatibility
Postgres vs PostgreSQL
You Don't Need Every Feature of Your Previous Database
Moscow Interview
Analyzing Postgres Adoption
The Plan for FDW-Based Sharding
Postgres Going in Multiple Directions
Salesforce Abandoning Postgres Migration?
How Managers View Postgres
Done Studying Perl
Good Enough?
Postgres Is Good Enough
Postgres as a Data Platform
Table Partitioning Needs Improvement
The Middleware Porting Challenge
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
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
Financial Disincentive
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
Professionalism at PGCon
Old School
What Have We Forgotten About Growing?
Pet Peeves
Quixotic?
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
↑
Postgres Blog Index: Ordered by Category
Safety Systems Can Reduce Safety
Controlling Server Variables at Connection Time
No Travel
Dinner Q&A
First Wins, Last Wins, Huh?
Can Case Comparison Be Controlled?
Intermediate Certificates
Hardware Acceleration for Databases
Boolean Indexes
Avoiding Cache Wipe, Synchronized Scans
Postgres Marketing
Which NoSQL Database For New Project?
Creating Extensions in Schemas
The Future of Major Version Upgrades
Lessons from the Online Conference Trenches
Implementing Transparent Data Encryption in Postgres
Trusted and Untrusted Languages
Two Interviews
RSS