Postgres

Postgres Timezone Conversions

#Postgres #Warehouse

Pitfals of timezone conversion in Postgres

Postgres Optimization in JOIN

#Postgres #Warehouse

Join tables together starting with the smallest table (table with less cardinality) speeds things …

Deal with NULL in Postgres

#Data Warehouse #Postgres #PGSQL

Please deal with null carefully.