KaiGai Kohei <kaigai@kaigai.gr.jp> wrote:
> Can SELECT lo_create(16385); help this situation?
SELECT lo_create(loid) FROM (SELECT DISTINCT loid FROM pg_largeobject) AS t
would work for pg_migrator.
> I'm not clear whether we also check pg_largeobejct has chunks with same
> LOID on lo_create(). In the regular operation, it shall never happen.
I think the omission is a reasonable optimization.
Regards,
---
Takahiro Itagaki
NTT Open Source Software Center