On Sat, May 21, 2016 at 1:01 PM, Andreas Karlsson <andr...@proxel.se> wrote: > Another question which I thought of is what we should do with functions like > pg_file_write() in adminpack. > > While it is perfectly fine to modify files from the parallel workers, a user > could get race conditions if he tries to modify the same file multiple > times. Is this a kind of problem the PARALLEL tagging should try to prevent, > or is that something we should leave to the user?
Advertising
I think there's little value in marking such things parallel-safe, even though by some definition they may be. Parallelizing queries involving pg_file_write() is not really a useful thing to do. What we really want to do is nail the functions that people might be likely to use as scan quals, plus any generally useful aggregates. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
