From: Venki Ramachandran <venki_ramachandran@yahoo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Samuel Gendler <sgendler@ideasculptor.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Parallel Scaling of a pgplsql problem
Date: Wed, 25 Apr 2012 19:40:18 -0700 (PDT)
Message-ID: <1335408018.29771.YahooMailNeo@web184514.mail.ne1.yahoo.com> (raw)
In-Reply-To: <5452.1335390728@sss.pgh.pa.us>
References: <1335379923.47084.YahooMailNeo@web184514.mail.ne1.yahoo.com>
<CAEV0TzAVQXf42n9vXu26JAe0-eQ9AgwwAErYFn0HMm8ScQaodA@mail.gmail.com>
<1335388323.84458.YahooMailNeo@web184517.mail.ne1.yahoo.com>
<CAFj8pRB7gvUocfW5Uv5-NVFtRPSE97AS6Sbk5gzrdMweCpNS_Q@mail.gmail.com>
<1335390338.10325.YahooMailNeo@web184505.mail.ne1.yahoo.com>
<5452.1335390728@sss.pgh.pa.us>
Thanks Tom, clock_timestamp() worked. Appreciate it!!! and Sorry was hurrying to get this done at work and hence did not read through.
Can you comment on how you would solve the original problem? Even if I can get the 11 seconds down to 500 ms for one pair, running it for 300k pairs will take multiple hours. How can one write a combination of a bash script/pgplsql code so as to use all 8 cores of a server. I am seeing that this is just executing in one session/process.
thanks and regards, Venki
________________________________
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Venki Ramachandran <venki_ramachandran@yahoo.com>
Cc: Pavel Stehule <pavel.stehule@gmail.com>; Samuel Gendler <sgendler@ideasculptor.com>; "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Sent: Wednesday, April 25, 2012 2:52 PM
Subject: Re: [PERFORM] Parallel Scaling of a pgplsql problem
Venki Ramachandran <venki_ramachandran@yahoo.com> writes:
> Replacing current_timestamp() with transaction_timestamp() and statement_timestamp() did not help!!!.
You did not read the documentation you were pointed to. Use
clock_timestamp().
regards, tom lane
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-performance@postgresql.org
Cc: venki_ramachandran@yahoo.com, tgl@sss.pgh.pa.us, pavel.stehule@gmail.com, sgendler@ideasculptor.com
Subject: Re: Parallel Scaling of a pgplsql problem
In-Reply-To: <1335408018.29771.YahooMailNeo@web184514.mail.ne1.yahoo.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