Postgresql performance question about inserting or updating many row containing binary data

Question

Hello, I have a table A where I put many image resources with a daily frequence.

Every record of table A references another table B in which there are only fixed records.

My question is the following: better to clean all records in A and then inserting new images or updating only the binary column of all records.

What your advice?

Answer 1

Advice: Do some tests and see what works best for your situation.

I would start with updates and see if I could do HOT updates. You may have to play with the FILLFACTOR to get it working. It works great for me.