Jacob Kaplan-Moss

38 items tagged โ€œpostgresqlโ€

๐Ÿ“Œ 2ndQuadrant/repmgr

Replication manager for psql hot/warm standby. Documentationโ€™s a bit lacking right now, but looks pretty intuitive. #

๐Ÿ“Œ Django snippets: Server Side Cursors for Django's psycopg2 Backend

We should add this to Django. #

๐Ÿ“Œ Annotated postgresql conf, 9.0 Edition

Woohooโ€”Josh updated the annotated conf to version 9.0. An indispensable resource for PostgreSQL tuning. #

๐Ÿ“Œ 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. #

๐Ÿ“Œ Replication, Clustering, and Connection Pooling - PostgreSQL Wiki

Nice high-level comparison of the various PostgreSQL replication, clustering, load balancing, and connection pooling solutions. #

๐Ÿ“Œ 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. #

๐Ÿ“Œ Hot Standby - PostgreSQL Wiki

Run read-only queries against a database in recovery mode receiving shipped logs, thus allowing simple load balancing for read-heavy applications. This is a candidate for inclusion in Postgres 8.4; I really hope it makes it in. #

๐Ÿ“Œ 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 #
๐Ÿ“Œ Greg Smith's Note Magnet: Automating initial postgresql.conf tuning

Preliminary work on an automatic tuning tool for PostgreSQL. This is a pretty big deal: a good postgresql.conf translates into major performance gains, but getting things just right can be quite confusing. #

๐Ÿ“Œ 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. #