From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | "martin(dot)berner(at)braunvieh(dot)ch" <martin(dot)berner(at)braunvieh(dot)ch> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Optimicing Postgres for SunSolaris10 on V240 |
Date: | 2006-11-17 18:44:12 |
Message-ID: | 455E02FC.6020103@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Berner,
First, I've corrected you e-mail so that it goes to the list, and not to
me directly.
> 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
www.powerpostgresql.com/PerfList
--Josh Berkus
From | Date | Subject | |
---|---|---|---|
Next Message | Arjen van der Meijden | 2006-11-17 19:19:59 | Re: availability of SATA vendors |
Previous Message | Jeff Frost | 2006-11-17 17:45:42 | availability of SATA vendors |