12 posts tagged with "databases"
restoring redshift spectrum to hot table storage
Creating Redshift Spectrum tables is a great way to…
redshift COPY commands can have identity columns
Recently I learned that COPY commandsd can have a…
redshift serverless is poorly documented and difficult to cost analyze
06/07/2023 10:08 | Category: databases
Tags: redshiftdbaserverlesscost_analysis
Cost analysis for determining…
redshift useful query metrics and logging internal tables
Redshift has quite a few internal tables…
aws redshift conditionally pausing clusters using Terraform with redshift one time scheduled actions
aws redshift conditionally pausing clusters using Terraform with redshift one time scheduled actions…
aws redshift dynamic sort keys
11/23/2022 15:09 | Category: databases
Tags: redshiftmaintenance
Previously when working on Redshift clusters tables needed to be…
aws redshift lock query types
11/23/2022 15:04 | Category: databases
Tags: redshiftlock_waits
Detecting and releasing locks in Redshift is an important thing to…
installing and enabling postgres extensions
09/29/2022 12:32 | Category: databases
Tags: postgresextensionsmaintenance
Working with Postgres extensions can be a little…
monitoring postgres autovacuum executions
09/29/2022 12:28 | Category: databases
Tags: postgresmaintenance
Recently when working with Postgres I had been tweaking…
aws redshift unloading aws console queries
When running queries in the AWS Redshift console often…
converting iso varchar dates to date types in postgres
06/15/2022 15:05 | Category: databases
Tags: postgresisotimestamps
Working with date conversions in SQL can be…
postgres table constraint definitions from pg_constraint
The constraints feature of Postgres table…