Menu
I am working with the AWS Aurora PostgreSQL 10.4 engine. I am trying to cluster table ... using index and getting an error like
could not write block .... of temporary file: no space left on device
If I were managing my own PostgreSQL instance I would be looking at the space available on individual volumes with df. (See also: I get an error "could not write block .... of temporary file no space left on device ..." using postgresql)
But with Aurora, AWS should be managing the storage and automatically expanding it on demand. So I'm wondering how I would go about fixing this condition if I'm not managing the storage myself. I'm guessing that that the PG engine's temp storage is separate from the Aurora-managed virtualized storage layer, but not sure how to change it.
579
What are the minimum and maximum storage limits of an Amazon Aurora database? The minimum storage is 10 GB. Based on your database usage, your Amazon Aurora storage will automatically grow, up to 128 TiB, in 10 GB increments with no impact to database performance. There is no need to provision storage in advance.
For Aurora MySQL, the maximum table size is 64 tebibytes (TiB). For an Aurora PostgreSQL DB cluster, the maximum table size is 32 tebibytes (TiB). We recommend that you follow table design best practices, such as partitioning of large tables. The maximum table space ID for Aurora MySQL is 2147483647.
Overview of Aurora storage Aurora data is stored in the cluster volume, which is a single, virtual volume that uses solid state drives (SSDs). A cluster volume consists of copies of the data across three Availability Zones in a single AWS Region.
View the VolumeBytesUsed in the RDS consoleChoose Databases from the navigation pane, and then choose the name of the DB instance that you want to monitor. Choose the Monitoring tab. From the CloudWatch section, enter [Billed] Volume Bytes Used, or choose it from the list. The storage use appears on the graph.
Temp space uses the local “ephemeral” volume on the instance. Currently the only way to increase that space is to move to a larger instance size.
191
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
