From: David G. Johnston <david.g.johns...@gmail.com> > This step seems to invalidate the idea outright. The checkpoint command is > superuser only and isn’t table specific. This seems to require both those > things to be changed.
Perhaps FlushRelationBuffers() followed by smgrsync() can be used instead. Or, depending on the assumed use case (e.g. the DBA adds data regularly for analytics), we may allow COPY UNLOGGED to be used only by superusers and some special pg_ roles, and COPY UNLOGGED performs checkpoints. Anyway, I kind of feel that COPY UNLOGGED needs some special privileges, because it renders the table unrecoverable and not being replicated to the standby. Regards Takayuki Tsunakawa
