| From: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
|---|---|
| To: | Jennifer Trey <jennifer(dot)trey(at)gmail(dot)com>, Bill Moran <wmoran(at)potentialtech(dot)com> |
| Cc: | gryzman(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: High I/O writes activity on disks causing images on browser to lag and not load |
| Date: | 2009-06-04 11:07:20 |
| Message-ID: | 200906041107.n54B7cHB022184@vsmtp6.jaring.my |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
At 04:44 AM 6/4/2009, Jennifer Trey wrote:
>No, I created a new DB, created a table, and did not even populate any data.
>Running select count(*) from test
>
>just now, still caused the 10-20 I/O-writes.
Not sure if this is the main problem, but by default windows will
write to the disk whenever files are opened, this is to update the
last accessed timestamp.
This can be turned off:
http://technet.microsoft.com/en-us/library/cc959914.aspx
Apparently there are other ways of turning it off too. But I use the
registry method.
Of course you shouldn't turn it off if your apps or users require the
"last accessed timestamp".
Link.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoffrey | 2009-06-04 11:15:08 | Re: warm standby with WAL shipping |
| Previous Message | Jennifer Trey | 2009-06-04 10:48:28 | Re: High I/O writes activity on disks causing images on browser to lag and not load |