Skip site navigation (1) Skip section navigation (2)

Re: strange pauses

From: Adrian Moisey <adrian(at)careerjunction(dot)co(dot)za>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: strange pauses
Date: 2008-01-18 12:03:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

>>> If I tail the logs, I see a steady stream of functions that took 
>>> longer then 5 seconds.  But every now and then I see nothing for 3 
>>> minutes and after that a whole bunch (about 20 - 30) queries all 
>>> finishing at the same second.
>> Search this list for references to "checkpoints". If you run 
>> vmstat/iostat for a bit you should see bursts of disk activity at 
>> those times.
>> Counter-intuitively you probably want *more* checkpoints (with less 
>> data to write out each time), but see the list archives for 
>> discussion. Also check the manuals for some background info.
> We use a lot of checkpoints in our database, we don't care about these 

We use a lot of temporary tables in our database, sorry.

> much.  We think this is causing the checkpoint to write a lot of data at 
> checkpoint time.  Can we stop this behavior ?

Adrian Moisey
System Administrator | CareerJunction | Your Future Starts Here.
Web: | Email: adrian(at)careerjunction(dot)co(dot)za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

In response to


pgsql-performance by date

Next:From: Alvaro HerreraDate: 2008-01-18 12:41:21
Subject: Re: strange pauses
Previous:From: Adrian MoiseyDate: 2008-01-18 10:58:06
Subject: Re: strange pauses

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group