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@feki.toppoint.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@hub.org secondary: scrappy@{freebsd|postgresql}.org
>
> ************