High I/O writes activity on disks causing images on browser to lag and not load

From: Jennifer Trey <jennifer(dot)trey(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: High I/O writes activity on disks causing images on browser to lag and not load
Date: 2009-06-03 13:52:53
Message-ID: 863606ec0906030652h1f4acd7cxb4e002aeab1f0fcd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I have finally found out why I have had images that lag on the website. It
seems to be that postgre is doing allot of I/O activity and the images is
somehow suffering because of this.
The strange part about this is that it seems to be allot more disk writes
than disk reads. Even though 99.9% of my application traffic is DB read.
Looking up in tables and presenting.
Why is postgre doing all this writing? Should it not be I/O reads?
Is there something that I should know? Please enlighten me :)
I would now like to move the DB activity to another disk if possible? Would
I have to re-install PostgreSQL from scratch?
Thank you in advance / Jennifer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2009-06-03 13:55:41 Re: cursores
Previous Message Joshua Tolley 2009-06-03 13:47:38 Re: cursores