Re: [NOVICE] Re: [GENERAL] Re: Is PostgreSQL ready for mission criticalapplications?

From: Wim van den Berge <wim(at)elp(dot)rr(dot)com>
To: pgsql-general <pgsql-general(at)postgreSQL(dot)org>, pgsql-novice <pgsql-novice(at)postgreSQL(dot)org>
Subject: Re: [NOVICE] Re: [GENERAL] Re: Is PostgreSQL ready for mission criticalapplications?
Date: 1999-11-24 15:28:14
Message-ID: 383C040E.9A20F470@elp.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You for everybodies information. I'm a relative new user of PostgreSQL.
I've only used the 6.5.3 version, and I've only been using it for about
2 weeks. In that time I have converted all of our legacy data (60+ GB)
divided over 8 databases and several hundred tables to PostgreSQL.

Our users have been using the migrated data for a week now, and I
must say I'm very happy. PostgreSQL has consistantly processed
1,200,000 hits /day. We vacume the databases every night, and
PostgreSQL has yet to fail on me once.

Queries range from simple selects, to more complex queries with group,
having, and sub selects.

I am did have some problems with the more complex datatypes, and
I did have to program around a bug in the Operating System. But that
is due to the fact that I'm bound to SCO Open Server 5.0.5.

Wim

The Hermit Hacker wrote:

> On Tue, 23 Nov 1999 marten(at)feki(dot)toppoint(dot)de wrote:
>
> > a) Due to the database layouts we are in need of doing all these nice
> > sql-statements like "group by" and "having" ... and as posted earlier
> > in this group: they're limited in PostgreSQL.
>
> Since I use 'Group By' quite a bit...Having not so much...can you be more
> specific on the problems?
>
> > b) We had problems with vacuumdb here and there. Some times it cored.
> > We've deleted a 300 MB database under psql and the backend cored ...
>
> What version of PostgreSQL?
>
> Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
>
> ************

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hostmaster 1999-11-24 16:21:09 (no subject)
Previous Message Jim Mercer 1999-11-24 14:42:37 Re: [GENERAL] Cleaning up vacuums