I've been using postgres since it was postgres95, not sure when that was really, but it's been a while. It has always been a wonderful DB. Sure there are a few things I'd like, but it's good enough to run half the state of Illinois circuit courts' data on for the last 8 years.
The 8.3 release allowed me to speed up some very difficult queries involving people searching on full_name=s% on the site where the search could run for 30-40 seconds, and this is on dedicated storage arrays. 8.3 allowed me to redcue the time to half a second or so. I couldn't have been more pleased.
I've always found tom lane to be extremely helpful with performace issues and what not. There's a great support community out there. It just a joy to use, and I know from my logs, that PG can handle 6 million+ queries and 1 million+ updates against a 300Gig DB every month on 4 thousand dollars worth of hardware.
These folks will never get enough praise as far as I'm concerned.
Posted Apr 18, 2009 23:34 UTC (Sat) by nix (subscriber, #2304)
[Link]
Postgres95... that would be 1995. It's, y'know, in the name.
PostgreSQL 8.4 Beta: "We've got momentum"
Posted Apr 21, 2009 12:03 UTC (Tue) by jeremiah (subscriber, #1221)
[Link]
Was it really? My memory must be confusing it with windows 95 that seemed to show up at
sometime before or after 1995. Wasn't there also version before postgres95. Like just
postgres? I'm too lazy to look it up right now though. My point being in that for the last 14
years. It's proven dependable, and a great product to work with.
PostgreSQL 8.4 Beta: "We've got momentum"
Posted Apr 21, 2009 21:49 UTC (Tue) by roelofs (guest, #2599)
[Link]
I've always found tom lane to be extremely helpful with performace issues and what not.
Yes, he's a great guy. His alter ego is Captain JPEG, and he pops up in PNG circles every now and then, too.
Greg
PostgreSQL 8.4 Beta: "We've got momentum"
Posted Apr 21, 2009 22:54 UTC (Tue) by nix (subscriber, #2304)
[Link]
Oh, those are the same Tom Lane?
He gets around.
(I got quite a shock when I realised that the binutils-and-GCC Ian Lance
Taylor was the Taylor in Taylor UUCP... there are only a thousand real
people in the world and they keep popping up over and over again.)