bytea – Tarik Billa

What is the datatype bytea and when would I use it?

April 9, 2023 by Tarik

I think the documentation is reasonably clear on the differences between bytea and text: Binary strings are distinguished from character strings in two ways. First, binary strings specifically allow storing octets of value zero and other “non-printable” octets (usually, octets outside the range 32 to 126). Character strings disallow zero octets, and also disallow any … Read more

Are there performance issues storing files in PostgreSQL?

March 5, 2023 by Tarik

You have basically two choices. You can store the data right in the row or you can use the large object facility. Since PostgreSQL now uses something called TOAST to move large fields out of the table there should be no performance penalty associated with storing large data in the row directly. There remains a … Read more