From: | "Mavinakuli, Prasanna (STSD)" <prasanna(dot)b-m(at)hp(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Cc: | "Mavinakuli, Prasanna (STSD)" <prasanna(dot)b-m(at)hp(dot)com> |
Subject: | HUGE Stack space is gettiing consumed |
Date: | 2006-04-14 03:43:26 |
Message-ID: | E84C4F56CA80174D8834825116CF247F026CFEA5@bgeexc05.asiapacific.cpqcorp.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello All,
We are getting very strange problem ..
Scenario..
********************************************************
We Have one data field in some table..type of this field
Is *TEXT*.
We are storing around 1,000 (One Thousand) lines of text
In that field.
If it's run though separate thread,
When we say select <columnname> from <tablename>
We are getting
*could not receive data from server: No such file or directory *
messages without Result
If it was in main thread,
It Works fine.
********************************************************
Our Analysis::
********************************************************
It looks like stack space issue.when we allocate stack space
Of 1.3 GB to new thread then we will get the Desired
Outpt I.e All 1,000 lines without any problem.
1)That String is barely 80 k ..there is no direct
Relationship with that size.
2)We can't allocate 1.3 GB,and we also don't have any
Recusrsive functions,
We would like to know is there any Recursive functions
In postgres -PQExec which might be eating all stack space..
Or what cud be the reason form libpq's point of view.
********************************************************
Please give u'r thougts,
Thanks in advance for U'r Suggetions..
Prasanna.
From | Date | Subject | |
---|---|---|---|
Next Message | chris smith | 2006-04-14 05:29:38 | Re: Regex with patterns in table field |
Previous Message | pgdb | 2006-04-14 03:02:52 | Re: Regex with patterns in table field |