Using segmapsize will increase the memory available for doing file system cache and ufs:freebehind=0
helps in caching bigger files in memory.
Its worth a try if you are using default UFS (without forcedirectio mount
option).
In your cache it seems the writes are having the problems
The bgwriter parameters changed in 8.1
Try
bgwriter_lru_maxpages=0
bgwriter_lru_percent=0
to turn off bgwriter and see if there is any change.
-Jignesh
Junaili Lie wrote:
Hi Jignesh,
Thank you for my reply.
I have the setting just like what you described:
wal_sync_method = fsync
I have tried this to no avail.
I have also tried changing the bg_writer_delay parameter to 10. The spike in i/o still occurs although not in a consistent basis and it is only happening for a few seconds.
On 8/30/06, Jignesh K. Shah [EMAIL PROTECTED] wrote:
The bgwriter parameters changed in
Did you increase the checkpoint segments and changed the default WAL lock
method to fdsync?
http://blogs.sun.com/jkshah/entry/postgresql_on_solaris_better_use
Try fdsync instead of fysnc as mentioned in the entry.
Regards,
Jignesh
Junaili Lie wrote:
Hi everyone,
We have a postgresql 8.1
Hi Jignesh,
Thank you for my reply.
I have the setting just like what you described:
wal_sync_method = fsyncwal_buffers = 128checkpoint_segments = 128bgwriter_all_percent = 0bgwriter_maxpages = 0
I ran the dtrace script and found the following:
During the i/o busy time, there are postgres
Hi everyone,
We have a postgresql 8.1 installed on Solaris 10. It is running fine.
However, for the past couple days, we have seen the i/o reports
indicating that the i/o is busy most of the time. Before this, we only
saw i/o being busy occasionally (very rare). So far, there has been no