Commit Graph

1 Commits

Author SHA1 Message Date
Groovie | Mango bab25959f6
postgres schema fixes after moving to self-operated PostgreSQL (#57)
* remove indices from migration.sql which here never created

* BREAKING: make transaction_id the primary key in transactions lookup table

* use varchar in postgres.rs

* add "NOT NULL" constraint wherever possible

* fix small accounts lookup table naming

* fly app for migration

see https://github.com/blockworks-foundation/BankingStageErrorsTrackingSidecar/issues/56

* autovacuum settings

* databse init script

* explain query_user role

* tune toast_tuple_target and comment on page size

* minor fixes

* dba queries

* jot down the fly machine config

* restore create schema

* tweak storage param for postgres 15
2024-02-24 18:29:52 +01:00