Ilya Kosmodemiansky
|
57a140018f
|
check identity
|
1 year ago |
melkij
|
7d8552b127
|
added global report for Postgresql 16 (symlink)
|
2 years ago |
Valeria Kaplan
|
c14b025bb7
|
Update LICENSE.md
added spaces
|
3 years ago |
|
Valeria Kaplan
|
7b7e62042a
|
Update LICENSE.md
|
3 years ago |
|
Valeria Kaplan
|
f9c575e076
|
Update LICENSE.md
|
3 years ago |
Maxim Boguk
|
7950d96cfe
|
added global report for Postgresql 15
|
3 years ago |
Alexey Ermakov
|
8a612bd826
|
index_candidates_to_deduplicate: don't skip indexes without MCV statistics
|
3 years ago |
|
melkij
|
38f6eced67
|
check only valid indexes
calling bt_metap during loading tuples in tree will corrupt this index: https://www.postgresql.org/message-id/flat/17568-ef121b956ec1559c%40postgresql.org
|
3 years ago |
|
Alexey Ermakov
|
33e02f698a
|
indexing_progress.sql: add additional columns, improve readability; index_candidates_to_deduplicate: fix columns order for multicolumn indexes estimates
|
3 years ago |
|
Alexey Ermakov
|
f7d9d90dfa
|
table_bloat_approx.sql: add table mask prompt, combine table and schema names. index_candidates_to_partial.sql: fix typo
|
3 years ago |
Victor Yegorov
|
b116f7e1aa
|
Replication and progress scripts.
User-friendly output from the:
- pg_stat_replication
- pg_stat_progress_vacuum
- pg_stat_progress_create_index
|
4 years ago |
|
Alexey Ermakov
|
2465cfab78
|
fix index_candidates_to_deduplicate (allow index names with uppercase letters)
|
4 years ago |
|
Alexey Ermakov
|
f630d80e42
|
add reindex_non_btree_indexes.sql
|
4 years ago |
|
Alexey Ermakov
|
ed7f42cc5d
|
Add index_candidates_to_deduplicate.sql query to list indexes which could benefit from "btree index deduplication" feature in pg 13+
|
4 years ago |
|
Maxim Boguk
|
1b6c20cd10
|
create version specific symlinks for query_stat_total_*.sql
|
4 years ago |
Nina Belyavskaya
|
7ec1f2d0dd
|
index_watch -> pg_index_watch (external)
|
4 years ago |
PostgreSQL program user
|
8e5dbc8cf3
|
file name fix
|
4 years ago |
|
PostgreSQL program user
|
b312b40430
|
added check script for pk on all tables (required for logical replication)
|
4 years ago |
|
Nina Belyavskaya
|
fa66a12eba
|
100MB -> 10MB in comment
|
4 years ago |
|
Nina Belyavskaya
|
90d88801ad
|
Merge branch 'master' of https://github.com/dataegret/pg-utils
|
4 years ago |
|
Nina Belyavskaya
|
7c7ed0d4fd
|
100MB -> 10MB in comment
|
4 years ago |
|
Alexey Ermakov
|
6eb13513bc
|
add vacuum_truncate_speedup script
|
4 years ago |
Nina Belyavskaya
|
52e20c165e
|
version 0.9
|
4 years ago |
|
Nina Belyavskaya
|
b58b21bea9
|
Merge branch 'master' of https://github.com/dataegret/pg-utils
|
4 years ago |
|
Nina Belyavskaya
|
aebc1492d1
|
Merge branch 'master' of https://github.com/dataegret/pg-utils
check the uniqueness of the launch
|
4 years ago |
|
Nina Belyavskaya
|
b955af2c02
|
check the uniqueness of the launch
|
4 years ago |
|
Nina Belyavskaya
|
df5fc036e0
|
check the uniqueness of the launch
|
4 years ago |
Maxim Boguk
|
51aedf99ee
|
change minimal index size from 100MB to 10MB
|
4 years ago |
|
Nina Belyavskaya
|
02e9f1b7aa
|
work with non-default port
|
4 years ago |
|
Alexey Ermakov
|
23f084539c
|
table_bloat/index_bloat improvements: add prompt in psql for mask, combine schema and table name in one column, add limit for index_bloat query.
|
4 years ago |
|
Maxim Boguk
|
47b32709f3
|
bump version on 0.7
|
4 years ago |
|
Maxim Boguk
|
e950e711d0
|
fix division by zero and bump function version on 0.7
|
4 years ago |
Nikitin-Alexandr
|
32aece7f84
|
Create temp.txt
|
5 years ago |
|
Nikitin-Alexandr
|
79db36c3bf
|
Delete temp.txt
|
5 years ago |
|
Nikitin-Alexandr
|
151c24f8ff
|
Rename create_db_activity_view9.6.sql to create_db_activity_view.sql
rename from view9.6.sql to view.sql
|
5 years ago |
|
Nikitin-Alexandr
|
38d4f0ab09
|
Rename sql/create_db_activity_view_old.sql to sql/old/create_db_activity_view_old.sql
mv file to "old"
|
5 years ago |
|
Nikitin-Alexandr
|
aee429eaad
|
Rename create_db_activity_view.sql to create_db_activity_view_old.sql
rename file to *_old.sql
|
5 years ago |
|
Nikitin-Alexandr
|
dd12258614
|
Create temp.txt
Create directory "slony"
|
5 years ago |
|
Nikitin-Alexandr
|
ccbdbdeb40
|
Delete temp.txt
|
5 years ago |
|
Nikitin-Alexandr
|
00788f8d72
|
Rename sql/table_disk_activity.sql to sql/old/table_disk_activity.sql
move old file to "old" directory
|
5 years ago |
|
Nikitin-Alexandr
|
e135505fa3
|
Create temp.txt
|
5 years ago |
|
Maxim Boguk
|
e6dc31c9b7
|
add check to skip exculsion constraint indexes to prevent error: concurrent index creation for exclusion constraints is not supported
|
5 years ago |
Maxim Boguk
|
b0f3ed45fe
|
script set restructurization
|
5 years ago |
Maxim Boguk
|
63e8c0af83
|
add database ordering during work
|
5 years ago |
|
Maxim Boguk
|
58fd879702
|
fix config comment
|
5 years ago |
|
Maxim Boguk
|
dfdc83f253
|
single file split into rarely changed data(tables) structure and stateless code(procedures) structure files
|
5 years ago |
|
Maxim Boguk
|
920c603241
|
change default value of minimum_reliable_index_size
|
5 years ago |
|
Maxim Boguk
|
fc3377cc64
|
removed debug RAISE NOTICE
|
5 years ago |
|
Maxim Boguk
|
0ace45e395
|
change bloat scale factor from 1.5 to 2
|
5 years ago |
|
Maxim Boguk
|
3c32db2d24
|
small fix
|
5 years ago |
