| From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Queries sometimes take 1000 times the normal time |
| Date: | 2003-08-28 09:10:03 |
| Message-ID: | 3F4E1443.7646.12E864@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 28 Aug 2003 at 10:02, Russell Garrett wrote:
> The web site queries will jump up one or two orders of magnitude (I have
> seen a normally 100ms query take in excess of 30 seconds) in duration at
> seemingly random points. It's not always when the transactions are
> committing, and it doesn't seem to be during checkpointing either. The same
> thing happens with WAL switched off. It appears to happen the first time the
> query runs after a while. If I run the same query immediately afterwards, it
> will take the normal amount of time.
Looks like it got flushed out of every type of cache and IO scheduler could not
deliver immediately because of other loads...
Bye
Shridhar
--
Abstainer, n.: A weak person who yields to the temptation of denying himself a
pleasure. -- Ambrose Bierce, "The Devil's Dictionary"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-08-28 09:19:21 | Re: The results of my PostgreSQL/filesystem performance |
| Previous Message | Russell Garrett | 2003-08-28 09:02:46 | Re: Queries sometimes take 1000 times the normal time |