#query
Want to quickly see how big a database is? You can do it in a single query:
Want to quickly see how big a database is? You can do it in a single query:
SELECT pg_size_pretty(pg_database_size('n2'));
select pg_size_pretty(pg_database_size('n2'));
pg_size_pretty
----------------
446 MB
(1 row)#index #performance #storage
CLUSTER: IMPROVING POSTGRESQL PERFORMANCE
https://www.cybertec-postgresql.com/en/cluster-improving-postgresql-performance/
CLUSTER: IMPROVING POSTGRESQL PERFORMANCE
https://www.cybertec-postgresql.com/en/cluster-improving-postgresql-performance/
#index #performance #vacuum https://www.cybertec-postgresql.com/en/postgresql-autovacuum-insert-only-tables/
CYBERTEC PostgreSQL | Services & Support
PostgreSQL v13 new feature: tuning autovacuum on insert-only tables
PostgreSQL v13 introduces autovacuum for insert-only tables. This article tells you why and how to make use of this new feature.
#vacuum #core https://www.cybertec-postgresql.com/en/autovacuum-wraparound-protection-in-postgresql/
CYBERTEC PostgreSQL | Services & Support
Autovacuum wraparound protection in PostgreSQL
Learn about one of the most misunderstood features in the PostgreSQL world: AUTOVACUUM and its “to prevent wraparound” notice.
#type
create type dimensions as (
width integer,
height integer,
depth integer
);
create table moving_boxes (
id serial primary key,
dims dimensions not null
);
insert into moving_boxes (dims) values (row(3,4,5)::dimensions);
#perf https://www.percona.com/blog/2020/05/29/removing-postgresql-bottlenecks-caused-by-high-traffic/
Percona Database Performance Blog
Removing PostgreSQL Bottlenecks Caused by High Traffic - Percona Database Performance Blog
Percona's Robert Bernier writes about removing PostgreSQL bottlenecks caused by high traffic.
#index https://info.crunchydata.com/blog/postgresql-brin-indexes-big-data-performance-with-minimal-storage
Crunchydata
PostgreSQL BRIN Indexes: Big Data Performance With Minimal Storage
A PostgreSQL block range index, or BRIN, can help you to significantly reduce the amount of disk space required for high performance queries on big data.
Forwarded from Sysadmin Tools 🇺🇦
Прислали в лс ништяков для postgresql
1) http://pgconfigurator.cybertec.at/
2) https://pgtune.leopard.in.ua/#/
3) https://github.com/jfcoz/postgresqltuner
1) http://pgconfigurator.cybertec.at/
2) https://pgtune.leopard.in.ua/#/
3) https://github.com/jfcoz/postgresqltuner
pgtune.leopard.in.ua
PGTune - calculate configuration for PostgreSQL based on the maximum performance for a given hardware configuration
PgTune - Tuning PostgreSQL config by your hardware