Roberts Jon <[EMAIL PROTECTED]> wrote:
> >
> > Hi all,
> >
> > I was trying to find some way to implement multithreading into my
> > postgreSQL stored functions.
> >
>
> You can use pgAgent to submit a job for each thread.
>
>
> Jon
Well, that is also an interesting idea. I will definet
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
> Sent: Sunday, March 30, 2008 10:13 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] postgreSQL multithreading
>
> Hi all,
>
> I was trying to find some wa
Craig Ringer <[EMAIL PROTECTED]> wrote:
Past discussion here suggests that the backends are strictly single
threaded. While you might be able to use multiple threads - I don't know
- I expect you'd need to protect all SPI access by a lock that
serialized everything anyway.
Doing it external
A. Kretschmer <[EMAIL PROTECTED]> wrote:
> Maybe a solution.
>
> Please, learn to quote.
Sorry for the quoting. I guess this probably won't be OK too :-)
Strange thing about this is that there is no simple way to use
more CPUs for one function. It can be done with external functions
but why
am Sun, dem 30.03.2008, um 18:18:45 +0200 mailte [EMAIL PROTECTED] folgendes:
> What about some C dynamically loaded function in which I could call new
> connection for each thread?
Maybe a solution.
Please, learn to quote.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1:
[EMAIL PROTECTED] wrote:
What about some C dynamically loaded function in which I could call new
connection for each thread?
Past discussion here suggests that the backends are strictly single
threaded. While you might be able to use multiple threads - I don't know
- I expect you'd need to
> Původní zpráva
> Od: Andreas Kretschmer <[EMAIL PROTECTED]>
> Předmět: Re: [GENERAL] postgreSQL multithreading
> Datum: 30.3.2008 17:39:02
>
> [EMAIL PROTECTED] <[EMAIL PROTECTED]> schrieb:
>
&g
[EMAIL PROTECTED] <[EMAIL PROTECTED]> schrieb:
> Hi all,
>
> I was trying to find some way to implement multithreading into my postgreSQL
> stored functions.
>
> The thing is, that I have data stored in multiple tables - for each day one
> table - and I want to write
> a function which selects
