Re: [PERFORM] Parallel Scaling of a pgplsql problem

2012-04-25 Thread Venki Ramachandran
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 To: Venki Ramachandran Cc: Pavel

Re: [PERFORM] Parallel Scaling of a pgplsql problem

2012-04-25 Thread Venki Ramachandran
h will tell me where the 11 seconds is being spent. How do I do that? Thanks, Venki          ____ From: Pavel Stehule To: Venki Ramachandran Cc: Samuel Gendler ; "pgsql-performance@postgresql.org" Sent: Wednesday, April 25, 2012 2:26 PM Subject: Re:

Re: [PERFORM] Parallel Scaling of a pgplsql problem

2012-04-25 Thread Venki Ramachandran
mestamp value not changing. I was expecting the difference between the last row's timestamp value MINUS the first row's tiemstamp value to equal my 11.685 seconds. What is wrong here? -Venki From: Samuel Gendler To: Venki Ramachandran Cc: "pgsql-

[PERFORM] Parallel Scaling of a pgplsql problem

2012-04-25 Thread Venki Ramachandran
Hi all: Can someone please guide me as to how to solve this problem? If this is the wrong forum, please let me know which one to post this one in. I am new to Postgres (about 3 months into it) I have PostGres 9.0 database in a AWS server (x-large) and a pgplsql program that does some computatio