Primary section10 problemsCoding
PostgreSQL
Remote connections, concurrency, slow queries, locks, migrations, and sequences.
Databaseintermediate
PostgreSQL works locally but refuses remote connection
PostgreSQL
DetailsAsk Puvexa
Databaseintermediate
PostgreSQL duplicate key appears during concurrent inserts
PostgreSQL
DetailsAsk Puvexa
Databaseintermediate
PostgreSQL database uses much more disk space than expected
PostgreSQL
DetailsAsk Puvexa
Databaseintermediate
PostgreSQL index exists but query planner does not use it
PostgreSQL
DetailsAsk Puvexa
Databaseintermediate
PostgreSQL transaction remains idle and blocks other queries
PostgreSQL
DetailsAsk Puvexa
Databaseintermediate
PostgreSQL sequence generates duplicate ID after data import
PostgreSQL
DetailsAsk Puvexa
Databaseintermediate
PostgreSQL timezone values differ between application and database
PostgreSQL
DetailsAsk Puvexa