On Tue, Jul 2, 2013 at 12:16:18PM +0900, Tatsuo Ishii wrote: > Now that we have COPY FREEZE, I'm thinking about adding similar option > to creating large objects. In 9.3 the maximum size of large objects > are increased. That means, the first access to a large object will > trigger more writes because of hint bit updation. Also subsequent > VACUUM may trigger that as well. If we could freeze arge objects while > creating, it could reduce the writes dramatically as COPY FREEZE > already does.
I was not aware that large objects had to feeze each 8k segment. Do they? -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers