HUGE Stack space is gettiing consumed

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.

Responses

Browse pgsql-general by date

  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