One more newbie question. Due to limitations of both pg and php I gave up on the attempts to make bigint keys work; I have a choice between 16-byte character strings or "8-byte" bytea (decode(string_from_above, "hex")) for an index column for a table.
Which one will be faster for exact matches and joins? Tables will be big, there will be no range queries and no partial matching. Again I cannot test it because I lack production data, I wonder if it's common knowledge? ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
