On Thu, 25 Mar 1999, Juan Alvarez Ferrando wrote:
>
> collect orders and other information. Everything would have been fine but
> for the lack of row-level locking, and some problems with processes that go
>
I'm not yet doing anything in a production environment yet, but the next
version of postgresql does has something more advanced than row level
locking, MVCC. I've been running the CVS version during development and it
seems quite a bit faster than 6.4.2 as well. I'm seriously thinking about
scraping my Oracle DB at work and replacing it with postgresql. Why?
One...Oracle is on site license so I'm not out any money if I switch :-)
Two...Oracle is an absolute hog when it comes to memory and disk space.
Here is a look at top viewing an idle Oracle DB on a Solaris system
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
6174 oradba 23 0 33M 12M sleep 0:00 0.18% 0.12% oracle
6166 oradba 33 0 35M 12M sleep 0:00 0.16% 0.11% oracle
6168 oradba 33 0 33M 10M sleep 0:00 0.13% 0.08% oracle
6170 oradba 33 0 33M 10M sleep 0:00 0.13% 0.08% oracle
6176 oradba 27 0 33M 10M sleep 0:00 0.08% 0.05% oracle
6172 oradba 33 0 33M 10M sleep 0:00 0.08% 0.05% oracle
351 oradba 33 0 11M 2944K sleep 0:00 0.03% 0.02% tnslsnr
Three...By adopting postgresql as my primary db I hope to help the free
software community by dealing with problems as they come up and submitting
problem reports. The people on the dev team have always been helpful so
I'm not too worried that I'll get burned.
On a related note. I'm currently working with a local company to automate
their entire business process and GPL the resulting code. Postgresql is
currently the data storage system of the backend. We are betting that a
freeware solution with (hopefully) free software community support will
provide a better solution in the long run than a propritary one. So you
will not be alone in depending upon postgresql.
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
James Thompson 138 Cardwell Hall Manhattan, Ks 66506 785-532-0561
Kansas State University Department of Mathematics
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<