On Mon, Feb 18, 2013 at 10:33:26PM +0530, Atri Sharma wrote:
> >> While your threads are executing, your query can't be cancelled --
> >> only a hard kill will take the database down. If you're ok with that
> >> risk, then go for it. If you're not, then I'd thinking about
> >> sendinging the bytea through a protocol to a threaded processing
> >> server running outside of the database. More work and slower
> >> (protocol overhead), but much more robust.
> >
> > You can see the approach of not calling any PG-specific routines from
> > theads here:
> >
> > http://wiki.postgresql.org/wiki/Parallel_Query_Execution#Approaches
> >
>
>
> Is there any way to locally synchronise the threads in my code,and
> send the requests to the PostgreSQL backend one at a time? Like a waiting
> queue in my code?
Is this from the client code? That is easy from libpq using
asynchronous queries.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +