Schema management

A database schema defines how the tables and indexes in your database are organized. Using a schema that is appropriate for your workload can result in significant performance improvements.

• Learn about schema management to understand how it works before you begin using it.
• Learn about indexing to understand how it works before you begin using it.
• Learn about tablespaces to understand how they work before you begin using them.
• Learn about constraints to understand how they work before you begin using them.
• Alter a hypertable to modify your schema.
• Create an index to speed up your queries.
• Create triggers to propogate your schema changes to chunks.
• Use JSON and JSONB for semi-structured data.