Jacob Kaplan-Moss
Activity tagged “postgresql”
Bookmarks
pgRouting
Geographic routing algorithms on top of PostGIS.
Waiting for 8.5 – Hot Standby
A first look at hot standby (a.k.a. read slaves) will work in PostgreSQL 8.5. Mark my words: 8.5 is going to be a watershed moment for PostgreSQL.
What happened to Hot Standby?
It's decisions like this that make me confident and happy about my choice of PostgreSQL. I can barely wait for hot standby to land, but features are worthless if they're not stable. Maintainers willing to make tough cuts like this one are what makes quality software.
Feeding the Cloud: Finding the size of a Postgres database on disk
We were just discussing the easiest way to do this at LPDN last night.
Database test: dual Intel Xeon 5160 (6/6) | Tweakers.net
Comparing MySQL 4, MySQL 5, and Postgres 8. Don't pay too much attention to the numbers, but notice the shape of the graphs. MySQL does worse after about 7-10 concurrent queries, but Postgres gets the same throughput at 10 concurrent requests as it does at 100.
Amazon Web Services Blog: 100% on Amazon Web Services: Soocial.com
A look at one app's AWS architecture. Nginx, HAProxy, Rails, pgpool II, PostgreSQL, and RabbitMQ. I didn't realize that pgpool II did sharding at the balancer layer; that makes this kind of set up much easier.
Josh Berkus: Finding Useless Indexes
“PostgreSQL 8.3, by improving the Stats system, has made it very easy to find your useless indexes. These are indexes which aren't being used by any regular query, and don't enforce a constraint. Unneeded indexes cost you in several ways: they slow updates, inserts and deletes; they may keep HOT from updating the row in-place, requiring more VACUUMs; they take time to VACUUM; they add to query planning time; they take time to backup and restore. So we want to get rid of them. ”
Waiting for 8.4 - Common Table Expressions (WITH queries)
Awesome new feature that'll land in PostgreSQL 8.4. WITH is basically just a nice way of declaring query-local temporary tables, but WITH RECURSIVE is… just awesome.
44_annotated_gucs_draft1.pdf (application/pdf Object)
PostgreSQL 8.3 config values, documented and annotated.
Tuning Your PostgreSQL Server - PostgreSQL Wiki
Finally a good guide to tuning Postgres straight from the source.
pgmigrate - Google Code
Another database migration tool. This one's not Django-specific (though it will work with Django), but it is PostgreSQL specific. I'm really quite happy with the competition in this space right now; it'll force any eventually Django built-in migration to
Understanding PSQL's MVCC | One More Blog
Eric explores how MVCC actually works in Postgres. Good stuff; I'd vaguly understood this before reading the post, but now I think I really get what's going on.
Autovacuum internals - Usama's personal blog
I've always wondered about this stuff; this is a great explanation.
EnterpriseDB Book
Could be an interesting book. EnterpriseDB is a commercial distro of PostgreSQL that aims (and achives) nearly total Oracle compatibility. I've always wanted to look closer at EnterpriseDB; this book might be a good excuse.
tending the garden › psql and file, CSV exports
Oh, sweet: COPY … TO STDOUT WITH CSV
Bucardo - multi-master replication for Postgres
“Bucardo is an asynchronous Postgres replication system, allowing for both multi-master and multi-slave operations.” Whoa.
Welcome | PostgreSQL for Mac | Andy Satori
Very well-done Postgres Mac packages; they Just Work (and even correctly set up pg_config so that extensions build correctly out of the box). My new Best Way of installing PG on a Mac.
PostgreSQL: Documentation: Manuals: PostgreSQL 8.2: The Statistics Collector
Info about Postgres' stats collector and associated views. I just discovered the pg_stat_user_tables and pg_stat_user_indexes views which are amazingly helpful.
PostgreSQL warm standby on ZFS crack - Esoteric Curio
Pretty amazing technique: use ZFS to allow read/write against WAL-shipped warm standby PostgreSQL databases. ZFS FTW!
Another PostgreSQL Diff Tool - Welcome to Another PostgreSQL Diff Tool
Diff two PG schemas. Very cool.
Efficient SQL
Greg Mullane's complete talk on optimizing postgresql. Looks like a few things have changed since 2003 (7.3 —> 8.2), but this still seems *very* relevant.
EXPLAIN plan Operators
Ridiculously in-depth explanation of what PostgreSQL means when you ask it to EXPLAIN. This is probably the only place this information lives.
SqliteToPgScript - Trac Hacks - Plugins Macros etc. - Trac
Script to migrate a SQLite trac database to PostgreSQL. Needed a couple of hacks by hand, but otherwise works quite well.
SkypeGarage/DbProjects/SkyTools - Skype Developer Zone
Replication, WAL shipping, queuing tools for PostgreSQL, developed by Skype.
Varlena, LLC | PostgreSQL General Bits Newsletter
Some good tips on organizing DB schema updates. I'd like Django's schema evolution framework to work something like this.
Performance Tuning PostgreSQL
PostgreSQL is the most advanced and flexible Open Source SQL database today. With this power and flexibility comes a problem. How do the PostgreSQL developers tune the default configuration for everyone? Unfortunately the answer is they can't.
Entries
Fixing PostgreSQL’s default encoding on Ubuntu 9.10
Ubuntu 9.10 installs PostgreSQL with a default encoding of SQL_ASCII. This is stupid. Here’s how to fix it.