I'm setting up a Postgres database that will function as a storage place for data records. There's a column in the records that I'm going to be inserting that contains different kinds of data types; floats, integers, and strings. Due to the variety of data types that this column needs to hold, I have set the type of that column to
VARCHAR(50), but I fear that this is not very efficient.
Question: As this column will need to hold a lot of values in the future I'm looking for the best way to deal with the different types. What is the best type setting or way of storing these records performance-wise?