First, I've corrected you e-mail so that it goes to the list, and not to
> I use my PostgreSQL 8.0.4 as Catalogue-Database for Bacula.
> Bacula is a Backupsoftware.
Yes. The lead contributor to Bacula is a active PostgreSQL project
participant; I'll see if he'll look into your issue.
> When I backing up System (lot of very small Files) then PostgreSQL seams to by the bottleneck by inserting Catalogueinformation of every single File.
> The System on which Postgres runs is a Sun Solaris 10 Server on a Sun Fire V240 with 1GB RAM, 1CPU (SUNW,UltraSPARC-IIIi at 1.3GHz), 2 Ultra SCSI-3 Disks 73GB at 10k RPM which are in Raid1 (Solaris Softraid).
> Can someone gif me a hint for compiling PostgreSQL or configuring the Database.
> fsync is already disabled..
This is a bad idea if you care about your database.
So, PostgreSQL 8.1 is now official supported by Sun and ships with
Solaris 10 update 2 or later. It is recommended that you use that
rather and an out-of-date version. Second, see
pgsql-performance by date
|Next:||From: Arjen van der Meijden||Date: 2006-11-17 19:19:59|
|Subject: Re: availability of SATA vendors|
|Previous:||From: Jeff Frost||Date: 2006-11-17 17:45:42|
|Subject: availability of SATA vendors|