From: | Alex - <aintokyo(at)hotmail(dot)com> |
---|---|
To: | <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PL/Perl Performance Problems |
Date: | 2009-12-19 07:07:56 |
Message-ID: | SNT135-w8440982636EEBD75B8C1ACF840@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On a 2nd thought... where does the cach come into play when i only do inserts and no selects.
Alex
> Date: Fri, 18 Dec 2009 23:45:07 -0700
> Subject: Re: [GENERAL] PL/Perl Performance Problems
> From: scott(dot)marlowe(at)gmail(dot)com
> To: aintokyo(at)hotmail(dot)com
> CC: tgl(at)sss(dot)pgh(dot)pa(dot)us; pgsql-general(at)postgresql(dot)org
>
> On Fri, Dec 18, 2009 at 11:37 PM, Alex - <aintokyo(at)hotmail(dot)com> 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.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
_________________________________________________________________
Looking for a great date? Meet singles at ninemsn dating
http://clk.atdmt.com/NMN/go/150855801/direct/01/
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2009-12-19 07:10:30 | Re: pulling metadata creation strings from metadata tables? |
Previous Message | Alex - | 2009-12-19 07:02:31 | Re: PL/Perl Performance Problems |