REFRESH MATERIALIZED VIEW Y N N REINDEX Y N N RELEASE Y N N RESET Y N N REVOKE Y Details DDL REVOKE ROLE Y Y DDL ROLLBACK Y N N ROLLBACK PREPARED Y N N SAVEPOINT Y N N SECURITY LABEL Y Details DDL SELECT INTO D
REFRESH MATERIALIZED VIEW Y N N REINDEX Y N N RELEASE Y N N RESET Y N N REVOKE Y Details DDL REVOKE ROLE Y Y DDL ROLLBACK Y N N ROLLBACK PREPARED Y N N SAVEPOINT Y N N SECURITY LABEL Y Details DDL SELECT INTO Details Y DDL SET Y N N SET CONSTRAINTS Y N N SHOW Y N N ...
CREATE MATERIALIZED VIEW conditions_summary_daily WITH (timescaledb.continuous) AS SELECT location, time_bucket(INTERVAL '1 day', time) AS bucket, AVG(temperature), MAX(temperature), MIN(temperature) FROM conditions GROUP BY location, bucket; Create a policy to refresh the view every hour: SELE...
Locking is used to order concurrent access to shared resources. By concurrent access, simultaneous access of several processes is meant. These processes themselves can run either in parallel (if the hardware permits) or sequentially in a time-sharing mode — it makes no difference. Without concurre...
> I've implemented a very large materialized view to speed up certain > search queries. I need to give users the ability to start a concurrent > refresh on demand, without waiting around an hour for it to complete, so > I've been looking at using the dblink extension. Specifically, giv...
Actions of autovacuum Operational commands (CHECKPOINT, ALTER SYSTEM) Actions related to Databases or Tablespaces Automatic DDL replication makes it easier to make certain DDL changes without having to manually distribute the DDL change to all nodes and ensure that they are consistent. ...