RANDOMBLOGS (RSS)

depesz.com


6. 11. 2024System views added to pgdoc.link – depesz.com
5. 11. 2024Waiting for PostgreSQL 18 – Add SQL function array_reverse() – depesz.com
29. 10. 2024New way to search PostgreSQL documentation – depesz.com
28. 10. 2024Case study: optimization of weirdly picked bad plan – depesz.com
11. 10. 2024SQL/JSON is here! (kinda “Waiting for Pg 17”) – depesz.com
3. 10. 2024Waiting for PostgreSQL 18 – Add temporal FOREIGN KEY contraints – depesz.com
30. 9. 2024Waiting for PostgreSQL 18 – Add temporal PRIMARY KEY and UNIQUE constraints – depesz.com
19. 7. 2024What tables were touched within given range of wal LSN? – depesz.com
11. 6. 2024How much speed you’re leaving at the table if you use default locale? – depesz.com
22. 5. 2024Waiting for PostgreSQL 17 – MERGE / SPLIT partitions – depesz.com
12. 4. 2024Waiting for …: SQL/JSON is coming back. Hopefully. – depesz.com
11. 4. 2024Waiting for PostgreSQL 17 – Invent SERIALIZE option for EXPLAIN. – depesz.com
11. 4. 2024Waiting for PostgreSQL 17 – Add new COPY option LOG_VERBOSITY. – depesz.com
11. 4. 2024Waiting for PostgreSQL 17 – Add support for MERGE … WHEN NOT MATCHED BY SOURCE. – depesz.com
19. 3. 2024Waiting for PostgreSQL 17 – Add RETURNING support to MERGE. – depesz.com
18. 3. 2024What the hell is transaction wraparound? – depesz.com
7. 2. 2024Waiting for PostgreSQL 17 – Add new COPY option SAVE_ERROR_TO / Rename COPY option from SAVE_ERROR_TO to ON_ERROR – depesz.com
7. 2. 2024Waiting for PostgreSQL 17 – Support identity columns in partitioned tables – depesz.com
22. 1. 2024Waiting for PostgreSQL 17 – In plpgsql, allow %TYPE and %ROWTYPE to be followed by array decoration. – depesz.com
15. 1. 2024Waiting for PostgreSQL 17 – ALTER TABLE command to change generation expression – depesz.com
8. 1. 2024Waiting for PostgreSQL 17 – Add support for incremental backup. – depesz.com
29. 12. 2023Proper support for I/O Timings on explain.depesz.com – depesz.com
24. 10. 2023Human/version sort in PostgreSQL – revisited – depesz.com
24. 10. 2023Waiting for PostgreSQL 17 – Add support event triggers on authenticated login – depesz.com
7. 9. 2023Waiting for PostgreSQL 17 – Allow \watch queries to stop on minimum rows returned – depesz.com
1. 9. 2023Waiting for PostgreSQL 17 – Generate new LOG for “trust” connections under log_connections – depesz.com
1. 9. 2023Waiting for PostgreSQL 17 – Add to_bin() and to_oct(). – depesz.com
28. 7. 2023Human/version sort in PostgreSQL – depesz.com
18. 6. 2023Why is my WAL directory so large? – depesz.com
4. 6. 2023A tale about (incomplete) upgrade from PostgreSQL 12 to 14 – depesz.com
28. 5. 2023Variables in psql, how to use them? – depesz.com
18. 4. 2023Waiting for PostgreSQL 16 – Add array_sample() and array_shuffle() functions. – depesz.com
14. 3. 2023System roles – what, why, how? – depesz.com
27. 2. 2023Waiting for PostgreSQL 16 – Add pg_stat_io view, providing more detailed IO statistics – depesz.com
7. 2. 2023How to get a row, and all of it’s dependencies? – depesz.com
7. 2. 2023Now you can \d table not only in psql :) – depesz.com
6. 2. 2023When to use VACUUM FULL – depesz.com
6. 2. 2023Waiting for PostgreSQL 16 – Allow underscores in integer and numeric constants. – depesz.com
23. 1. 2023Can you use fzf for psql history? – depesz.com
11. 1. 2023Waiting for PostgreSQL 16 – Invent random_normal() to provide normally-distributed random numbers. – depesz.com
14. 12. 2022Waiting for PostgreSQL 16 – Non-decimal integer literals – depesz.com
14. 12. 2022Waiting for PostgreSQL 16 – Add grantable MAINTAIN privilege and pg_maintain role. – depesz.com
12. 12. 2022Waiting for PostgreSQL 16 – Add test scaffolding for soft error reporting from input functions. – depesz.com
30. 11. 2022Picking random element, with weights – depesz.com
22. 11. 2022Run a command every “x seconds” – depesz.com
3. 11. 2022Waiting for PostgreSQL 16 – Add support for regexps on database and user entries in pg_hba.conf – depesz.com
21. 9. 2022Prettify SQL queries from command line – depesz.com
18. 9. 2022What is LATERAL, what is it for, and how can one use it? – depesz.com
2. 9. 2022SQL/JSON is postponed – depesz.com
31. 8. 2022New SQL pretty printer – based on parsing, and not regexps – depesz.com
12. 7. 2022Better scrolling of long explain plans on explain.depesz.com – depesz.com
5. 7. 2022Understanding pg_stat_activity – depesz.com
4. 7. 2022How to log selects from specific table? – depesz.com
12. 4. 2022Stop the war in Ukraine – depesz.com
8. 4. 2022Waiting for PostgreSQL 15 – Documentation for SQL/JSON features – depesz.com
6. 4. 2022Waiting for PostgreSQL 15 – JSON_TABLE – depesz.com
5. 4. 2022DBA tips ‘n tricks – search in every field in a table – depesz.com
1. 4. 2022Waiting for PostgreSQL 15 – SQL/JSON query functions – depesz.com
1. 4. 2022Waiting for PostgreSQL 15 – IS JSON predicate – depesz.com
31. 3. 2022Waiting for PostgreSQL 15 – SQL/JSON constructors – depesz.com
31. 3. 2022Waiting for PostgreSQL 15 – Add support for MERGE SQL command – depesz.com
22. 3. 2022Waiting for PostgreSQL 15 – Add support for security invoker views. – depesz.com
16. 3. 2022PGDayPL postponed… – depesz.com
13. 3. 2022Is my autovacuum configured properly? – depesz.com
7. 3. 2022New type of hints on explain.depesz.com – depesz.com
1. 3. 2022How to index data with tsearch? – depesz.com
21. 2. 2022PGDayPL is coming :) – depesz.com
16. 2. 2022explain.depesz.com – now with HINTS! – depesz.com
13. 2. 2022How much disk space you can save by using INT4/INT instead of INT8/BIGINT? – depesz.com
6. 2. 2022Waiting for PostgreSQL 15 – Allow archiving via loadable modules. – depesz.com
6. 2. 2022Waiting for PostgreSQL 15 – Add UNIQUE null treatment option – depesz.com
28. 1. 2022Waiting for PostgreSQL 15 – Add HEADER support to COPY text format – depesz.com
17. 1. 2022Waiting for PostgreSQL 15 – Introduce log_destination=jsonlog – depesz.com
17. 1. 2022Configuration changes across Pg versions – depesz.com
26. 11. 2021Waiting for PostgreSQL 15 – Add assorted new regexp_xxx SQL functions. – depesz.com
19. 11. 2021Does varchar(n) use less disk space than varchar() or text? – depesz.com
16. 11. 2021Waiting for PostgreSQL 15 – Allow publishing the tables of schema. – depesz.com
22. 10. 2021Why is it hard to automatically suggest what index to create? – depesz.com
27. 9. 2021Using recursive queries to get distinct elements from table – depesz.com
10. 9. 2021Waiting for PostgreSQL 15 – Revoke PUBLIC CREATE from public schema, now owned by pg_database_owner. – depesz.com
26. 8. 2021How to get advisory lock in shell? – depesz.com
3. 8. 2021New changes on explain.depesz.com – fixed calculations of exclusive times – depesz.com
18. 7. 2021Display “settings” from plans on explain.depesz.com – depesz.com
15. 7. 2021How to get list of elements from multiranges? – depesz.com
4. 7. 2021Buffers I/O information on explain.depesz.com – depesz.com
23. 6. 2021A tale of making company-wide standard psqlrc – depesz.com
20. 6. 2021Explaining the unexplainable – part 6: buffers – depesz.com
9. 6. 2021Many changes on explain.depesz.com – depesz.com
18. 5. 2021Million explain plans… – depesz.com
21. 4. 2021Getting value from dynamic column in pl/PgSQL triggers? – depesz.com
14. 4. 2021Changes on explain.depesz.com – extracted query from auto-explain plans – depesz.com
1. 4. 2021Waiting for PostgreSQL 14 – Add unistr function – depesz.com
1. 4. 2021Waiting for PostgreSQL 14 – Add “pg_database_owner” default role. – depesz.com
31. 3. 2021Waiting for PostgreSQL 14 – Add date_bin function – depesz.com
22. 3. 2021Waiting for PostgreSQL 14 – Allow configurable LZ4 TOAST compression. – depesz.com
5. 3. 2021Starting with Pg – where are logs? – depesz.com
3. 3. 2021Fixed display of Backward scans on explain.depesz.com – depesz.com
1. 3. 2021Starting with Pg – where/how can I set configuration parameters? – depesz.com
19. 2. 2021explain.depesz.com – now with JITs – depesz.com
12. 2. 2021Starting with Pg – where is the config? – depesz.com
9. 2. 2021Why is there database named “postgres”? – depesz.com
4. 2. 2021Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses – depesz.com
28. 1. 2021How to run some tasks without user intervention, at specific times? – part 2 – depesz.com
18. 1. 2021Waiting for PostgreSQL 14 – Add pg_stat_database counters for sessions and session time – depesz.com
17. 1. 2021Are there limits to partition counts? – depesz.com
15. 1. 2021How to run some tasks without user intervention, at specific times? – depesz.com
12. 1. 2021Waiting for PostgreSQL 14 – Add idle_session_timeout. – depesz.com
12. 1. 2021Waiting for PostgreSQL 14 – Report progress of COPY commands – depesz.com
8. 1. 2021How to limit rows to at most N per category – fix – depesz.com
7. 1. 2021Fixes on why-upgrade.depesz.com – depesz.com
6. 1. 2021Reconnecting to SSH servers – depesz.com
29. 12. 2020How to install and configure PostgreSQL Debian/Ubuntu – for developer use – part 2 – depesz.com
24. 12. 2020How to install and configure PostgreSQL Debian/Ubuntu – for developer use – part 1 – depesz.com
21. 12. 2020Waiting for PostgreSQL 14 – Multirange datatypes – depesz.com
21. 12. 2020Waiting for PostgreSQL 14 – pg_stat_statements: Track time at which all statistics were last reset. – depesz.com
20. 12. 2020Waiting for PostgreSQL 14 – Allow subscripting of hstore values. – depesz.com
24. 11. 2020How to limit rows to at most N per category – depesz.com
19. 11. 2020Waiting for PostgreSQL 14 – Provide the OR REPLACE option for CREATE TRIGGER. – depesz.com
18. 11. 2020Waiting for PostgreSQL 14 – Support negative indexes in split_part(). – depesz.com
5. 11. 2020New functionality on explain.depesz.com – depesz.com
5. 10. 2020Waiting for PostgreSQL 14 – Support for OUT parameters in procedures – depesz.com
5. 10. 2020Waiting for PostgreSQL 13 – psql: Display stats target of extended statistics – depesz.com
22. 9. 2020Waiting for PostgreSQL 13 – Support FETCH FIRST WITH TIES – depesz.com
8. 9. 2020Waiting for PostgreSQL 14 – Add support for partitioned tables and indexes in REINDEX – depesz.com
25. 8. 2020Waiting for PostgreSQL 14 – Improvements for handling large number of connections – depesz.com
24. 8. 2020Waiting for PostgreSQL 14 – pg_stat_statements: track number of rows processed by some utility commands. – depesz.com
27. 7. 2020You can now add query to your plan on explain.depesz.com – depesz.com
27. 7. 2020Waiting for PostgreSQL 14 – Rename wal_keep_segments to wal_keep_size. – depesz.com
8. 6. 2020Changes on explain.depesz.com – depesz.com
17. 4. 2020Waiting for PostgreSQL 13 – Add logical replication support to replicate into partitioned tables – depesz.com
17. 4. 2020Waiting for PostgreSQL 13 – Allow autovacuum to log WAL usage statistics. – depesz.com
17. 4. 2020Waiting for PostgreSQL 13 – Add the option to report WAL usage in EXPLAIN and auto_explain. – depesz.com
3. 4. 2020Changes on explain.depesz.com – depesz.com
2. 4. 2020Waiting for PostgreSQL 13 – Allow pg_stat_statements to track planning statistics. – depesz.com
31. 3. 2020Waiting for PostgreSQL 13 – Enable BEFORE row-level triggers for partitioned tables – depesz.com
16. 3. 2020Initial support for fixing of line-wrapped plans – depesz.com
19. 2. 2020Why I’m not fan of uuid datatype – depesz.com
18. 2. 2020Fix for displaying aggregates on explain.depesz.com – depesz.com
18. 2. 2020Which tables should be auto vacuumed or auto analyzed – UPDATE – depesz.com
17. 2. 2020Waiting for PostgreSQL 13 – Add %x to default PROMPT1 and PROMPT2 in psql – depesz.com
17. 2. 2020Waiting for PostgreSQL 13 – Add leader_pid to pg_stat_activity – depesz.com
12. 2. 2020Shout out to heatonist.com – depesz.com
29. 1. 2020Which tables should be auto vacuumed or auto analyzed? – depesz.com
28. 1. 2020Don’t do these things in PostgreSQL – depesz.com
28. 1. 2020Waiting for PostgreSQL 13 – Add functions gcd() and lcm() for integer and numeric types. – depesz.com
27. 1. 2020Nothing compares …. – depesz.com
21. 1. 2020Waiting for PostgreSQL 13 – Allow vacuum command to process indexes in parallel. – depesz.com
14. 1. 2020Waiting for PostgreSQL 13 – ALTER TABLE … ALTER COLUMN … DROP EXPRESSION – depesz.com
7. 1. 2020Finally – fixed time calculations for parallel plans in explain.depesz.com – depesz.com
10. 12. 2019How to effectively dump PostgreSQL databases – depesz.com
3. 12. 2019Changes on explain.depesz.com – depesz.com
26. 11. 2019Waiting for PostgreSQL 13 – Allow invisible PROMPT2 in psql. – depesz.com
16. 11. 2019Waiting for PostgreSQL 13 – Introduce the ‘force’ option for the Drop Database command. – depesz.com
16. 11. 2019Waiting for PostgreSQL 13 – Allow sampling of statements depending on duration – depesz.com
13. 11. 2019More functions for json/yaml/xml plans on explain.depesz.com – depesz.com
12. 11. 2019New Pg::Explain and explain.depesz.com – depesz.com
28. 10. 2019Waiting for PostgreSQL 13 – pgbench: add –partitions and –partition-method options. – depesz.com
26. 9. 2019How to run short ALTER TABLE without long locking concurrent queries – depesz.com
17. 9. 2019Waiting for PostgreSQL 13 – Support for FF1-FF6 and SSSS datetime format patterns – depesz.com
31. 7. 2019Waiting for PostgreSQL 13 – Add support for –jobs in reindexdb – depesz.com
18. 6. 2019Changes on explain.depesz.com – depesz.com
18. 6. 2019New shell_util to watch output in multiple tmux panes at once – depesz.com
15. 5. 2019How to play with upcoming, unreleased, PostgreSQL? – depesz.com
13. 5. 2019Wait for program(s) in tmux panes to end… – depesz.com
1. 5. 2019Waiting for PostgreSQL 12 – Allow VACUUM to be run with index cleanup disabled. – depesz.com
30. 4. 2019Waiting for PostgreSQL 12 – Add SETTINGS option to EXPLAIN, to print modified settings. – depesz.com
24. 4. 2019Waiting for PostgreSQL 12 – Support foreign keys that reference partitioned tables – depesz.com
18. 4. 2019Waiting for PostgreSQL 12 – Log all statements from a sample of transactions – depesz.com
18. 4. 2019Waiting for PostgreSQL 12 – Report progress of CREATE INDEX operations – depesz.com
17. 4. 2019Waiting for PostgreSQL 12 – Generated columns – depesz.com
29. 3. 2019Waiting for PostgreSQL 12 – REINDEX CONCURRENTLY – depesz.com
19. 3. 2019Migrating simple table to partitioned. How? – depesz.com
19. 3. 2019Waiting for PostgreSQL 12 – Partial implementation of SQL/JSON path language – depesz.com
4. 3. 2019visual sleep in shell, and shell_utils repo information – depesz.com
25. 2. 2019Another change on why-upgrade.depesz.com – SEARCH! – depesz.com
19. 2. 2019why-upgrade updates – depesz.com
19. 2. 2019Waiting for PostgreSQL 12 – Allow user control of CTE materialization, and change the default behavior. – depesz.com
19. 2. 2019Grouping values in shell – depesz.com
4. 2. 2019Automation for doing stuff in multiple windows in tmux – depesz.com
4. 2. 2019Converting list of integers into list of ranges – depesz.com
3. 2. 2019Waiting for PostgreSQL 12 – Allow COPY FROM to filter data using WHERE conditions – depesz.com
5. 12. 2018Waiting for PostgreSQL 12 – Add log_statement_sample_rate parameter – depesz.com
28. 11. 2018Waiting for PostgreSQL 12 – Add CSV table output mode in psql. – depesz.com
27. 11. 2018Waiting for PostgreSQL 12 – Integrate recovery.conf into postgresql.conf – depesz.com
4. 11. 2018Foreign Key to partitioned table – part 3 – depesz.com
31. 10. 2018Foreign Key to partitioned table – part 2 – depesz.com
30. 10. 2018Waiting for PostgreSQL 12 – Add pg_partition_tree to display information about partitions – depesz.com
30. 10. 2018Waiting for PostgreSQL 12 – Add pg_promote function – depesz.com
2. 10. 2018Foreign Key to partitioned table – depesz.com
25. 9. 2018pg_terminator released – depesz.com
13. 8. 2018Waiting for PostgreSQL 12 – Allow multi-inserts during COPY into a partitioned table – depesz.com
2. 7. 2018I’m starting my wait for PostgreSQL 12 – depesz.com
25. 6. 2018Waiting for PostgreSQL 11 – Improve run-time partition pruning to handle any stable expression. – depesz.com
7. 6. 2018Projects migrated – depesz.com
1. 5. 2018Waiting for PostgreSQL 11 – Support partition pruning at execution time – depesz.com
@kaja47, 0xDEADBEEF funkcionálně.cz, k47.cz