Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> 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 externally with a script / program that uses multiple
connections might just be the way. Unfortunately that means that you
don't get a single consistent snapshot - each connection will have its
own, potentially different, view of the database state.
A possible use for read only transactions being able to share a snapshot
came up in discussion a few weeks ago. I guess this is another one.
--
Craig Ringer
I fill tables with observation data, so the tables don't change except the
one for current day. So I don't need to care about different states
of database.
From what has been posted I think that C function can do the work for me.
But I would still appreciate some peace of code from which I can figure
out how this can be done, because I'm new to database programing.
Thank you
Lukas Houf
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
