Jacob Kaplan-Moss

Activity tagged “postgres”

Bookmarks

pgRouting

Geographic routing algorithms on top of PostGIS.

(database, geo, gis, mapping, mapserver, osm, pgrouting, postgis, postgres, postgresql, route)

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, howto, postgres, postgresql, sysadmin)

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.

(amazon, aws, cloud, database, development, ec2, haproxy, nginx, postgres, postgresql, rabbitmq, rails, scalability)

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. ”

(databases, performance, postgres, postgresql, sql)