I use a version control system called StORE which uses a relational
database as it's back end.  I use StORE with PostgreSQL, others use it
with DB2, Oracle, etc ....

I mention StORE here because it struck me that it may be a useful source
of real-world information about how PostgreSQL performs relative to
other DBMSs.  StORE databases all use the same Schema, and some are
replicated such that they contain the same data too.

PostgreSQL is the most popular database for StORE users, and is used for
a central Smalltalk community repository (StORE is a Smalltalk specific
version control system).  The public StORE repository is accessed across
the Internet by people with Modems, WiFi, T1 and LAN connections.

There have been a number of people comment on how PostgreSQL performs as
a StORE repository - some good comments, some not so good.  Either way,
given the varied use of StORE, the feedback may yield valuable
information.

The place to look for feedback from StORE users is the news group
comp.lang.smalltalk.  For example:
http://groups.google.com/groups?q=postgres+group:comp.lang.smalltalk&hl=en&lr=&ie=UTF-8&oe=UTF-8&scoring=d

I hope this is useful.

All the best,
	Bruce

BTW, I wrote the PostgreSQL driver for VisualWorks Smalltalk which is
how all StORE + PostgreSQL users access their databases.



19 Feb 2003 12:13:39 +1100
Bruce Badger <bruce_badger@badgerse.com>
Real-world usage example
Bruce Badger wrote:
<snip>
> There have been a number of people comment on how PostgreSQL performs as
> a StORE repository - some good comments, some not so good.  Either way,
> given the varied use of StORE, the feedback may yield valuable
> information.
> 
> The place to look for feedback from StORE users is the news group
> comp.lang.smalltalk.  For example:
> http://groups.google.com/groups?q=postgres+group:comp.lang.smalltalk&hl=en&lr=&ie=UTF-8&oe=UTF-8&scoring=d
> 
> I hope this is useful.

Yep, it definitely is.  We're looking for places to be PostgreSQL Case 
Studies at present, so it's probably worth Carol Ioanni (CC'd, she's 
becoming our "Case Study Expert") to join that mailing list and ask there.

Thanks heaps Bruce.

Regards and best wishes,

Justin Clift


> All the best,
> 	Bruce
> 
> BTW, I wrote the PostgreSQL driver for VisualWorks Smalltalk which is
> how all StORE + PostgreSQL users access their databases.

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi


Wed, 19 Feb 2003 12:17:33 +1030
Justin Clift <justin@postgresql.org>
Re: Real-world usage example