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 <[email protected]> To: Venki Ramachandran <[email protected]> Cc: Pavel Stehule <[email protected]>; Samuel Gendler <[email protected]>; "[email protected]" <[email protected]> Sent: Wednesday, April 25, 2012 2:52 PM Subject: Re: [PERFORM] Parallel Scaling of a pgplsql problem Venki Ramachandran <[email protected]> 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
