Vacuum - Revision history

Busk at 18:48, 5 August 2022

2022-08-05T18:48:59Z

Busk at 16:27, 5 August 2022

2022-08-05T16:27:57Z

Busk at 16:11, 5 August 2022

2022-08-05T16:11:19Z

Busk at 17:09, 3 August 2022

2022-08-03T17:09:37Z

Busk at 17:07, 3 August 2022

2022-08-03T17:07:53Z

Busk at 19:46, 23 June 2022

2022-06-23T19:46:56Z

Busk at 20:47, 19 April 2022

2022-04-19T20:47:44Z

Busk at 20:47, 19 April 2022

2022-04-19T20:47:02Z

Busk: Created page with "# Postgres Vacuum ``` $ docker run --rm -d --name postgres postgres:10.1 6732b0b9c6245fe9f19dd58e9737e5102089814e4aa96b66217af28a1596f786 $ docker exec -it postgres bash ro..."

2022-04-19T20:45:12Z

Created page with "# Postgres Vacuum ``` $ docker run --rm -d --name postgres postgres:10.1 6732b0b9c6245fe9f19dd58e9737e5102089814e4aa96b66217af28a1596f786 $ docker exec -it postgres bash ro..."

New page

# Postgres Vacuum

```
$ docker run --rm -d --name postgres postgres:10.1
6732b0b9c6245fe9f19dd58e9737e5102089814e4aa96b66217af28a1596f786

$ docker exec -it postgres bash

root@6732b0b9c624:/# psql -Upostgres
psql (10.1)
Type "help" for help.

postgres=# CREATE TABLE floor (
postgres(# name text,
postgres(# type text
postgres(# );
CREATE TABLE

postgres=# vacuum floor;
VACUUM

postgres=# SELECT relname, last_vacuum, last_autovacuum FROM pg_stat_user_tables;
relname | last_vacuum | last_autovacuum
---------+-------------------------------+-----------------
floor | 2019-04-24 17:52:26.044697+00 |
(1 row)
```

← Older revision		Revision as of 18:48, 5 August 2022
Line 2:		Line 2:

	SELECT name, setting FROM pg_settings WHERE name ILIKE '%autovacuum%';		SELECT name, setting FROM pg_settings WHERE name ILIKE '%autovacuum%';
		+
		+	SELECT name, setting FROM pg_settings where setting = '-1';
		+
		+	-1 uses settings from config

	https://andreigridnev.medium.com/db-maintenance-commands-in-postgresql-analyze-reindex-vacuum-4a14d75bee6c		https://andreigridnev.medium.com/db-maintenance-commands-in-postgresql-analyze-reindex-vacuum-4a14d75bee6c

← Older revision		Revision as of 16:27, 5 August 2022
Line 1:		Line 1:
	https://confluence.atlassian.com/kb/optimize-and-improve-postgresql-performance-with-vacuum-analyze-and-reindex-885239781.html		https://confluence.atlassian.com/kb/optimize-and-improve-postgresql-performance-with-vacuum-analyze-and-reindex-885239781.html
		+
		+	SELECT name, setting FROM pg_settings WHERE name ILIKE '%autovacuum%';

	https://andreigridnev.medium.com/db-maintenance-commands-in-postgresql-analyze-reindex-vacuum-4a14d75bee6c		https://andreigridnev.medium.com/db-maintenance-commands-in-postgresql-analyze-reindex-vacuum-4a14d75bee6c

← Older revision		Revision as of 16:11, 5 August 2022
Line 1:		Line 1:
		+	https://confluence.atlassian.com/kb/optimize-and-improve-postgresql-performance-with-vacuum-analyze-and-reindex-885239781.html
		+
	https://andreigridnev.medium.com/db-maintenance-commands-in-postgresql-analyze-reindex-vacuum-4a14d75bee6c		https://andreigridnev.medium.com/db-maintenance-commands-in-postgresql-analyze-reindex-vacuum-4a14d75bee6c

← Older revision		Revision as of 17:09, 3 August 2022
Line 1:		Line 1:
	https://andreigridnev.medium.com/db-maintenance-commands-in-postgresql-analyze-reindex-vacuum-4a14d75bee6c		https://andreigridnev.medium.com/db-maintenance-commands-in-postgresql-analyze-reindex-vacuum-4a14d75bee6c
		+
		+	```
		+	running VACUUM ANALYZE and then REINDEX commands on the biggest tables in the application database really helps to improve its performance.
		+	```

	psql mydb		psql mydb

← Older revision		Revision as of 17:07, 3 August 2022
Line 1:		Line 1:
		+	https://andreigridnev.medium.com/db-maintenance-commands-in-postgresql-analyze-reindex-vacuum-4a14d75bee6c
		+
	psql mydb		psql mydb
	```		```

@@ Line 1: / Line 1: @@
 SHOW AUTOVACUUM;
+```
 Show bloat

← Older revision		Revision as of 20:47, 19 April 2022
Line 1:		Line 1:
		+	SHOW AUTOVACUUM;
		+	'
	Show bloat		Show bloat