Bruce Momjian: Postgres Blog Index: Ordered Chronologically

Postgres Blog Index: Ordered Chronologically

View Detail
View Category Index

PgCon Developer Meeting Concluded

Video Interview

PgLife Averages Thirty Active Users

PgLife Is Now Live

9.3 Release Notes Ready for Beta

Starting on 9.3 Release Notes

Matching Server and Client Constraints

Dynamic Columns

Pg_Upgrade Now Handles Invalid Indexes

Twenty-One Hours to Exploit

Partial Indexes

Expression Indexes

All Operators Call Functions

Passing Arguments to Functions

Creating Virtual Columns

Good Enough?

Postgres Is Good Enough

Postgres as a Data Platform

Conference Report

Table Partitioning Needs Improvement

The Middleware Porting Challenge

The Future of Relational Databases

Parallelism Roadmap

Null Summary (Part 11/11)

Nulls in Arrays and Row Expressions (Part 10/11)

Handling Growth with Postgres: 5 Tips From Instagram

Mapping Nulls to Strings (Part 9/11)

Nulls and Aggregates (Part 8/11)

Ordering and Indexing Nulls (Part 7/11)

Comparing Nulls (Part 6/11)

Pg_Upgrade Now Supports Parallel Copy/Link

The Not In Null Trap (Part 5/11)

The Three-Valued Logic of Nulls (Part 4/11)

The Non-Value of Nulls (Part 3/11)

Pg_Upgrade Faster, Again!

Explicit and Implicit Null Generation (Part 2/11)

Nulls Make Things Easier? (Part 1/11)

Postgres: The B-52 of Databases

"You Lock Your Data in Postgres — We Cannot Fail"

Pg_Upgrade Bug with Invalid Concurrently-Created Indexes

Programatic Control of postgresql.conf Settings

My Blog Changes

Pg_Upgrade Performance Improvements

Conference Report

You Added What JSON Features in Postgres 9.2?

The 9.2 Sleeper Feature

Video of Postgres 9.2 Features

The Backend Flowchart Is Back

Lots O' Conferences

Reload Is Powerful

Upcoming Conferences

Unix Domain Socket Location

Centralizing Connection Parameters

Monitoring Postgres from the Command Line

Turn off the drive write cache! Turn on the cache! Huh?

250 Tps

99.9% Useful

Memory Overcommit

I Don't Need Swap Space

Generating Random Data Via Sql

Want a Free Remote Database?

PostgreSQL's Place in the New World Order

Recruiters A'Callin

The Externality of Index Creation

Dud, Flood, & Bud

Matching Client and Server Languages

Celko Speaking in Prague

I Feel Sorry for Closed-Source Developers

Teaching Again at Drexel

Postgres Developer Meetings

Vacation, What Vacation?

Postgres Pool Party

So You Want to Be a Committer?

What Are Oids

The Double Quote Trap

What Makes a Great Conference Site

Speaking in the Dominican Republic

Timing Query Internals

Timing a Query

Cluster, Cluster, Schema, Schema

Transactional Ddl

I Don't Need Backups, I Use Raid1!

Speeding Up by Condensing

Automatic Upgrades?

The Evolution of Pg_Upgrade

Report from PGCon

Parallel Query Report from the PGCon Developer Meeting

Template1 Me!

Postgres 9.2 Draft Release Notes Published

Postgres Drinking Game

The Effectiveness of effective_cache_size

Starting on 9.2 Release Notes

Measuring Free Memory and Kernel Cache Size on Linux

Caching Levels

Upcoming Events

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

The New Postgres Era

Software Patents: Why the Status Quo Continues?

Report from PGDay Austin

The Importance of High-Quality Documentation

Postgres Documentation

Why You Should Care About Libpq

Open Source Leadership

Pg_Upgrade and Optimizer Statistics

Pg_Upgrade Improvements Coming in Postgres 9.2

Postgres Getting Increased Attention

Report from Montreal's ConFoo Conference

CTE Presentation at ConFoo; Slides Now Online

Limiting Postgres Connections

Staying Close to Home

Part 1 of Virtualizing Postgres Now Online

The USA Is Planning a Triple Play

Sorting Performance Improvement for Postgres 9.2

Virtualizing Postgres

Let's See work_mem

Postgres Memory Surprises

Revisiting Memory Reporting

NoSQL Databases as the New Scripting Language

Scalability What?

Increasing Database Reliability

The Most Important Postgres CPU Instruction

More Lessons From My Server Migration

Presentations Updated

Growing Postgres User Groups

Parallelism Is Coming

The Travel Faucet

What Is a GUC Variable?

External Monitoring Tools

Scalability Improvements Are Coming

I'm Back

Unlocking the Postgres Lock Manager Slides Now Online

The Marathon Begins

Bug Fix for Pg_Upgrade from Postgres 8.3

Intel Pushes Out Firmware Update For 320 Series SSDs

No RSVPs, No Party

Email Snippets: Entertaining Links

Email Snippets: Community Management

Email Snippets: Reliability

Email Snippets: Philosophy

The Postgres Fall Conference Lineup

EnterpriseDB Looking for Beta Testers

Email Snippets: SQL Craziness

What Every Data Programmer Needs to Know about Disks

Postgres Now the Default Database for Mac OS X Server

Email Snippets: Self-deprecation

Need a Conference Welcome Video?

