Re: Threads in PostgreSQL

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