Question : I want to understand why migrating data in a table with all VARCHAR(50) fields to a table with […]
Tag: datatypes
What value should I choose as length for timestamp without timezone in PostgreSQL?
Question : I’m currently setting up a database to populate it with big data. All the data I get comes […]
INT(5) vs SMALLINT(5): numbers in parenthesis after the numeric type
Question : In MySQL table definitions is there a different between INT(5) and SMALLINT(5)? Or do they both represent the […]
CASE expression returns wrong value when using CEILING
Question : I’ve run into an issue where a CASE expression does not return what I expect. As a test, […]
PostgreSQL ignores index, runs seq scan
Question : My table contains an index for column total_balance: d balances_snapshots Table “public.balances_snapshots” Column | Type | Collation | […]
Creating blog fresh tables from old tables [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
How to change the datatype of column without deleting it indexes; [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Do fixed-width rows improve PostgreSQL read performance?
Question : I have a table articles: Table “articles” Column | Type | Modifiers | Storage | Stats target | […]
PostgreSQL custom operator UUID to varchar
Question : I have a rather complicated Postgres database in which many UUID fields were incorrect stored as VARCHAR. I’d […]
Performance implications of MySQL VARCHAR sizes
Question : Is there a performance difference in MySQL between varchar sizes? For example, varchar(25) and varchar(64000). If not, is […]