No Postgres Booth at OSCon

New Optimizer Presentation Now Online

Video Presentation from Brazil Now Online

Postgres Pool Party

Surrogate Keys Can Become Natural Keys

Pg_Upgrade Will Always Be a Hack

Changes to Pg_Upgrade In Postgres 9.1

A Cautionary Lesson from Perl 6

MVCC Webcast this Wednesday

A Postgres Song?

Postgres 9.1 in the News

Do We Have a Plan?

Release Size Analysis

One Million Strong

Radical But Useful Source Code Reformatting

Pg_Upgrade Fix Now Released in Postgres 9.0.4

Important Postgres 9.1 Features

MySQLCon Keynote Video Now Online

Yeah, I'm at MySQLCon

Critical Fix for Pg_upgrade/Pg_migrator Users

A Conference A Month

Postgres 9.1 Draft Release Notes

Postgres 9.1 Is Coming

PgEast at the Hotel Pennsylvania

PG West Selectivity Talk

MVCC Unmasked Now Online

Back from Moscow

Why Postgres Switched To Git

Two New Presentations

Pretty Docs

Mysql Is a Database Video

Reliable Writes

Baltimore, Bolivia, Boston, Moscow, San Francisco

Postgres 9.0 Feedback on Slashdot

Mirror, Mirror On The Wall, Which Is The Best Open Source DB Of Them All?

Why People Contribute to Postgres and Open Source

Security Meeting in Maryland

Why Is standard_conforming_strings Enabled in Postgres 9.1?

Speaking in New York City

Finding Xmax

Reliability Humor

Database Reliability

Development Process Article

Form Follows Failure

ORMs and Their Discontents

The Pain of Software Development

Completed User Testimonial Videos from PG East

SURGE Conference

OSCON 2010 Report

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

Updated Presentation: The Magic of Hot Streaming Replication

Postgres on Amazon's EC2

Financial Disincentive

Pg_Migrator Included in Postgres 9.0, Renamed to Pg_Upgrade

New Replication Option

Creeping to Beta

VM Me

SSDs For Your Database?

Learning from NoSQL

Settling for NoSQL

MVCC For Programming Languages

Speaking in New York City

PG East: Slides

PG East: Hotel

9.0 Release Notes Ready

PG East: What to Expect

9.0 Release Notes Creation

User Testimonial Video at PG East

9.0 Status Report

More Philadelphia Action

Why Blog?

Python Driver Confusion

Removal of Personal Copyrights

Postgres University Course Material

Where Did My Error Come From?

Caring for Your (PG) Introvert

Wanted: New Project Slogan

Postgres Is Hot In Philadelphia

Threats to Postgres

Oops, Confusing Press Release

The Next Postgres Adoption Wave

Postgres 9.0 Coming

European Union Recognizes PostgreSQL

Seeking Documentation Proofreading Assistance

Don't Confuse Companies with Community

Security Enhanced Postgres

The International MySQL Soap Opera

Growing Patch Committers

New Security Talk

Lists and Recursion and Trees (Oh, my!)

Elephant Roads: PostgreSQL Patches and Variants

Pg_Migrator Done for 8.4, New Video

Coding Simplicity

Presentation License

School Is Out

Community Communication

Reaching Out to Middleware Users

Ccache Usage

JPUG Tenth Anniversary

Development Developments

Award

Busy Week

Pg_Migrator 8.4.1 Released

Setback for Pg_Migrator

Pg_Migrator 8.4 Final Released Last Week

Partial Progress in Proofreading the Postgres Manual

Pg_Migrator Release Candidate 1

Professor Momjian

Challenges of Pg_Migrator

Pg_Migrator Beta 1 Released

Back to Email

Professionalism at PGCon

Reflections on PGCon

PG_Migrator Progress

PG_Migrator Alpha Released

Old School

PG_Migrator Status

Release Date Poll

My Goals for the Next Two Months

Postgres 8.4 Beta1

Oracle to Buy Sun

The Great Netbook Giveaway Redux

Philadelphia Tour After PG East

What Have We Forgotten About Growing?

8.4 Release Notes

Working on 8.4 Release Notes

Online Training

Query Source Code Flow Diagram Completed

Query Source Code Flow

Preparation for 8.4, Travel

Pet Peeves

Final Feature Decisions for 8.4

Security-Enhanced Postgres

Webcast Series

Quixotic?

The Optimal Number of Database Performance Settings

Slogging Toward 8.4

Postgres Globe

Postgres News Activity

Webcasts

Approaching 8.4 Beta

Spacewalk to Postgres

Less Travel

Processing Email

Reading Email During Trips

Postgres Email Activity

OpenSQL Camp Report

Attending OpenSQL Camp

Back From PG West

Perl For Development Scripts

Conference Schedule Resumed

Back to Work

Event Attendance Cancellations

Elephants Can Count Too

Report from Brasilia

The Kitchen Sink Has Arrived?

TODO TO-Gone

What Do You Do?

OSCON Grand Prize

Linuxworld Wrapup, Swag

Appointed to PgUS Board

Upcoming Presentations

Database House Of Cards

Postgres Development Visualized

Postgres Is Hot

Traveling Every Month

Master/Slave Replication

Coverity Security Scan

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

Attending FOSDEM in Brussels

Reading Through the Manual

Benchmark Comparison

8.3RC2 Needed

Start