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