From: samantha mahindrakar <sam.mahindrakar@gmail.com>
To: Vishal Arora <aroravishal22@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Jobs using pgagent
Date: Wed, 16 Jul 2008 10:33:53 -0400
Message-ID: <f0c828c40807160733k7efeb58dk60cc75c5d3dff52@mail.gmail.com> (raw)
In-Reply-To: <BLU110-W231D0D1D163B08D36F5905A98F0@phx.gbl>
References: <f0c828c40807151054m23da67ecm9ff3ea818bd59fc1@mail.gmail.com>
<BLU110-W231D0D1D163B08D36F5905A98F0@phx.gbl>
I think the log file would be too big to post since the program runs for
hours............however you are right...i did some analysis and found that
the program runs slwo when another loader is running. If the loader has run
for 2-3 hours.......the pro
gram has run extremely slow at that time....and hence taken longer to
complete.
However the loader acts in the main table and the program works on the
partitions of the main table.
Iam not sure what is the exact problem here. Could throw me some insight on
the internal working of potsgres?
Sam
On 7/15/08, Vishal Arora <aroravishal22@hotmail.com> wrote:
>
> Hi,
>
> Can you show your event log file?
> There might be that at different point of time the load on DB is different
> so it takes some time more than what is expected.
>
> -Vishal
>
>
> ------------------------------
>
> Date: Tue, 15 Jul 2008 13:54:00 -0400
> From: sam.mahindrakar@gmail.com
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Jobs using pgagent
>
>
> Hi....
> Iam using postgres since recently.....there are jobs scheduled using the
> pgagent. There are loaders and stuff that are scheduled using the pgagent.
> There is a new job that i have added............the weird part is that it
> runs for different amounts of time everyday. For example: it has run for
> 3hours,5 hours on some days and for 16hours on some days. It processing
> equally amounts of data on each of these days.
> When i look at the log file............the RAISE NOTICE statements are not
> continous .........i.e. statements of other DB processes are printed and
> then the statements of the program are printed............seems like its
> running on and off. As far my knowledge goes pgagent can handle parallel
> jobs.
> Though i see locks made by the program............iam not sure if thats the
> problem. Can someone give me a pointer on this?
>
> Thanks
> Sam
>
> ------------------------------
> Check news, cricket, entertainment and astrology right from your mobile.
> Browse http://m.msnindia.com from your GPRS mobile phone. Try it now!<http://m.msnindia.com/;
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sam.mahindrakar@gmail.com, aroravishal22@hotmail.com
Subject: Re: Jobs using pgagent
In-Reply-To: <f0c828c40807160733k7efeb58dk60cc75c5d3dff52@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox