TimeScale Training - Revision history

Ian.readman at 17:02, 20 April 2025

2025-04-20T17:02:33Z

← Older revision		Revision as of 17:02, 20 April 2025
Line 195:		Line 195:
	<pre>		<pre>
	CALL refresh_continuous_aggregate('daily_cpu_stats', '2023-01-01', '2025-04-01');		CALL refresh_continuous_aggregate('daily_cpu_stats', '2023-01-01', '2025-04-01');
	CALL refresh_continuous_aggregate('daily_cpu_stats', 'month', now())', date_trunc('day', now()));		CALL refresh_continuous_aggregate('daily_cpu_stats', date_trunc('month', now())', date_trunc('day', now()));
	</pre>		</pre>

2025-04-20T17:02:03Z

← Older revision		Revision as of 17:02, 20 April 2025
Line 195:		Line 195:
	<pre>		<pre>
	CALL refresh_continuous_aggregate('daily_cpu_stats', '2023-01-01', '2025-04-01');		CALL refresh_continuous_aggregate('daily_cpu_stats', '2023-01-01', '2025-04-01');
			CALL refresh_continuous_aggregate('daily_cpu_stats', 'month', now())', date_trunc('day', now()));
	</pre>		</pre>

2025-04-20T16:57:00Z

← Older revision		Revision as of 16:57, 20 April 2025
Line 198:		Line 198:

	=== Add Policy ===		=== Add Policy ===
			Create a policy that refreshes data between 1 month old and 1 day. This occurs every hour. </br>
			This means data older than 1 month will never be removed from the CA, even if it is deleted from the underlying table.
	<pre>		<pre>
	SELECT add_continuous_aggregate_policy('daily_cpu_stats',		SELECT add_continuous_aggregate_policy('daily_cpu_stats',

2025-04-20T16:55:35Z

@@ Line 177: / Line 177: @@
 == Continuous Aggregates ==
 The materialised view will be created immediately unless you use the option <b>WITH NO DATA</b>
@@ Line 188: / Line 189: @@
 FROM metrics
 GROUP BY day, device_id;
 </pre>

2025-04-20T16:45:54Z

← Older revision		Revision as of 16:45, 20 April 2025
Line 177:		Line 177:

	== Continuous Aggregates ==		== Continuous Aggregates ==
			The materialised view will be created immediately unless you use the option <b>WITH NO DATA</b>

	<pre>		<pre>
	CREATE MATERIALIZED VIEW daily_cpu_stats		CREATE MATERIALIZED VIEW daily_cpu_stats

2025-04-20T16:43:59Z

@@ Line 174: / Line 174: @@
 <pre>
 SELECT name, setting, short_desc FROM pg_settings WHERE name like 'timescaledb.%';
 </pre>

2025-04-17T17:08:59Z

← Older revision		Revision as of 17:08, 17 April 2025
Line 8:		Line 8:
	sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/timescaledb.gpg		sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/timescaledb.gpg
	sudo apt update		sudo apt update

			# Get latest version
	sudo apt install timescaledb-2-postgresql-17		sudo apt install timescaledb-2-postgresql-17
			# Get specific version
	sudo apt-get install timescaledb-2-postgresql-15='2.14.2' timescaledb-2-loader-postgresql-15='2.14.2'		sudo apt-get install timescaledb-2-postgresql-15='2.14.2' timescaledb-2-loader-postgresql-15='2.14.2'
	</pre>		</pre>

2025-04-17T17:07:54Z

← Older revision		Revision as of 17:07, 17 April 2025
Line 3:		Line 3:
	=== Debian ===		=== Debian ===
	<pre>		<pre>
	echo "deb https://packagecloud.io/timescale/timescaledb/debian/ $(lsb_release -c -s) main" \| sudo tee /etc/apt/sources.list.d/timescaledb.list		echo "deb https://packagecloud.io/timescale/timescaledb/debian/ $(lsb_release -c -s) main" \| /
	wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey \| sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/timescaledb.gpg		sudo tee /etc/apt/sources.list.d/timescaledb.list
			wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey \| /
			sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/timescaledb.gpg
	sudo apt update		sudo apt update
	sudo apt install timescaledb-2-postgresql-17		sudo apt install timescaledb-2-postgresql-17

2025-04-17T13:33:19Z

← Older revision		Revision as of 13:33, 17 April 2025
Line 61:		Line 61:

	=== Chunk Interval ===		=== Chunk Interval ===
			The default chunk interval is 7 days.
	<pre>		<pre>
	SELECT create_hypertable('metrics', by_range('time', INTERVAL '1 month'));		SELECT create_hypertable('metrics', by_range('time', INTERVAL '1 month'));

2025-04-17T12:20:54Z

← Older revision		Revision as of 12:20, 17 April 2025
Line 28:		Line 28:
	<pre>		<pre>
	SET search_path = "$user", public, "timescaledb_information";		SET search_path = "$user", public, "timescaledb_information";
	SET timezone TO 'Europe/~~Berlin~~';		SET timezone TO 'Europe/London';

	\dv timescaledb_information.*		\dv timescaledb_information.*