RE: [GENERAL] info on people running postgre

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
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<