PDXDjango roundup: I finally got my Martini
Posted Thursday Nov 19th, 2009 09:35am
by Joshua Drake | Permalink



Shout out to Mark Long and Lacey Powers for showing up to support a Pg dude in a foreign land. Preceding my talk on PostgreSQL Performance, Adam Lowry gave and interesting intro to a database connection pooling module he wrote for Django. Essentially they bolted SQLAlchemy's pooler into Django. He then gave some metrics, showing that through the connection pooler they dropped overall request time in half. It was a basic and good indicator of why connection pooling is good, even on smaller applications. Read more...

---

blog comments powered by Disqus

Speaking at PDXDjango Tonight on PostgreSQL Performance
Posted Wednesday Nov 18th, 2009 09:41am
by Joshua Drake | Permalink



I have the unexpected pleasure of speaking at PDXDjango tonight on PostgreSQL performance. Their meetings are 90 minutes with about 60 minutes (in theory) for the main speaker. The talk I am giving is a quick introduction to PostgreSQL Performance. The description I gave to the group was:

• I am a Django developer not a DBA.
• I know nothing about PostgreSQL performance.
• What 10 things (it will be more) can I change to make PostgreSQL faster?

I am being as thorough as possible based on the time constraints and explaining what each option is and how it works. I didn't want to just say, "Change it to 10". If you are in the neighborhood, stop by and let me know all the things I say that are wrong. The meeting starts at 7:00PM.

PIE
1227 NW Davis St
Portland, Oregon
(At the corner of NW Davis & NW 12th).

---

blog comments powered by Disqus