Available now! Telegram Research 2025 — the year's key insights 
PostgreSQL DBA
Open in Telegram
2 015
Subscribers
-124 hours
+17 days
-930 days
Data loading in progress...
Similar Channels
Tags Cloud
Incoming and Outgoing Mentions
---
---
---
---
---
---
Attracting Subscribers
June '26
June '26
+13
in 0 channels
May '26
+14
in 0 channels
Get PRO
April '26
+17
in 0 channels
Get PRO
March '26
+14
in 0 channels
Get PRO
February '26
+15
in 0 channels
Get PRO
January '26
+23
in 0 channels
Get PRO
December '25
+17
in 0 channels
Get PRO
November '25
+37
in 0 channels
Get PRO
October '25
+34
in 0 channels
Get PRO
September '25
+27
in 0 channels
Get PRO
August '25
+38
in 0 channels
Get PRO
July '25
+31
in 0 channels
Get PRO
June '25
+26
in 0 channels
Get PRO
May '25
+34
in 0 channels
Get PRO
April '25
+34
in 0 channels
Get PRO
March '25
+42
in 0 channels
Get PRO
February '25
+40
in 0 channels
Get PRO
January '25
+46
in 0 channels
Get PRO
December '24
+60
in 0 channels
Get PRO
November '24
+74
in 0 channels
Get PRO
October '24
+60
in 0 channels
Get PRO
September '24
+82
in 0 channels
Get PRO
August '24
+1 752
in 0 channels
| Date | Subscriber Growth | Mentions | Channels | |
| 26 June | 0 | |||
| 25 June | 0 | |||
| 24 June | +3 | |||
| 23 June | 0 | |||
| 22 June | 0 | |||
| 21 June | 0 | |||
| 20 June | 0 | |||
| 19 June | +1 | |||
| 18 June | 0 | |||
| 17 June | 0 | |||
| 16 June | +1 | |||
| 15 June | 0 | |||
| 14 June | 0 | |||
| 13 June | 0 | |||
| 12 June | 0 | |||
| 11 June | +2 | |||
| 10 June | 0 | |||
| 09 June | +1 | |||
| 08 June | +1 | |||
| 07 June | 0 | |||
| 06 June | 0 | |||
| 05 June | 0 | |||
| 04 June | 0 | |||
| 03 June | +1 | |||
| 02 June | +1 | |||
| 01 June | +2 |
Channel Posts
| 2 |  No text... | 374 |
| 3 |  No text... | 360 |
| 4 |  Configuration Parameters | 341 |
| 5 | CREATE TABLE orders (
order_id SERIAL PRIMARY KEY,
customer_id INTEGER,
order_date DATE,
order_total NUMERIC
) PARTITION BY RANGE (order_date);
CREATE TABLE orders_y2023 PARTITION OF orders
FOR VALUES FROM ('2023-01-01') TO ('2024-01-01');
CREATE TABLE orders_y2024 PARTITION OF orders
FOR VALUES FROM ('2024-01-01') TO ('2025-01-01');
-- Add an index to each partition
CREATE INDEX idx_orders_y2023_customer_id ON orders_y2023 (customer_id);
CREATE INDEX idx_orders_y2024_customer_id ON orders_y2024 (customer_id); | 270 |
| 6 |  No text... | 218 |
| 7 |  No text... | 222 |
| 8 |  No text... | 192 |
| 9 |  Beyond indexing, several query optimization techniques can significantly improve performance. | 169 |
| 10 | Unused Indexes: Identify and remove unused indexes to reduce write overhead. The pg_stat_all_indexes view provides information about index usage. | 167 |
| 11 | Index Bloat: As data is inserted, updated, and deleted, indexes can become fragmented and bloated, leading to performance degradation. Rebuild indexes periodically using the REINDEX command. | 161 |
| 12 | Statistics: PostgreSQL relies on statistics to estimate the cost of different query plans. Inaccurate statistics can lead to suboptimal plan choices. Regularly update statistics using the ANALYZE command. | 166 |
| 13 | Partial indexes index only a subset of the table's rows, based on a condition. This can reduce index size and improve performance when queries frequently filter on that condition. | 172 |
| 14 | Composite indexes index multiple columns. The order of columns in a composite index is important. The most frequently used column in WHERE clauses should come first. | 170 |
| 15 |  No text... | 166 |
| 16 | Indexes are crucial for improving query performance, but they also add overhead to write operations. Choosing the right indexes and maintaining them properly is essential. | 176 |
| 17 | Filtering: Where clauses that filter the data. If a filter is being applied after a large amount of data has already been processed, this is a sign the query could be optimized. | 171 |
| 18 | Rows: The estimated number of rows returned by each operation. Significant discrepancies between estimated and actual rows (observed with EXPLAIN ANALYZE) can indicate inaccurate statistics, leading the planner to choose a suboptimal plan. | 158 |
| 19 | Cost: The estimated cost of each operation. The planner uses a cost model to estimate the resources required to perform each operation. Higher costs usually indicate potential bottlenecks. | 146 |
| 20 |  No text... | 149 |
