251 reputation
14
bio website
location
age
visits member for 4 years, 1 month
seen Nov 16 '13 at 20:29

Jun
19
awarded  Yearling
Apr
11
comment 100 terabytes database on PostgreSQL without sharding
Where does a cheap BBWC top out, IOPS-wise?
Feb
10
awarded  Citizen Patrol
Feb
5
answered Where to start fixing an IO Bottle neck in SQL Server?
Sep
26
awarded  Editor
Sep
21
comment Bad performance for a large join query in PostgreSQL 8.4.4, despite enough memory to cache entirely
Yes, I agree there's random IO, but I'm not sure that's a problem. According to your planner costs, pg thinks it's the cheapest option. Did you try adjusting them? Start a psql session, explain your query, "set random_page_cost = 10;", then explain it again. Keep raising it until the query plan changes, then explain analyze. Does it actually end up running faster? -- If it does, your random_page_cost was too low, or pg has bad statistics for the small table.
Sep
20
comment Bad performance for a large join query in PostgreSQL 8.4.4, despite enough memory to cache entirely
I'm not sure your assumptions about random io are on the mark. The query plan above looks sound to me, and you say it runs in seconds. I don't see how that would turn into hours no matter how many partitions you have. Please show us the real query, add output from explain if you can't do explain analyze.
Sep
19
answered Bad performance for a large join query in PostgreSQL 8.4.4, despite enough memory to cache entirely
Jun
28
comment Where should I put my svn repository?
I googled some quick links for you, there might be better resources out there, but these were the first i came across: The official git manual: kernel.org/pub/software/scm/git/docs/user-manual.html And gitcasts: gitcasts.com
Jun
28
comment Where should I put my svn repository?
As David says, git isn't that much harder, but has a lot of possibilities if you want to get advanced. As your local working directory in git is a full-fleshed repository in it's own (which is a huge boon compared to svn), you'll need 2-3 additional commands to synchronize with a remote repository, but you make that up again by not wasting time on certain svn idiosyncrasies.
Jun
28
answered Where should I put my svn repository?
Jun
28
awarded  Supporter
Jun
28
answered Can I upgrade a FC4 server to the latest version over the network?
Jun
23
awarded  Teacher
Jun
21
answered How do I increas MySQL Performance by throwing Memory at it?
Jun
21
answered What VPS should I use for my soon-to-launch Rails app?