| From: | "Matt Clark" <matt(at)ymogen(dot)net> |
|---|---|
| To: | "Jack Coates" <jack(at)lyris(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql-performance" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: tuning questions |
| Date: | 2003-12-09 17:07:53 |
| Message-ID: | OAEAKHEHCMLBLIDGAFELMEFAEEAA.matt@ymogen.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
> I ended up going back to a default postgresql.conf and reapplying the
> various tunings one-by-one. Turns out that while setting fsync = false
> had little effect on the slow IDE box, it had a drastic effect on this
> faster SCSI box and performance is quite acceptable now (aside from the
> expected falloff of about 30% after the first twenty minutes, which I
> believe comes from growing and shrinking tables without vacuumdb
> --analyzing).
Hmm. I wonder if that could be related to the issue where many IDE drives have write-caching enabled. With the write cache enabled
fsyncs are nearly immediate, so setting fsync=false makes little difference...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2003-12-09 17:15:51 | Re: PostgreSQL port to pure Java? |
| Previous Message | Jack Coates | 2003-12-09 16:57:53 | Re: tuning questions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-12-09 17:35:04 | Re: tuning questions |
| Previous Message | Jack Coates | 2003-12-09 16:57:53 | Re: tuning questions |