Re: Question: Who's Using Postgres - Mailing list pgsql-general

From Gavin M. Roy
Subject Re: Question: Who's Using Postgres
Date
Msg-id 000001c1bb6b$117a0a30$03ab8540@Gavin
Whole thread Raw
In response to Question: Who's Using Postgres  ("Corey W. Gibbs" <cgibbs@westmarkproducts.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sorry for the late reply, was on vacation :D

Lets see:

We've got a Windows based Point of Sale application in over 50 stores
nation wide tied to a Linux based server farm running PostgreSQL 7.2
via a frame-relay network.  The POS application talks xml over http
to apache/php.  My database has over 30 Million dollars of
transactions and has been rock solid without any issues.  This is a
true enterprise system which runs our retail company.  Our
applications are either web based (built with php and tools like
pdflib) or built in Windows using Borland C++ Builder & Crystal
Reports (over odbc).  We use PgSQL as the backend for

A) Transaction processing (financial data)
B) Purchasing
C) Inventory Control
D) HR Control including ADP integrated Time clock
E) Customer management
F) Web site content management

As far as data quantity:

  Over 20 million rows of data in 11 databases and approximately 130
tables.  (haven't counted in a while)

Disk Space:

postgres@lurch:/usr/local$ du -sb pgsql
5178126336      pgsql

PgSQL Server Memory:

postgres@lurch:/usr/local$ free
             total       used       free     shared    buffers
cached
Mem:       3868244    3857728      10516          0      11720
3654356
- -/+ buffers/cache:     191652    3676592
Swap:       297192       2040     295152

I would and do recommend PostgreSQL to anyone that wants a true
enterprise level open source rdbms (and even non-open source).

I hope that this helps!

Gavin

- -----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Corey W.
Gibbs
Sent: Friday, February 15, 2002 7:08 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Question: Who's Using Postgres


Good Morning Everyone,
I have a general question about who is using Postgresql.  This is not
a
marketing survey and any information I collect will only be used by
me.
 Here's the background.
I have a user who has developed a Visual Basic application that uses
MS
Access files for it's data storage.  Currently, this datafile is
about
fifty megs in size.  There are about fifteen users who use these
files in
the application, needless to say, this is having a severe impact on
our
network.  After much heartache and pain, I was able to convince him
that we
need to look at a RDBMS to put the data on.  Of course, I suggested
Postgres as an alternative to MS SQL server for many reasons.  Linux
runs
on all of my servers, I'm happy with it's performance and
reliability.  I'm
currently running Postgres as my web server's backend.  Opensource
software
does not scare me.  However, his side of the camp comes from the
Windows
world.  "It has to be MS SQL server.  It'll be easier to program to
than
any other server." "Opensource software isn't going any where." "Can
we
depend on it?" are common questions and statements I have heard.
I am not trying to start a ruckus or a flamewar, but I would like to
know
who's using Postgres out there.  What's the application?  How big are
your
databases?  Are you using Visual Basic or C to connect to it through
ODBC
or are you using a Web interface?
Any information you can provide will be greatly appreciated.
thank you
Corey W. Gibbs


- ---------------------------(end of
broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPHXmmX9xeBXAlKqsEQKs7ACg8/PV9k+PIVyiTFWCf7zqsOeHz18An1lF
DzI6tTp0vIjOTolbToey7N3k
=tQP7
-----END PGP SIGNATURE-----


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Createdb problems
Next
From: Michael Meskes
Date:
Subject: Re: ecpg Question