2007–2026
1,125 posts
2026 25
October 2026
August 2026
July 2026
- Waiting for PostgreSQL 19 – SQL Property Graph Queries (SQL/PGQ)
- Waiting for PostgreSQL 20 – Add min() and max() aggregate support for uuid.
- Waiting for PostgreSQL 20 – Add backend-level lock statistics
June 2026
April 2026
- Polish configuration for TSearch
- Waiting for PostgreSQL 19 – Add CONCURRENTLY option to REPACK
- Waiting for PostgreSQL 19 – Online enabling and disabling of data checksums
- Waiting for PostgreSQL 19 – new pg_get_*_ddl() functions
- Waiting for PostgreSQL 19 – Add UPDATE/DELETE FOR PORTION OF
March 2026
- Waiting for PostgreSQL 19 – json format for COPY TO
- Waiting for PostgreSQL 19 – Add support for EXCEPT TABLE in ALTER PUBLICATION.
- Waiting for PostgreSQL 19 – Add pg_plan_advice contrib module.
- Waiting for PostgreSQL 19 – Introduce the REPACK command
- Waiting for PostgreSQL 19 – Allow table exclusions in publications via EXCEPT TABLE.
- Waiting for PostgreSQL 19 – Add non-text output formats to pg_dumpall
February 2026
- Waiting for PostgreSQL 19 – Allow log_min_messages to be set per process type
- Waiting for PostgreSQL 19 – psql: Add %i prompt escape to indicate hot standby status.
- Per-worker, and global, IO bandwidth in explain plans
January 2026
2025 28
November 2025
- Using JSON: json vs. jsonb, pglz vs. lz4, key optimization, parsing speed?
- Waiting for PostgreSQL 19 – Sequence synchronization in logical replication.
- Do you really need tsvector column?
October 2025
- Waiting for PostgreSQL 19 – Add psql PROMPT variable for search_path.
- Waiting for PostgreSQL 19 – Support COPY TO for partitioned tables.
- Waiting for PostgreSQL 19 – Add IGNORE NULLS/RESPECT NULLS option to Window functions.
- Waiting for PostgreSQL 19 – Add GROUP BY ALL.
- vtime – time commands with elapsed time visible all the time
September 2025
August 2025
- Who logged to system from multiple countries in 2 hours?
- Waiting for PostgreSQL 19 – Display Memoize planner estimates in EXPLAIN
May 2025
- pg_dump speed across versions
- Waiting for PostgreSQL 18 – Add function to get memory context stats for processes
- Waiting for PostgreSQL 18 – Allow NOT NULL constraints to be added as NOT VALID
April 2025
- Waiting for PostgreSQL 18 – Add modern SHA-2 based password hashes to pgcrypto.
- Waiting for PostgreSQL 18 – Non text modes for pg_dumpall, correspondingly change pg_restore
March 2025
- Waiting for PostgreSQL 18 – Allow json{b}_strip_nulls to remove null array elements
- Waiting for PostgreSQL 18 – Allow parallel CREATE INDEX for GIN indexes
February 2025
- Waiting for PostgreSQL 18 – Allow EXPLAIN to indicate fractional rows.
- Waiting for PostgreSQL 18 – Virtual generated columns
- Waiting for PostgreSQL 18 – Add delay time to VACUUM/ANALYZE (VERBOSE) and autovacuum logs.
- Waiting for PostgreSQL 18 – Add cost-based vacuum delay time to progress views.
- Waiting for PostgreSQL 18 – Support RN (roman-numeral format) in to_number().
January 2025
- Waiting for PostgreSQL 18 – Add OLD/NEW support to RETURNING in DML queries.
- Waiting for PostgreSQL 18 – Allow changing autovacuum_max_workers without restarting.
- Waiting for PostgreSQL 18 – Enable BUFFERS with EXPLAIN ANALYZE by default
- Waiting for PostgreSQL 18 – Support LIKE with nondeterministic collations
- Waiting for PostgreSQL 18 – psql: Add more information about service name
2024 27
December 2024
- Waiting for PostgreSQL 18 – Add UUID version 7 generation function.
- How to ALTER tables without breaking application?
- SQL best practices – don’t compare count(*) with 0
November 2024
- How can I send mail or HTTP request from database?
- Changes on pgdoc.link
- Grouping data into array of sums – fun with custom aggregates
- System views added to pgdoc.link
- Waiting for PostgreSQL 18 – Add SQL function array_reverse()
October 2024
- New way to search PostgreSQL documentation
- Case study: optimization of weirdly picked bad plan
- SQL/JSON is here! (kinda “Waiting for Pg 17”)
- Waiting for PostgreSQL 18 – Add temporal FOREIGN KEY contraints
September 2024
July 2024
June 2024
May 2024
April 2024
- Waiting for …: SQL/JSON is coming back. Hopefully.
- Waiting for PostgreSQL 17 – Invent SERIALIZE option for EXPLAIN.
- Waiting for PostgreSQL 17 – Add new COPY option LOG_VERBOSITY.
- Waiting for PostgreSQL 17 – Add support for MERGE … WHEN NOT MATCHED BY SOURCE.
March 2024
February 2024
- Waiting for PostgreSQL 17 – Add new COPY option SAVE_ERROR_TO / Rename COPY option from SAVE_ERROR_TO to ON_ERROR
- Waiting for PostgreSQL 17 – Support identity columns in partitioned tables
January 2024
2023 19
December 2023
October 2023
- Human/version sort in PostgreSQL – revisited
- Waiting for PostgreSQL 17 – Add support event triggers on authenticated login
September 2023
- Waiting for PostgreSQL 17 – Allow \watch queries to stop on minimum rows returned
- Waiting for PostgreSQL 17 – Generate new LOG for “trust” connections under log_connections
- Waiting for PostgreSQL 17 – Add to_bin() and to_oct().
July 2023
June 2023
May 2023
April 2023
March 2023
February 2023
- Waiting for PostgreSQL 16 – Add pg_stat_io view, providing more detailed IO statistics
- How to get a row, and all of it’s dependencies?
- Now you can \d table not only in psql :)
- When to use VACUUM FULL
- Waiting for PostgreSQL 16 – Allow underscores in integer and numeric constants.
January 2023
2022 34
December 2022
- Waiting for PostgreSQL 16 – Non-decimal integer literals
- Waiting for PostgreSQL 16 – Add grantable MAINTAIN privilege and pg_maintain role.
- Waiting for PostgreSQL 16 – Add test scaffolding for soft error reporting from input functions.
November 2022
- Picking random element, with weights
- Run a command every “x seconds”
- Waiting for PostgreSQL 16 – Add support for regexps on database and user entries in pg_hba.conf
September 2022
- Prettify SQL queries from command line
- What is LATERAL, what is it for, and how can one use it?
- SQL/JSON is postponed
August 2022
July 2022
- Better scrolling of long explain plans on explain.depesz.com
- Understanding pg_stat_activity
- How to log selects from specific table?
April 2022
- Stop the war in Ukraine
- Waiting for PostgreSQL 15 – Documentation for SQL/JSON features
- Waiting for PostgreSQL 15 – JSON_TABLE
- DBA tips ‘n tricks – search in every field in a table
- Waiting for PostgreSQL 15 – SQL/JSON query functions
- Waiting for PostgreSQL 15 – IS JSON predicate
March 2022
- Waiting for PostgreSQL 15 – SQL/JSON constructors
- Waiting for PostgreSQL 15 – Add support for MERGE SQL command
- Waiting for PostgreSQL 15 – Add support for security invoker views.
- PGDayPL postponed…
- Is my autovacuum configured properly?
- New type of hints on explain.depesz.com
- How to index data with tsearch?
February 2022
- PGDayPL is coming :)
- explain.depesz.com – now with HINTS!
- How much disk space you can save by using INT4/INT instead of INT8/BIGINT?
- Waiting for PostgreSQL 15 – Allow archiving via loadable modules.
- Waiting for PostgreSQL 15 – Add UNIQUE null treatment option
January 2022
2021 37
November 2021
- Waiting for PostgreSQL 15 – Add assorted new regexp_xxx SQL functions.
- Does varchar(n) use less disk space than varchar() or text?
- Waiting for PostgreSQL 15 – Allow publishing the tables of schema.
October 2021
September 2021
- Using recursive queries to get distinct elements from table
- Waiting for PostgreSQL 15 – Revoke PUBLIC CREATE from public schema, now owned by pg_database_owner.
August 2021
- How to get advisory lock in shell?
- New changes on explain.depesz.com – fixed calculations of exclusive times
July 2021
- Display “settings” from plans on explain.depesz.com
- How to get list of elements from multiranges?
- Buffers I/O information on explain.depesz.com
June 2021
- A tale of making company-wide standard psqlrc
- Explaining the unexplainable – part 6: buffers
- Many changes on explain.depesz.com
May 2021
April 2021
- Getting value from dynamic column in pl/PgSQL triggers?
- Changes on explain.depesz.com – extracted query from auto-explain plans
- Waiting for PostgreSQL 14 – Add unistr function
- Waiting for PostgreSQL 14 – Add “pg_database_owner” default role.
March 2021
- Waiting for PostgreSQL 14 – Add date_bin function
- Waiting for PostgreSQL 14 – Allow configurable LZ4 TOAST compression.
- Starting with Pg – where are logs?
- Fixed display of Backward scans on explain.depesz.com
- Starting with Pg – where/how can I set configuration parameters?
February 2021
- explain.depesz.com – now with JITs
- Starting with Pg – where is the config?
- Why is there database named “postgres”?
- Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses
January 2021
- How to run some tasks without user intervention, at specific times? – part 2
- Waiting for PostgreSQL 14 – Add pg_stat_database counters for sessions and session time
- Are there limits to partition counts?
- How to run some tasks without user intervention, at specific times?
- Waiting for PostgreSQL 14 – Add idle_session_timeout.
- Waiting for PostgreSQL 14 – Report progress of COPY commands
- How to limit rows to at most N per category – fix
- Fixes on why-upgrade.depesz.com
- Reconnecting to SSH servers
2020 38
December 2020
- How to install and configure PostgreSQL Debian/Ubuntu – for developer use – part 2
- How to install and configure PostgreSQL Debian/Ubuntu – for developer use – part 1
- Waiting for PostgreSQL 14 – Multirange datatypes
- Waiting for PostgreSQL 14 – pg_stat_statements: Track time at which all statistics were last reset.
- Waiting for PostgreSQL 14 – Allow subscripting of hstore values.
November 2020
- How to limit rows to at most N per category
- Waiting for PostgreSQL 14 – Provide the OR REPLACE option for CREATE TRIGGER.
- Waiting for PostgreSQL 14 – Support negative indexes in split_part().
- New functionality on explain.depesz.com
October 2020
- Waiting for PostgreSQL 14 – Support for OUT parameters in procedures
- Waiting for PostgreSQL 13 – psql: Display stats target of extended statistics
September 2020
- Waiting for PostgreSQL 13 – Support FETCH FIRST WITH TIES
- Waiting for PostgreSQL 14 – Add support for partitioned tables and indexes in REINDEX
August 2020
- Waiting for PostgreSQL 14 – Improvements for handling large number of connections
- Waiting for PostgreSQL 14 – pg_stat_statements: track number of rows processed by some utility commands.
July 2020
- You can now add query to your plan on explain.depesz.com
- Waiting for PostgreSQL 14 – Rename wal_keep_segments to wal_keep_size.
June 2020
April 2020
- Waiting for PostgreSQL 13 – Add logical replication support to replicate into partitioned tables
- Waiting for PostgreSQL 13 – Allow autovacuum to log WAL usage statistics.
- Waiting for PostgreSQL 13 – Add the option to report WAL usage in EXPLAIN and auto_explain.
- Changes on explain.depesz.com
- Waiting for PostgreSQL 13 – Allow pg_stat_statements to track planning statistics.
March 2020
- Waiting for PostgreSQL 13 – Enable BEFORE row-level triggers for partitioned tables
- Initial support for fixing of line-wrapped plans
February 2020
- Why I’m not fan of uuid datatype
- Fix for displaying aggregates on explain.depesz.com
- Which tables should be auto vacuumed or auto analyzed – UPDATE
- Waiting for PostgreSQL 13 – Add %x to default PROMPT1 and PROMPT2 in psql
- Waiting for PostgreSQL 13 – Add leader_pid to pg_stat_activity
- Shout out to heatonist.com
January 2020
- Which tables should be auto vacuumed or auto analyzed?
- Don’t do these things in PostgreSQL
- Waiting for PostgreSQL 13 – Add functions gcd() and lcm() for integer and numeric types.
- Nothing compares ….
- Waiting for PostgreSQL 13 – Allow vacuum command to process indexes in parallel.
- Waiting for PostgreSQL 13 – ALTER TABLE … ALTER COLUMN … DROP EXPRESSION
- Finally – fixed time calculations for parallel plans in explain.depesz.com
2019 32
December 2019
November 2019
- Waiting for PostgreSQL 13 – Allow invisible PROMPT2 in psql.
- Waiting for PostgreSQL 13 – Introduce the ‘force’ option for the Drop Database command.
- Waiting for PostgreSQL 13 – Allow sampling of statements depending on duration
- More functions for json/yaml/xml plans on explain.depesz.com
- New Pg::Explain and explain.depesz.com
October 2019
September 2019
- How to run short ALTER TABLE without long locking concurrent queries
- Waiting for PostgreSQL 13 – Support for FF1-FF6 and SSSS datetime format patterns
July 2019
June 2019
May 2019
- How to play with upcoming, unreleased, PostgreSQL?
- Wait for program(s) in tmux panes to end…
- Waiting for PostgreSQL 12 – Allow VACUUM to be run with index cleanup disabled.
April 2019
- Waiting for PostgreSQL 12 – Add SETTINGS option to EXPLAIN, to print modified settings.
- Waiting for PostgreSQL 12 – Support foreign keys that reference partitioned tables
- Waiting for PostgreSQL 12 – Log all statements from a sample of transactions
- Waiting for PostgreSQL 12 – Report progress of CREATE INDEX operations
- Waiting for PostgreSQL 12 – Generated columns
March 2019
- Waiting for PostgreSQL 12 – REINDEX CONCURRENTLY
- Migrating simple table to partitioned. How?
- Waiting for PostgreSQL 12 – Partial implementation of SQL/JSON path language
- visual sleep in shell, and shell_utils repo information
February 2019
- Another change on why-upgrade.depesz.com – SEARCH!
- why-upgrade updates
- Waiting for PostgreSQL 12 – Allow user control of CTE materialization, and change the default behavior.
- Grouping values in shell
- Automation for doing stuff in multiple windows in tmux
- Converting list of integers into list of ranges
- Waiting for PostgreSQL 12 – Allow COPY FROM to filter data using WHERE conditions
2018 27
December 2018
November 2018
- Waiting for PostgreSQL 12 – Add CSV table output mode in psql.
- Waiting for PostgreSQL 12 – Integrate recovery.conf into postgresql.conf
- Foreign Key to partitioned table – part 3
October 2018
- Foreign Key to partitioned table – part 2
- Waiting for PostgreSQL 12 – Add pg_partition_tree to display information about partitions
- Waiting for PostgreSQL 12 – Add pg_promote function
- Foreign Key to partitioned table
September 2018
August 2018
July 2018
June 2018
- Waiting for PostgreSQL 11 – Improve run-time partition pruning to handle any stable expression.
- Projects migrated
May 2018
April 2018
- Waiting for PostgreSQL 11 – Indexes with INCLUDE columns and their support in B-tree
- Waiting for PostgreSQL 11 – Add json(b)_to_tsvector function
- Waiting for PostgreSQL 11 – Transforms for jsonb to PL/Python and to PL/Perl
- paste.depesz.com is back (for good?)
- Waiting for PostgreSQL 11 – MERGE SQL Command following SQL:2016
- Waiting for PostgreSQL 11 – Fast ALTER TABLE ADD COLUMN with a non-NULL default
March 2018
February 2018
- What is the benefit of upgrading PostgreSQL?
- Which schema is using the most disk space?
- Waiting for PostgreSQL 11 – Support all SQL:2011 options for window frame clauses.
- Waiting for PostgreSQL 11 – Support parallel btree index builds.
- Fix for parallel scans on explain.depesz.com
January 2018
2017 25
November 2017
September 2017
- Waiting for PostgreSQL 11 – Add psql variables to track success/failure of SQL queries.
- Waiting for PostgreSQL 11 – Add \gdesc psql command.
August 2017
July 2017
June 2017
- explain.depesz.com, paste.depesz.com – TOR announcement and some updates
- Waiting for PostgreSQL 10 – Implement syntax for transition tables in AFTER triggers.
May 2017
- New change on explain.depesz.com
- Waiting for PostgreSQL 10 – Implement multivariate n-distinct coefficients
April 2017
- Waiting for PostgreSQL 10 – Support SCRAM-SHA-256 authentication (RFC 5802 and 7677).
- Waiting for PostgreSQL 10 – Identity columns
- Waiting for PostgreSQL 10 – Full Text Search support for json and jsonb
- Waiting for PostgreSQL 10 – Support \if … \elif … \else … \endif in psql scripting.
- Waiting for PostgreSQL 10 – Logical replication support for initial data copy
March 2017
- Waiting for PostgreSQL 10 – hash indexing vs. WAL
- Waiting for PostgreSQL 10 – Support XMLTABLE query expression
- Waiting for PostgreSQL 10 – psql: Add \gx command
February 2017
- A way to share SQL queries – paste.depesz.com
- Getting first and last values per group
- Why does “sudo ls -l /proc/1/fd/*” fail?
- Waiting for PostgreSQL 10 – Logical replication
- Waiting for PostgreSQL 10 – Add pg_sequence system catalog
- Generate short, random, textual IDs
- Waiting for PostgreSQL 10 – Implement table partitioning.
2016 28
November 2016
October 2016
- Waiting for PostgreSQL 10 – postgres_fdw: Push down aggregates to remote servers.
- Waiting for PostgreSQL 10 – Rename “pg_xlog” directory to “pg_wal”.
September 2016
July 2016
June 2016
May 2016
April 2016
- Waiting for 9.6 – Support \crosstabview in psql
- Waiting for 9.6 – Phrase full text search.
- Waiting for 9.6 – Add a \gexec command to psql for evaluation of computed queries.
- Waiting for 9.6 – Bloom index contrib module
- Change on explain.depesz.com
March 2016
- Waiting for 9.6 – Support parallel aggregation.
- Waiting for 9.6 – Directly modify foreign tables.
- Waiting for 9.6 – Add idle_in_transaction_session_timeout.
- Waiting for 9.6 – Add simple VACUUM progress reporting.
- Waiting for 9.6 – Tsvector editing functions
- Waiting for 9.6 – Add a generic command progress reporting facility.
February 2016
- Waiting for 9.6 – Add new system view, pg_config
- Waiting for 9.6 – Remove GROUP BY columns that are functionally dependent on other columns.
- explain.depesz.com – new change and some stats
- Waiting for 9.6 – Add num_nulls() and num_nonnulls() to count NULL arguments.
- Waiting for 9.6 – Add trigonometric functions that work in degrees.
- Waiting for 9.6 – Support parallel joins, and make related improvements.
January 2016
2015 47
December 2015
- Waiting for 9.6 – Allow EXPLAIN (ANALYZE, VERBOSE) to display per-worker statistics.
- Waiting for 9.6 – psql: Support multiple -c and -f options, and allow mixing them.
- Grouping data by timestamp and interval
November 2015
- Waiting for 9.6 – Generate parallel sequential scan plans in simple cases.
- Waiting for 9.6 – Implement lookbehind constraints in our regular-expression engine.
October 2015
- Is C faster for (instagram-style) ID generation?
- explain.depesz.com changes and new stats
- Waiting for 9.6 – Add CASCADE support for CREATE EXTENSION.
- Converting Logical Volume so that it’s striped
September 2015
- Waiting for 9.6 – Allow per-tablespace effective_io_concurrency
- Waiting for 9.6 – Add log_line_prefix option ‘n’ for Unix epoch.
- Waiting for 9.6 – Allow usage of huge maintenance_work_mem for GIN build.
- Hypothetical indexes
August 2015
- Waiting for 9.6 – Add IF NOT EXISTS processing to ALTER TABLE ADD COLUMN
- Waiting for 9.6 – Add new function pg_notification_queue_usage.
- Waiting for 9.6 – Add psql PROMPT variable showing the pid of the connected to backend.
July 2015
June 2015
- Partitioning – what? why? how?
- Filling in the blanks
- Waiting for 9.5 – Rename jsonb_replace to jsonb_set and allow it to add new values
- New functionality on explain.depesz.com, and some statistics
May 2015
- Waiting for 9.5 – Support GROUPING SETS, CUBE and ROLLUP.
- Waiting for 9.5 – TABLESAMPLE, SQL Standard and extensible
- Waiting for 9.5 – Add pg_audit, an auditing extension
- Waiting for 9.5 – Add pg_settings.pending_restart column
- Waiting for 9.5 – Additional functions and operators for jsonb
- Waiting for 9.5 – Add system view pg_stat_ssl
- How to setup SSL connections and authentication?
- Waiting for 9.5 – Add support for INSERT … ON CONFLICT DO NOTHING/UPDATE.
- Waiting for 9.5 – Add transforms feature
April 2015
- Waiting for 9.5 – Reduce lock levels of some trigger DDL and add FKs
- Waiting for 9.5 – psql: add asciidoc output format
- Waiting for 9.5 – Add stats for min, max, mean, stddev times to pg_stat_statements.
- Waiting for 9.5 – Add support for index-only scans in GiST.
- Waiting for 9.5 – Add pg_rewind, for re-synchronizing a master server after failback.
- Waiting for 9.5 – Allow foreign tables to participate in inheritance. – A.K.A. PostgreSQL got sharding.
- Waiting for 9.5 – Use 128-bit math to accelerate some aggregation functions.
March 2015
February 2015
- How to pg_upgrade …
- Waiting for 9.5 – Replace checkpoint_segments with min_wal_size and max_wal_size.
- I have PostgreSQL, loaded some data, and have app using it. Now what?
- Returning data in multiple columns
- Fixed a bug in OmniPITR
January 2015
2014 46
December 2014
- Waiting for 9.5 – Add point <-> polygon distance operator.
- Waiting for 9.5 – REINDEX SCHEMA
- Waiting for 9.5 – Event Trigger for table_rewrite
- How much slower are numerics?
November 2014
- My personal PostgreSQL Wish List
- Waiting for 9.5 – Support arrays as input to array_agg() and ARRAY(SELECT …).
- Waiting for 9.5 – Add generate_series(numeric, numeric).
- Zombicide – pilot rescue
- Waiting for 9.5 – BRIN: Block Range Indexes.
- How to install your own copy of explain.depesz.com
- Changes on explain.depesz.com
October 2014
- PostgreSQL + Perl + Unicode == confusion. Why?
- What logging has least overhead?
- Waiting for 9.5 – Implement SKIP LOCKED for row-level locks
- Waiting for 9.5 – Row-Level Security Policies (RLS)
September 2014
- Waiting for 9.5 – Add width_bucket(anyelement, anyarray).
- Waiting for 9.5 – Add psql PROMPT variable showing which line of a statement is being edited.
- Waiting for 9.5 – Support ALTER SYSTEM RESET command.
- Waiting for 9.5 – Add min and max aggregates for inet/cidr data types.
- Waiting for 9.5 – Implement ALTER TABLE .. SET LOGGED / UNLOGGED
July 2014
- Waiting for 9.5 – psql: Show tablespace size in \db+
- Waiting for 9.5 – Implement IMPORT FOREIGN SCHEMA.
- Waiting for 9.5 – Add cluster_name GUC which is included in process titles if set.
June 2014
- Waiting for 9.5 – Implement UPDATE tab SET (col1,col2,…) = (SELECT …), …
- Anonymize CTE names on explain.depesz.com
May 2014
- Joining BTree and GIN/GiST indexes
- Waiting for 9.4 – Add support for wrapping to psql’s “extended” mode.
April 2014
- Waiting for 9.4 – Provide moving-aggregate support for a bunch of aggregates.
- How to deal with timestamps?
March 2014
- Waiting for 9.4 – Introduce jsonb, a structured format for storing json.
- Waiting for 9.4 – auto_explain: Add logging of trigger execution
- Waiting for 9.4 – Constructors for interval, timestamp, timestamptz
- Waiting for 9.4 – Introduce logical decoding
- Waiting for 9.4 – Allow BASE_BACKUP to be throttled
- Waiting for 9.4 – pg_basebackup: Add support for relocating tablespaces
February 2014
January 2014
- Waiting for 9.4 – Add json_array_elements_text function.
- Waiting for 9.4 – New json functions.
- Getting count of distinct elements, per group, in PostgreSQL.
- Waiting for 9.4 – Add pg_stat_archiver statistics view.
- Waiting for 9.4 – Add recovery_target=’immediate’ option.
- Waiting for 9.4 – Tablespace changes
- I did my part :)
- Waiting for 9.4 – Support ordered-set (WITHIN GROUP) aggregates.
- Waiting for 9.4 – pg_prewarm, a contrib module for prewarming relationd data.
- Waiting for 9.4 – Add ALTER SYSTEM command to edit the server configuration file.
2013 51
December 2013
- OmniPITR 1.3.2
- Waiting for 9.4 – Allow time delayed standbys and recovery
- Waiting for 9.4 – Improve EXPLAIN to print the grouping columns in Agg and Group nodes.
- Waiting for 9.4 – PL/Perl: Add event trigger support
- OmniPITR 1.3.1
- Waiting for 9.4 – Add new wal_level, logical, sufficient for logical decoding.
- OmniPITR 1.3.0
- What does “Fix VACUUM’s tests to see whether it can update relfrozenxid” really mean?
November 2013
- Waiting for 9.4 – Support multi-argument UNNEST(), and TABLE() syntax for multiple functions.
- Waiting for 9.4 – Add tab completion for \pset in psql.
October 2013
- explain.depesz.com – update, new (great!) feature
- Bloat removal without table swapping
- Waiting for 9.4 – psql: Make \pset without arguments show all settings.
September 2013
August 2013
July 2013
- Waiting for 9.4 – WITH CHECK OPTION support for auto-updatable VIEWs
- Waiting for 9.4 – Add SQL Standard WITH ORDINALITY support for UNNEST (and any other SRF)
- Waiting for 9.4 – Implement the FILTER clause for aggregate function calls.
- Waiting for 9.4 – Add support for REFRESH MATERIALIZED VIEW CONCURRENTLY.
June 2013
- Waiting for 9.4 – ALTER TABLE … ALTER CONSTRAINT for FKs
- Bloat removal by tuples moving
- Sprzedam Toyote GT86, prawie nówka, 4 miesiące, bezwypadkowa
May 2013
- Explaining the unexplainable – part 5
- Explaining the unexplainable – part 4
- A tale of automating tests of Pg with Bash
- Explaining the unexplainable – part 3
April 2013
- Explaining the unexplainable – part 2
- Win a book contest – PostgreSQL Backup and Restore How-to
- Explaining the unexplainable
- Waiting for 9.3 – Support indexing of regular-expression searches in contrib/pg_trgm.
- Waiting for 9.3 – Add \watch [SEC] command to psql.
- New OmniPITR release
March 2013
- Changes on explain.depesz.com
- Waiting for 9.3 – Add new JSON processing functions and parser API.
- Waiting for 9.3 – Add parallel pg_dump option.
- Waiting for 9.3 – Support writable foreign tables.
- Waiting for 9.3 – Report pg_hba line number and contents when users fail to log in
- Waiting for 9.3 – JSON generation improvements.
- Waiting for 9.3 – Provide database object names as separate fields in error messages.
- Parallel dumping of databases
- Waiting for 9.3 – Add a materialized view relations.
- Waiting for 9.3 – Add CREATE RECURSIVE VIEW syntax
February 2013
- Waiting for 9.3 – Add support for piping COPY to/from an external program.
- Variables in SQL, what, how, when?
- Waiting for 9.3 – Create a psql command \gset to store query results into psql variables
January 2013
2012 52
December 2012
- Command line tools? In XXI century? No way! Yes way!
- Waiting for 9.3 – Allow a streaming replication standby to follow a timeline switch.
- Waiting for 9.3 – Support automatically-updatable views.
- CuTE overload
- Waiting for 9.3 – Background worker processes
- What is the point of bouncing?
November 2012
- Window, window on the wall …
- How I Learned to Stop Worrying and Love the Triggers
- Changes on explain.depesz.com
- Birthday cake again
October 2012
September 2012
August 2012
- Filling the gaps with window functions
- Waiting for 9.3 – Implement SQL-standard LATERAL subqueries.
- “PostgreSQL: Up and Running” by Regina Obe and Leo Hsu
July 2012
- Pg::SQL::Parser
- Waiting for 9.3 – Event triggers
- Waiting for 9.3 – Add array_remove() and array_replace() functions.
- Waiting for 9.3 – Dramatically reduce System V shared memory consumption.
- Changes on explain.depesz.com
- OmniPITR 1.0.0 released
June 2012
- How to get shortest connection between two cities
- How to send mail from database?
- Why is UPSERT so complicated?
- How much RAM is PostgreSQL using?
- “= 123″ vs. “= ‘depesz’” – followup
- “= 123” vs. “= ‘depesz'”. What is faster?
May 2012
April 2012
- OmniPITR 0.6.0
- Waiting for 9.2 – DROP INDEX CONCURRENTLY
- Let’s talk dirty
- Szukam webmastera [polish only]
March 2012
- Request for help with Python/Flask – Prośba o pomoc z Pythonem/Flaskiem
- Waiting for 9.2 – pg_stat_statements improvements
- OmniPITR 0.5.0
February 2012
- Waiting for 9.2 – More rewrite-less ALTER TABLE ALTER TYPEs
- Waiting for 9.2 – EXPLAIN TIMING
- Waiting for 9.2 – Named parameters in SQL functions
- Waiting for 9.2 – JSON
- Waiting for 9.2 – deadlock counter
- Waiting for 9.2 – temporary file stats per database
- Waiting for 9.2 – pg_basebackup from slave
- Waiting for 9.2 – Trigger Depth
- Waiting for 9.2 – ALTER IF EXISTS
January 2012
- Change in anonymization of plans on explain.depesz.com
- Some new tools for PostgreSQL or around PostgreSQL
- Waiting for 9.2 – split of current_query in pg_stat_activity
- Waiting for 9.2 – NULLS from pg_*_size() functions
- What is the point of social sites? / Do czego służą serwisy społecznościowe?
- OmniPITR 0.3.0
2011 60
December 2011
- Tips N’ Tricks – getting sizes of relations without locks
- r/trees ( recursive trees, what did you think about? )
- Waiting for 9.2 – excluding data of table from dump
- Louis CK – live at the Beacon Theater
- The secret ingredient in the webscale sauce
November 2011
October 2011
September 2011
- What index to create?
- Waiting for 9.2 – filtered info in explain analyze
- Najlepszy serial wszech czasów [polish only]
- Ford? Ford! – polish only
- New project – Curo
July 2011
- Waiting for 9.2 – cascading streaming replication
- “Help me” summary after a month
- Waiting for 9.2 – Stacked Diagnostics in PL/pgSQL
- Waiting for 9.2 – Avoiding reindexing on alter type of indexed column
- T-Mobile zadba o Twoją prywatność?
- Write Ahead Log + Understanding postgresql.conf: checkpoint_segments, checkpoint_timeout, checkpoint_warning
- explain.depesz.com update
- Wish list for psql
- Waiting for 9.2 – relative paths in psql
- Bloat happens
- Understanding postgresql.conf : work_mem
June 2011
- Waiting for 9.2 – NOT VALID CHECKS
- Why is “depesz” between “de luca” and “de vil”?
- How to let clients to create new users?
- Waiting for 9.1 – final post
- explain.depesz.com – new feature and some new stats
- OmniPITR – important update
May 2011
- Pagination with fixed order
- Understanding postgresql.conf : log*
- Tips n’ Tricks – return nothing from PL/PgSQL function
April 2011
March 2011
- Big changes on explain.depesz.com
- Waiting for 9.1 – Synchronous replication
- Waiting for 9.1 – Writable CTE
- explain.depesz.com version 2.0
- Waiting for 9.1 – Foreign data wrapper
- Waiting for 9.1 – Transaction level advisory locks
- Waiting for 9.1 – Arrays in PL/Perl
- Waiting for 9.1 – FOREACH IN ARRAY
- Waiting for 9.1 – Rewrite-less changing types of column
- Waiting for 9.1 – pg_ctl promote
- Waiting for 9.1 – Per-column collation support
- Waiting for 9.1 – stats reset tracking
- Waiting for 9.1 – EXTENSIONS
February 2011
- Waiting for 9.1 – INVALID FOREIGN KEYS
- Waiting for 9.1 – Faster LIKE/ILIKE
- Waiting for 9.1 – Add UNIQUE/PRIMARY KEY with index
- OmniPITR – update
January 2011
2010 74
December 2010
- Two years of explain.depesz.com
- A tale of slow ssh connections
- Waiting for 9.1 – KNNGIST
- Named interfaces for OpenVPN and Cisco VPN
- Auto refreshing password file for pgbouncer
November 2010
- Waiting for 9.1 – auth_delay
- Waiting for 9.1 – format()
- Waiting for 9.1 – Removed autocast footgun
- Understanding postgresql.conf : checkpoint_completion_target
- What would Roy Merritt do?
October 2010
- Waiting for 9.1 – adding values to enums
- Waiting for 9.1 – Suffix matching in pg_hba.conf
- Grouping data into time ranges
- Reduce bloat of table without long/exclusive locks
- Why I’m not fan of TSearch?
- Waiting for 9.1 – hostnames in pg_hba.conf
- Waiting for 9.1 – triggers on views
- Waiting for 9.1 – ALTER TYPE
- Obsługa klienta (polish only)
- Performance gains from using foreign keys
September 2010
- Faking “From ” header with procmail/formail
- How to group messages into chats?
- Why is my index not being used?
August 2010
- Tips N’ Tricks – using GNU Screen as shell
- Waiting for 9.1 – concat, concat_ws, right, left, reverse
- How to manage changes to your database?
- OmniPITR – hot backup on slave
- Eksperymenty kuchenne – polish only
- Waiting for 9.1 – Recognize functional dependency on primary keys.
- Waiting for 9.1 – Reduced lock levels for ALTER TABLE
- How to make sure you will not get any help on IRC
July 2010
- Waiting for 9.1 – CREATE TABLE IF NOT EXISTS
- How to order by some random – query defined – values?
- Logging queries – how?
- Waiting for 9.1 – \conninfo in psql
- Waiting for 9.1 – standard_conforming_strings = on
- Waiting for 9.0 – Final Post ?
June 2010
- OmniPITR – update
- Should you use HASH index?
- Tips N’ Tricks – looking for value in all columns of a table
- Dream wishlist for 9.1
- Test driven development for PostgreSQL
- To rule or not to rule – that is the question
- OmniPITR
May 2010
- Frontem do klienta – merlin.pl (polish only)
- What mistakes you can avoid when looking for help on IRC?
- Waiting for 9.0 – pg_upgrade
- Tips n’ tricks – rank on changes
- Co mnie wkurza w serwisach WWW [polish only]
April 2010
- Stupid tricks – hiding value of column in select *
- Getting unique elements
- Tips n’ Tricks – using “wrong” index
- How to remove backups?
March 2010
- Profiling stored procedures/functions
- Setting WAL Replication
- Stupid tricks – Dynamic updates of fields in NEW in PL/pgSQL
- ERROR: invalid byte sequence for encoding
- CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03
February 2010
- Installing PostgreSQL
- Waiting for 9.0 – extended frames for window functions
- Waiting for 9.0 – string_agg
- Waiting for 9.0 – removal of 0000000001.history check
- Waiting for 9.0 – table and index sizes
January 2010
- Waiting for 9.0 – Streaming replication
- Waiting for … 9.0
- I just *HATE* Hardware Abstraction Layer
- explain.depesz.com – stats after a year
- Waiting for 8.5 – VACUUM FULL change
- Waiting for 8.5 – Hot Standby
- Waiting for 8.5 – PL/pgSQL by default
- Waiting for 8.5 – ordered aggregates
- Waiting for 8.5 – buffers info for explain
- Waiting for 8.5 – exclusion constraints
- Waiting for 8.5 – PL/Perl DO
2009 57
December 2009
- Waiting for 8.5 – Application name reporting
- Waiting for 8.5 – better wrapped output in psql
- Waiting for 8.5 – conditional triggers
- Waiting for 8.5 – checking password strength
- Waiting for 8.5 – PL/pgSQL variable resolution
November 2009
- Waiting for 8.5 – TRIGGERS on columns
- Waiting for 8.5 – Named function arguments
- Waiting for 8.5 – GUC per user and database
- Waiting for 8.5 – “GRANT ALL”
- Waiting for 8.5 – ‘samehost’ and ‘samenet’ in pg_hba.conf
- Waiting for 8.5 – DO
October 2009
- Czemu jestem taki ułomny? (wylgaryzmy, polish only)
- Calculating backlog of events to handle
- Koniec romansu ( polish only )
- Waiting for 8.5 – changes in hstore
- Waiting for 8.5 – MOVE {FORWARD,BACKWARD} X
- Weather where I live
September 2009
- Speeding up dump/restore process
- [polish only] Historia ku pamięci … – aktualizacja
- CREATE ROLE privilege cannot be inherited?!
- Getting random interfacelift wallpaper
August 2009
- Waiting for 8.5 – Machine readable EXPLAIN
- Waiting for 8.5 – Multi-threaded pgbench
- Getting session variables without touching postgresql.conf
- Waiting for 8.5 – hinting for number of distinct values
- Waiting for 8.5 – better messages for unique violation
- Waiting for 8.5 – deferrable uniqueness
July 2009
- 1000 posts
- Waiting for 8.5 – pgsql: DROP IF EXISTS for columns and constraints.
- Calculating median
- Slow vim startup
- Getting list of unique elements
- bf hacking for “fun” and definitely no profit
- Waiting for 8.5 – Add log_line_prefix placeholder %e to contain the current SQL state
- Waiting for 8.5 – Have \d show child tables that inherit from the specified parent
- Waiting for 8.5 – let’s start
June 2009
- explain.depesz.com – update
- Tips N’ Tricks – Generating readable reports with plain SQL
- explain.depesz.com – update
May 2009
April 2009
March 2009
- Getting list of all children in “adjacency list” tree structure
- Waiting for 8.4 – no more -d in pg_dump!
- Set operations in shell
- How to find newest file with given name?
February 2009
- find.best.tablespace.split.pl
- lpad() and rpad() gotcha
- Waiting for 8.4 – parallel restoration of dumps
January 2009
2008 102
December 2008
- Waiting for 8.4 – Window Functions – teaser
- explain.depesz.com – update
- Waiting for 8.4 – Default values for function arguments + integer in any base
- Waiting for 8.4 – Visibility maps
- explain.depesz.com.
November 2008
- Getting list of most common domains
- Recovering from a lost PostgreSQL password.
- depesz kocha ubezpieczycieli
- Waiting for 8.4 – TABLE
- Waiting for 8.4 – auto-explain
- Designing database for storing human-human relations
- Waiting for 8.4 – array aggregate and array unpacker
- Waiting for 8.4 – suppress_redundant_updates_trigger
- Waiting for 8.4 – sql-wrappable RETURNING
- Waiting for 8.4 – pl/* srf functions in selects
October 2008
- Tips N’ Tricks – setting field based on order
- Is there any good versioning package for database schema and/or data?
- Text comparisons that does automatic trim()
- Tips N’ Tricks – count of all and just some
- Waiting for 8.4 – Common Table Expressions (WITH queries)
- Deserialization of hstore data structure in Perl
- Waiting for 8.4 – new FSM (Free Space Map)
September 2008
- depesz vs. ubezpieczyciel (polish only)
- Waiting for 8.4 – database-level lc_collation and lc_ctype
- CitiBank – frontem do klienta (polish only)
- Getting record by 2 criteria, ordered by third – how to do it quickly?
- Waiting for 8.4 – pgbench with timed execution
- pgsql-tools/analyze.pgsql.logs.pl
- Waiting for 8.4 – ordered data loading in pg_dump
- pgsql-tools/analyze.pgsql.logs.pl
- Waiting for 8.4 – \ef in psql
August 2008
- Hunting “idle in transactions”
- NULLs vs. NOT IN()
- Waiting for 8.4 – case insensitive text ( citext )
- Waiting for 8.4 – UNION / INTERSECT / EXCEPT
- Removing elements from arrays
- Waiting for 8.4 – hash based DISTINCT
- Waiting for 8.4 – RETURNS TABLE
- Writing sprintf, and overcoming limitations in pl/perl
July 2008
- Waiting for 8.4 – variadic functions
- Waiting for 8.4 – storage types for table columns
- Waiting for 8.4 – sequence details
- Lack of new posts
- Suppressing CONTEXT lines in psql
- Who/what is trashing db performance?
June 2008
- Conditional DDL?
- Waiting for 8.4 – timing on/off
- pgsql-tools/analyze.pgsql.logs.pl
- pgsql-tools/analyze.pgsql.logs.pl
May 2008
- pgsql-tools/analyze.pgsql.logs.pl
- Counting number of distinct elements
- Silencing \commands in .psqlrc
- Waiting for 8.4 – partial-match support in GIN, and sequence restart
- Waiting for 8.4 – CASE in pl/PgSQL
- Waiting for 8.4 – function stats
- Waiting for 8.4 – pl/PgSQL RAISE
- Prepared statements gotcha
- Waiting for 8.4 – psql vs. tabs + wrapped output
- MySQL’s timestamp in PostgreSQL
- “ERROR: operator does not exist: integer = text” how to fix it?
- Waiting for 8.4 – pg_conf_load_time, time-related generate_series and enum values in \dT+
- Waiting for 8.4 – RETURN QUERY EXECUTE and cursor_tuple_fraction
- Waiting for 8.4 – \o and \d+ in psql
- What does “success” mean to You?
April 2008
- Waiting for 8.4 – generate_subscripts
- Polish TSearch in 8.3 (polski tsearch w postgresie 8.3)
- Waiting for 8.4 – “EXPLAIN VERBOSE”
- do you know crontab?
- My take on trees in SQL
- postgresql @ highscalability.com
- waiting for 8.4 – current_query()
- waiting for 8.4
March 2008
- waiting for 8.4
- keyboard shortcuts in psql
- using separate environments for people using single account
- waiting for 8.4
- smtp + sql = more than it seems so (part 9)
- waiting for pg 8.4
- waiting for pg 8.4
- unix crontab and longest interval
- projektowanie stron przy pomocy screenshotów z innego serwisu
- getting multiple values from sequences
- smtp + sql = more than it seems so (part 8)
- smtp + sql = more than it seems so (part 7)
- waiting for pg 8.4
- smtp + sql = more than it seems so (part 6)
- searching for longest prefix
February 2008
- smtp + sql = more than it seems so (part 5)
- smtp + sql = more than it seems so (part 4)
- waiting for pg 8.4
- smtp + sql = more than it seems so (part 3)
- failing ls ?
- Vimrc
- smtp + sql = more than it seems so (part 2)
- pgsql-tools/analyze.pgsql.logs.pl
- smtp + sql = more than it seems so (part 1)
- it’s coming, it’s coming, it’s here, have no fear
January 2008
2007 316
December 2007
- how many 1sts of any month were sundays – since 1901-01-01?
- shared buffers and their impact on performance
November 2007
- time ranges in postgresql – part 2
- find overlapping time ranges
- pgsql-tools/analyze.pgsql.logs.pl
- pgsql-tools/analyze.pgsql.logs.pl
- overprotective developers
- pgsql-tools/analyze.pgsql.logs.pl
- encrypted passwords in database
- text to hstore migration
October 2007
- glasbergen for today
- what should be fixed in postgresql
- auta.cc otwarte (polish only)
- who has birthday tomorrow?
- i just “love” locale issues.
- grant XXX on * ?
- find.best.tablespace.split.pl
- finding missing pairs
- pgsql-tools/analyze.pgsql.logs.pl
- “FATAL: Ident authentication failed”, or how cool ideas get bad usage schemas
- motto na dziś: przed nami tylko wzrost.
September 2007
- mbank frontem do klienta [polish only]
- finding optimum tables placement in 2-tablespace situation
- analyze.pgsql.logs / pgsql-tools
- easy access to postgresql documentation from firefox
- dell powervault md1000 – storage test
- what fields are usually changed when update’ing?
- copy to existing table with updates?
- postgresql tips & tricks
- while + ssh = ?
- how to remove duplicated rows?
- my thoughts on getting random row
- speeding up like ‘%xxx%’
- objects in categories – counters with triggers
- new versions are coming
- 31337 vision express / super optyk [polish only]
- avoiding “empty” updates
- analyze.pgsql.logs
- (postgre)sql gotchas
- indexable “field like ‘%something'” – update
- how many transactions per second?
August 2007
- postgresql tips & tricks
- better results paging in postgresql 8.2
- postgresql tips & tricks
- łosoś w sake [polish only]
- analyze.pgsql.logs
- effective finding queries to optimize
- securing your postgresql database
- rownum anyone? cumulative sum in one query?
- “hacking” with postgresql
- psql prompt issue
- Log Buffer #57: a Carnival of the Vanities for DBAs
- simple howto about restoring damaged template1
- better explain analyze
- set returning functions in 8.3
July 2007
- indexable ” field like ‘%something'”
- update account set password = ‘new_password’; oops?!
- migrating live system from single-disk to raid1
- postgresql tips & tricks
- londiste – simple replication system for postgresql
- cumulative sum in sql – howto part2
- cumulative sum in sql – howto
- how to insert data to database – as fast as possible
- looking for hosting
- drzewa w sql’u – ltree
- drzewa w sql’u – metoda pełnych ścieżek (metoda nr. 5 w/g starego tekstu)
June 2007
- random text record identifiers
- print “read manual” while each %bug;
- tsearch – instalacja, testy, rozszerzanie
- parsowanie rss’ów
April 2007
March 2007
- tapeta na dzis
- tapeta na dzis
- tapeta na dzis
- tapeta na dzis
- tapeta na dzis
- tapeta na dzis
- tapeta na dzis
- tapeta na dzis
- tapeta na dzis
- tapeta na dzis
- tapeta na dzis
- tapeta na dzis
- tapeta na dzis
- walka z fikcją
- triggerek
- tapeta na dzis
February 2007
- technika, technika
- tapeta na dzis
- 5 rzeczy których nie chcieliście wiedzieć i nigdy o nie nie pytaliście.
- tapeta na dzis
- nowości w postgresie 8.3 – prompt
- zarabianie na linuksie
- tapeta na dzis
- 25 startupów
- co wpływa na awarie dysków?
- świetny biznes czy nieetyczne badanie rynku?
- tapeta na dzis
- case study: join, subselect, indeksy + pomysł na “aliasy” wyliczanych stałych
- alternatywa dla wysokojakościowych radiowych łącz dla telewizji?
- witajcie inne planety
- nagroda turinga za rok 2006 – po raz pierwszy dla kobiety
- tapeta na dzis
- tapeta na dzis
- narzekanie
- tapeta na dzis
- drobny błąd
- tapeta na dzis
- miejski samochód
- porównanie implementacji ruby’ego
- nowa technologia kości ram
- tapeta na dzis
- dlaczego “kocham” mysql’a
- postgres 8.3 – wishlist
- tapeta na dzis
- tapeta na dzis
- power6 – nowa, lepsza generacja
- niagara 2 – ciekawostka
- język w jakim napisano nasz świat
- tapeta na dzis
- tapeta na dzis
- nowy biznesowy blackberry
- tapeta na dzis
- nowy procesor intela – prototyp
- wsiąść do pociągu. nie byle-jakiego.
- poważny błąd w postgresie
- tapeta na dzis
- tapeta na dzis
- drop table if exists
- tapeta na dzis
- zestawienie szybkiego serwisu
- nieoczekiwany sojusznik w walce z drm’em
- ś.p. spinacz
- masowe nadawanie praw
- tapeta na dzis
- archiwa playboya
- kasowanie zbyt starych danych
- przeglądanie źródeł postgresa
- tapeta na dzis
- tapeta na dziś
- zagrożenie dla firmy
- czyszczenie cache’a dyskowego
- wow. photoshop na wysokim poziomie
- tapeta na dzis
- mysql + soliddb
- upadły pegaz
- gadżet. czy może faktyczne zastępstwo książek?
- modna wirtualizacja
- przyspieszanie digg’a i inne cuda :)
- oops. popsuty postgres
- tapeta na dzis
- tapeta na dzis
- kanapa. fotel. sofa. a co jeszcze?
- porównanie wydajności popularnych frameworków webowych
- tapeta na dzis
- interesująca agencja pośrednictwa pracy
- pc vs. mac
- tapeta na dzis
- wii odchudza
- ford sprzedał aston martina
- Potwor
- teoria strun ma szansę być dowiedziona lub obalona
- nowy materiał na obudowy komórek (telefonów)
- nowa wersja znanego systemu operacyjnego
- nowy chip dla komórek
- coca cola jako sos?
- otwieranie samochodów piłką tenisową
- mniej wirusów. mniej niż …
- tapeta na dzis
- czym zrazić użytkowników
- agregaty wielowartościowe
- ekstremalna wycieczka
- 8.2.2 i inne
- tapeta na dzis
- pdf standardem iso?
- odcinania balastu ciąg dalszy
- sprawdzanie które wiersze w tabeli są zalockowane
- mysql enterprise db – interesujący model opłat
- przełom w technologiach procesorowych
- nereczkę? płuco? serduszko? chińskie, ale działa.
- dell strikes back
- nowy maintainer pgmemcache
- tapeta na dzis
January 2007
- nielegalne żarówki
- spam, spam, spam, jajecznica i spam. i jeszcze trochę spamu
- tapeta na dzis
- wygrał podróż w kosmos. i przegrał.
- youtube ma biznesplan!
- eksperci ze świata
- wzrost rynku bazodanowego
- dbi-link
- tapeta na dzis
- tapeta na dzis
- drogie, piękne i szybkie
- umiesz robić zdjęcia?
- szybsze wifi w centrino. już!
- amd kontratakuje. werbalnie.
- tapeta na dzis
- mysql rządzi? indeksy pokrywające
- tapeta na dzis
- tapeta na dzis
- losowy rekord z bazy danych
- mikro-dezynfekcja
- tapeta na dzis
- tapeta na dzis
- przełom w bateriach czy kolejna ściema?
- sun na xeonach
- tani samochód od toyoty
- chyba to połamię
- rocznica technologii stealth
- tapeta na dzis
- Lampy
- czytanie manuali popłaca
- tapeta na dzis
- śmierć samobójcy
- piękne i bestie
- prosta genealogia
- kolejny “otwarty” stuff – c.d.
- perl best practices critic
- gotowanie na filmie
- idę popływać na basen
- sprzęt pod linuksa
- bilion dolarów
- odpowiedzialność za niebezpieczny kod
- przełom w technologiach optycznych
- tapeta na dzis
- zaśmiecony template1 i kopiowanie baz
- tapeta na dzis
- drzewa w sql’u – metoda “zagnieżdżonych zbiorów”
- motocykl. na wodór.
- latający dywan
- vista – system którego nie można używać? c.d.
- jeździsz jak chłop
- tapeta na dzis
- windows vista – net install?
- chomik opowiada o wypadku
- skypetv
- prawdziwy railgun
- nowy concept
- pompki dla zdrowia
- tanie i bezpieczne lekarstwo na raka
- ciekawe akcesoria do ipoda
- tapeta na dzis
- openssh i wiele połączeń w to samo miejsce
- tapeta na dzis
- zrzut strony www do pliku graficznego
- czy potrzebujesz bazy danych?
- “koncept”?
- czy grozi ci śmierć przez przedawkowanie kofeiny?
- woda znikąd
- wirtualizacja w solarisie
- wybory w nowej zelandii – sukcesem postgresa
- tapeta na dzis
- zmaterializowane widoki
- tapeta na dzis
- sprawdzanie siły hasła
- abonament na upgrade sprzętu
- szybki duży zarobek
- Evo x
- akwarium
- pożytki z nudy
- tapeta na dzis
- tapeta na dzis
- tapeta na dziś
- świat nowych gier
- rewelacyjny plugin do firefoxa
- second life – open source!
- dla kogo się pracuje najlepiej?
- kilka nowych postgresów
- nieznany bohater: generate_series
- trackbacki
- tapeta na dziś
- apple-telefon
- tapeta na dziś
- tapeta na dziś
- mysql – skalowalność. kolejna odsłona
- medal za marketing – o ile ktoś to kupił
- acer sprzedaje laptopy z zainstalowanym backdoorem?
- tapeta na dziś
- nowa mazda
- jak nie odpowiadać na ogłoszenia o pracę
- wykład o klastrowaniu postgresa
- tapeta na dziś
- drzewa w sql’u – metoda “śledzenie rodzica”
- 1terabajt na pojedynczym dysku
- mythbusters
- tapeta na dziś
- wyszukiwanie w/g nipu
- patent na … DRM
- recenzja wii
- dziwne ostrzeżenia
- błękitne światło pozwala dłużej pracować
- tapeta na dziś
- pierwszy komercyjny nośnik holograficzny
- podstawy bezpieczeństwa – w/g nsa
- nowe ściany
- dwustronny wyświetlacz do komórek
- tani, mały storage (serio)
- hd dvd vs. blu-ray. zwycięzcą jest … lg
- macierz pod prywatne dane
- jak wygląda 200 kalorii
- nagroda darwina za rok 2006
- skalowalność mysql vs. pgsql
- tapeta na dziś
- tapeta na dziś
- indiana jones i świątynia mamony
- choroba szalonych krów – przeszłością?
- nowe opony
- międzynarodowa współpraca
- meta-poprawka
- rozszerzanie funkcjonalności serwisów webowych
- drzewa w sql’u – metoda wielu tabel
- tapeta na dziś
- drzewa w sql’u – wstęp
- two for the money / podwójna gra
- tapeta na dziś