Search Postgresql Archives

Re: PL/Perl Performance Problems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux