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

Posted by Steel Plume on Stack Overflow See other posts from Stack Overflow or by Steel Plume
Published on 2010-03-17T00:48:15Z Indexed on 2010/03/17 0:51 UTC
Read the original article Hit count: 411

Filed under:
|

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 doubt 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?

© Stack Overflow or respective owner

Related posts about postgresql

Related posts about Performance