diff options
author | Galen Guyer <galen@galenguyer.com> | 2022-07-23 19:36:39 -0400 |
---|---|---|
committer | Galen Guyer <galen@galenguyer.com> | 2022-07-23 19:36:39 -0400 |
commit | 80f0f3b7d98d2b5ee3c6d845050874345b81422e (patch) | |
tree | cfc305f7653638b68676082533af5804ae3cd63f | |
parent | 896b340c5b987a95e73bde6d811dcc0c9de251ea (diff) |
add pg_prewarm extension
-rw-r--r-- | migrations/2022-04-09-create-schema.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/migrations/2022-04-09-create-schema.sql b/migrations/2022-04-09-create-schema.sql index 830ad4a..c616e74 100644 --- a/migrations/2022-04-09-create-schema.sql +++ b/migrations/2022-04-09-create-schema.sql @@ -1,4 +1,6 @@ -CREATE extension IF NOT EXISTS "uuid-ossp"; +CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; +CREATE EXTENSION IF NOT EXISTS "pg_prewarm"; +ALTER SYSTEM SET shared_preload_libraries = 'pg_prewarm'; CREATE TABLE IF NOT EXISTS users ( id uuid PRIMARY KEY DEFAULT uuid_generate_v4(), |