|
I have the standard ones and no others. # run-parts 01 * * * * root run-parts /etc/cron.hourly 02 4 * * * root run-parts /etc/cron.daily 22 4 * * 0 root run-parts /etc/cron.weekly 42 4 1 * * root run-parts /etc/cron.monthly ls -l /etc/cron* -rw-r--r-- 1 root root 0 Apr 6 2009 /etc/cron.deny -rw-r--r-- 1 root root 255 Jan 6 2007 /etc/crontab /etc/cron.d: -rw-r--r-- 1 root root 192 Mar 12 2009 sysstat /etc/cron.daily: -rwxr-xr-x 1 root root 379 Mar 28 2007 0anacron lrwxrwxrwx 1 root root 39 Apr 6 2009 0logwatch -> /usr/share/logwatch/scripts/logwatch.pl -rwxr-xr-x 1 root root 118 Jan 21 2009 cups -rwxr-xr-x 1 root root 180 Mar 12 2009 logrotate -rwxr-xr-x 1 root root 418 Jan 6 2007 makewhatis.cron -rwxr-xr-x 1 root root 137 Mar 12 2009 mlocate.cron -rwxr-xr-x 1 root root 2181 Jun 21 2006 prelink -rwxr-xr-x 1 root root 296 Jan 21 2009 rpm -rwxr-xr-x 1 root root 328 Feb 26 2009 tmpwatch /etc/cron.hourly: -rwxr-xr-x 1 root root 71 Jan 10 2007 mcelog.cron /etc/cron.monthly: -rwxr-xr-x 1 root root 381 Mar 28 2007 0anacron /etc/cron.weekly: -rwxr-xr-x 1 root root 380 Mar 28 2007 0anacron -rwxr-xr-x 1 root root 414 Jan 6 2007 makewhatis.cron > Date: Fri, 18 Dec 2009 23:45:07 -0700 > Subject: Re: PL/Perl Performance Problems > From: scott.marlowe@xxxxxxxxx > To: aintokyo@xxxxxxxxxxx > CC: tgl@xxxxxxxxxxxxx; pgsql-general@xxxxxxxxxxxxxx > > On Fri, Dec 18, 2009 at 11:37 PM, Alex - <aintokyo@xxxxxxxxxxx> wrote: > > Hmm... > > how can that be. This is happening every day, so its not a one off or > > happens once in the morning then in the afternoon. There is also no other > > task running on the system, its dedicated to postgres. > > Could the Autovacuum cause problems? Starting to invoke Analyze at the > > beginning of the day but the keep silent till the day timestamp breaks ? > > The think is that I have 4 servers setup in a similar way and all have > > exactly the same problem. > > What cron jobs are on that machine that run at night? Note that on > many OSes, maintenance crons are scheduled in a dir something like > /etc/cron.daily etc... On my laptop they all run at midnight. I'm > wondering if they're blowing out your cache so that you just don't > have the same performance the first time you hit a particular dataset > after they've run. Just a guess. You could try disabling them for a > day and see what happens. Check out Domain Radar NOW! A world FIRST in property search has arrived! |
