bmurphy

5 ms·

1.
by bmurphy 14y ago
Just because you have 16gb of memory doesn't mean you won't ever swap. Firefox is not the only application running on a computer. My working set is routinely over 7gb and I have 8gb on my laptop. A goldfish will grow to full its bowl. I
2.
by bmurphy 15y ago
I used MSSQL up to MSSQL 2005 and MySQL up until about the same time. Around then I switched over to PostgreSQL completely and have not had a reason to go back. My biggest complaints had to do with simple replication and that was mostly s
3.
by bmurphy 15y ago
I agree with the parent. Something very simplistic in json or yaml would be preferred.
4.
by bmurphy 15y ago
I can't play it. I've played too many FPS and Flight Simulators in my time. The controls need to be inverted so i can fly it like a real plane. Too bad.
5.
by bmurphy 15y ago
Absolutely. You should always be spreading your data across multiple availability zones and where feasible across multiple data centers and S3 is a great place to store your wal logs. We do the same thing.
6.
by bmurphy 15y ago
EBS is a shared networked SAN. The performance characteristics of it are not that great and even worse, highly variable. The last thing you want to be running your database on is a system where the performance characteristics vary greatly
7.
by bmurphy 15y ago
Very nice, thank you. Mostly all of this is good advice and correlates nicely with my experience. One thing though: "EBS volumes and Software RAID is best but scary on AWS" I've managed an EBS RAID10 database for a few years now. I wouldn
8.
by bmurphy 15y ago
Agreed. I personally go through my RSS feed every few months and re-evaluate my feeds. If I have feeds that have low signal to noise ratios, or simply publishes articles that I never read, I remove them. Also, I segregated high volume feed
9.
by bmurphy 15y ago
Nope, he does not mean open a port. Ports is the name of the packaging system FreeBSD uses, and a port is the equivalent (more or less) of an RPM or deb source package. http://www.freebsd.org/ports/
10.
by bmurphy 15y ago
Nice. Much better.
11.
by bmurphy 15y ago
As the Father of a 19 month old I can only say this is a complete rip-off. Craig's list, friends and family, birthdays, holidays, garage sales, second hand stores, 50% off coupons, the list goes on and on. $16/mo for two outfits? Really?
12.
by bmurphy 15y ago
Argh. Same crap as with all the population predictions. Everybody always assumes the graph is exponential. It is not. It always levels off. The real trick is predicting where/when that will happen.
13.
by bmurphy 15y ago
You could always replace it with an EBS volume.
14.
by bmurphy 16y ago
I don't have solid numbers, just some experience using this. Ephemeral drives outright fail more often than EBS volumes, however, EBS volumes suffer performance degradation significantly more often than ephemeral drives. EBS volume perfor
15.
by bmurphy 16y ago
My experience has been that EBS handles concurrent loads better, ephemeral drives handle non-concurrent loads better. Transferring 100gb+ of data on EBS (even with an 8x RAID) is a nightmare. Ephemeral drives, however, it's fairly fast. Th
16.
by bmurphy 16y ago
I tuned the hell out of our big postgresql instance a year ago, but I'll be damned if I can remember the rational for every change. I have a list of all the changes from default, but I've long since forgotten/lost the reason for making the
17.
by bmurphy 16y ago
Yes. Except, anybody who is doing RAID-0 over an EBS volume for perf reasons is ASKING for trouble. You need to do RAID-10. EBS volumes CAN and DO fail.
18.
by bmurphy 16y ago
Having been running a 200gb millions of transactions per day Postgres cluster on Amazon's EC2 cloud for two years now, I can attest to the fact that EBS performance and reliability SUCKS. It is our SINGLE biggest problem with EC2. 200gb re
19.
by bmurphy 16y ago
That song is terrible (and I love Devin Townsend, the singer).
20.
by bmurphy 16y ago
Interesting, but I really don't think this belongs here.
21.
by bmurphy 16y ago
Disk I/O performance that doesn't suck. Let us add dev pay instances to an ELB. More ram. Elastic private ip addresses. Change security groups of running instances. I have a lot more, but those are my big ones.
22.
by bmurphy 16y ago
You're right. But it's not happening now. I don't see it. Who are the alternatives everybody is flocking to? They don't exist. Don't get me wrong. I'm hopeful for a new world of open protocols and you controlling your own data, but I ju
23.
by bmurphy 16y ago
There are no Facebook alernatives. My friends and family are on Facebook. They are not on ANYTHING else. Until that changes, which I suspect it won't, nothing else will be viable.
24.
by bmurphy 16y ago
I just ran the same test. Set up a 2 slave cluster, killed slave 2, then killed the master. Ran pg_last_xlog_receive_location on each slave, picked the one that was furthest along in the timeline, promoted it to be the new master and the
25.
by bmurphy 16y ago
Yes, that's exactly what I was referring to, you're getting a new timeline. You need to rebase the slaves and you have no real-time backup for a few hours. Sucks. You have to be very careful, and there are all sorts of ways you can break
26.
by bmurphy 16y ago
Close. Postgres has traditionally focused on letting the community provide replication solutions, but we've been screaming so long for one that "just works" that they're finally getting around to building it. I wouldn't say it covers 95% o
27.
by bmurphy 16y ago
I was reading Heart of Darkness but took a break from it to read PostgreSQL 9.0 High Performance.
28.
by bmurphy 16y ago
Seriously missing a lot of languages here. Where's Objective C? Visual Basic?