Hi,
PostgreSQL is not using threads but it is possible to spawn thread in your PostgreSQL extensions.
For example, I have used pool of threads in my IMCS extension.
But you need to build your extension with -pthread:
CUSTOM_COPT = -pthread
Also, please take in account that many PostgreSQL functions (even in/out or comparison functions) are not reentrant: them are storing their state in global variables.
So you will get race conditions if you are calling such functions from multiple threads.
Concerning stack overflow, I think that the most probable reason is trivial infinite recursion.
Did you inspect stack trace in debugger?
On 21.12.2015 09:21, sri harsha wrote:
Hi,
Is it possible to use threads in Postgresql ?? I am using threads in my foreign data wrapper and i get the following error when i use the threads .
ERROR: stack depth limit exceeded
HINT: Increase the configuration parameter "max_stack_depth" (currently 2048kB), after ensuring the platform's stack depth limit is adequate.
No matter how much i increase the stack size , the error keeps occurring . How do i solve this problem ??
Thanks,
Harsha