Are you over 18 and want to see adult content?
More Annotations
A complete backup of https://georgetownehouse.com
Are you over 18 and want to see adult content?
A complete backup of https://healthkit.com
Are you over 18 and want to see adult content?
A complete backup of https://uka.org.uk
Are you over 18 and want to see adult content?
A complete backup of https://fieldofdreamsmoviesite.com
Are you over 18 and want to see adult content?
A complete backup of https://grossenhain.de
Are you over 18 and want to see adult content?
A complete backup of https://ironmountaindailynews.com
Are you over 18 and want to see adult content?
A complete backup of https://evget.com
Are you over 18 and want to see adult content?
A complete backup of https://aristou.com.sg
Are you over 18 and want to see adult content?
A complete backup of https://vladinvest.ru
Are you over 18 and want to see adult content?
A complete backup of https://gazeta-pokrovskoe-streshnevo.info
Are you over 18 and want to see adult content?
A complete backup of https://dynabrade.com
Are you over 18 and want to see adult content?
A complete backup of https://northwestfirearms.com
Are you over 18 and want to see adult content?
Favourite Annotations
A complete backup of flemingcollege.ca
Are you over 18 and want to see adult content?
A complete backup of janbasktraining.com
Are you over 18 and want to see adult content?
A complete backup of inverclydenow.com
Are you over 18 and want to see adult content?
Text
Skip to content
=$
select * | Menu
* Why upgrade PG?
* explain.D.C
* paste.D.C
* Waiting for … expand childmenu
* … PostgreSQL 13
* … PostgreSQL 12
* … PostgreSQL 11
* … PostgreSQL 10
* … PostgreSQL 9.6 * … PostgreSQL 9.5 * … PostgreSQL 9.4 * … PostgreSQL 9.3 * … PostgreSQL 9.2 * … PostgreSQL 9.1 * … PostgreSQL 9.0 * … PostgreSQL 8.5 * … PostgreSQL 8.4* Projects
* Contact
CHANGES ON EXPLAIN.DEPESZ.COMI just released
new version of Pg::Explain Perl library that is handling parsing of plans for explain.depesz.com.
There are quite a lot of changes, but mostly internal, but one thing is pretty interesting – Pg::Explain, and because of this also explain.depesz.com should be able to parse plans with arbitrary values of border, linestyle, format, unicode_border_linestyle, unicode_column_linestyle, and unicode_header_linestyle psql options.
You can see five simple examples already uploaded: Continue reading Changes on explain.depesz.com Posted on 2020-04-032020-04-03|Tags
border , explain.depesz.com, perl
, pg::explain
, postgresql
, psql
, unicode
|Leave a comment on Changes onexplain.depesz.com
WAITING FOR POSTGRESQL 13 – ALLOW PG_STAT_STATEMENTS TO TRACK PLANNING STATISTICS. On 2nd of April 2020, Fujii Masao committedpatch:
Allow pg_stat_statements to track planning statistics. This commit makes pg_stat_statements support new GUC pg_stat_statements.track_planning. If this option is enabled, pg_stat_statements tracks the planning statistics of the statements, e.g., the number of times the statement was planned, the total time spent planning the statement, etc. This feature is useful to check the statements that it takes a long time to plan. Previously since pg_stat_statements tracked only the execution statistics, we could not use that for the purpose. The planning and execution statistics are stored at the end of each phase separately. So there are not always one-to-one relationship between them. For example, if the statement is successfully planned but fails in the execution phase, only its planning statistics are stored. This may cause the users to be able to see different pg_stat_statements results from the previous version. To avoid this, pg_stat_statements.track_planning needs to be disabled. This commit bumps the version of pg_stat_statements to 1.8 since it changes the definition of pg_stat_statements function. Author: Julien Rouhaud, Pascal Legrand, Thomas Munro, Fujii Masao Reviewed-by: Sergei Kornilov, Tomas Vondra, Yoshikazu Imai, Haribabu Kommi, Tom Lane Discussion: https://postgr.es/m/CAHGQGwFx_=DO-Gu-MfPW3VQ4qC7TfVdH2zHmvZfrGv6fQ3D-Tw@mail.gmail.com Discussion: https://postgr.es/m/CAEepm=0e59Y_6Q_YXYCTHZkqOc6H2pJ54C_Xe=VFu50Aqqp_sA@mail.gmail.com Discussion: https://postgr.es/m/DB6PR0301MB21352F6210E3B11934B0DCC790B00@DB6PR0301MB2135.eurprd03.prod.outlook.com Continue reading Waiting for PostgreSQL 13 – Allow pg_stat_statements to track planning statistics. Posted on 2020-04-02|Tags
administration ,
performance , pg13
, pg_stat_statements, postgresql
, waiting
|Leave a comment on Waiting for PostgreSQL 13 – Allow pg_stat_statements to track planningstatistics.
WAITING FOR POSTGRESQL 13 – ENABLE BEFORE ROW-LEVEL TRIGGERS FORPARTITIONED TABLES
On 18th of March 2020, Alvaro Herrera committedpatch:
Enable BEFORE row-level triggers for partitioned tables ... with the limitation that the tuple must remain in the samepartition.
Reviewed-by: Ashutosh Bapat Discussion: https://postgr.es/m/20200227165158.GA2071@alvherre.pgsql Continue reading Waiting for PostgreSQL 13 – Enable BEFORE row-level triggers for partitioned tables Posted on 2020-03-31|Tags
partitioning , pg13
, postgresql
, trigger
, triggers
, waiting
|Leave a comment on Waiting for PostgreSQL 13 – Enable BEFORE row-level triggers for partitionedtables
INITIAL SUPPORT FOR FIXING OF LINE-WRAPPED PLANS Ever since I released explain.depesz.com over 11 years ago there have been cases were people would upload a plan and it didn't parse. There were many reasons, but the most common was – plan was line-wrapped by injecting new-line characters where there shouldn't beone.
Continue reading Initial support for fixing of line-wrapped plans Posted on 2020-03-16|Tags
break , explain
, explain.depesz.com, line
, perl
, pg::explain
, postgresql
|Leave a comment on Initial support for fixing of line-wrapped plans WHY I’M NOT FAN OF UUID DATATYPERecently, on irc ,
there were couple of cases where someone wanted to use uuid as datatype for their primary key. I opposed, and tried to explain, but IRC doesn't really allow for longer texts, so figured I'll write a blogpost. Continue reading Why I'm not fan of uuid datatype Posted on 2020-02-192020-02-18|Tags
opinion , performance, postgresql
, primary key
, readability
, uuid
|22 Comments on Why I’m not fan ofuuid datatype
FIX FOR DISPLAYING AGGREGATES ON EXPLAIN.DEPESZ.COM Couple of days ago RhodiumToad reported, on irc, a bug in
explain.depesz.com . Specifically – if explain was done using JSON/XML/YAML formats, and node type was Aggregate, the site didn't extract full info. Continue reading Fix for displaying aggregates on explain.depesz.com Posted on 2020-02-182020-02-18|Tags
aggregate , explain.depesz.com, irc
, json
, perl
, pg::explain
, postgresql
, xml
, yaml
|2 Comments on Fix for displaying aggregates on explain.depesz.com WHICH TABLES SHOULD BE AUTO VACUUMED OR AUTO ANALYZED – UPDATE Some time ago I wrote blogpost which showed how to list tables that should be autovacuumed orautoanalyzed.
Query in there had one important problem – it didn't take into account per-table settings. Continue reading Which tables should be auto vacuumed or auto analyzed– UPDATE
Posted on 2020-02-182020-02-18|Tags
administration ,
autovacuum , maintenance, postgresql
, queue
|1 Comment on Which tables should be auto vacuumed or auto analyzed – UPDATE WAITING FOR POSTGRESQL 13 – ADD %X TO DEFAULT PROMPT1 AND PROMPT2 INPSQL
On 12nd of February 2020, Michael Paquier committedpatch:
Add %x to default PROMPT1 and PROMPT2 in psql %d can be used to track if the current connection is in a transaction block or not, and adding it by default to the prompt has the advantage to not need a modification of .psqlrc, something not possible depending on the environment. This discussion has happened across various sources, and there was a strong consensus in favor of this change. Author: Vik Fearing Reviewed-by: Fabien Coelho Discussion: https://postgr.es/m/09502c40-cfe1-bb29-10f9-4b3fa7b2bbb2@2ndquadrant.com Continue reading Waiting for PostgreSQL 13 – Add %x to default PROMPT1 and PROMPT2 in psql Posted on 2020-02-172020-02-17|Tags
pg13 , postgresql
, prompt
, psql
, status
|1 Comment on Waiting for PostgreSQL 13 – Add %x to default PROMPT1 and PROMPT2 in psql WAITING FOR POSTGRESQL 13 – ADD LEADER_PID TO PG_STAT_ACTIVITY On 6th of February 2020, Michael Paquier committedpatch:
Add leader_pid to pg_stat_activity This new field tracks the PID of the group leader used with parallel query. For parallel workers and the leader, the value is set to the PID of the group leader. So, for the group leader, the value is the same as its own PID. Note that this reflects what PGPROC stores in shared memory, so as leader_pid is NULL if a backend has never been involved in parallel query. If the backend is using parallel query or has used it at least once, the value is set until the backend exits. Author: Julien Rouhaud Reviewed-by: Sergei Kornilov, Guillaume Lelarge, Michael Paquier, TomasVondra
Discussion: https://postgr.es/m/CAOBaU_Yy5bt0vTPZ2_LUM6cUcGeqmYNoJ8-Rgto+c2+w3defYA@mail.gmail.com Continue reading Waiting for PostgreSQL 13 – Add leader_pid topg_stat_activity
Posted on 2020-02-17|Tags
administration ,
leader_pid , parallel, pg13
, postgresql
|Leave a comment on Waiting for PostgreSQL 13 – Add leader_pid to pg_stat_activity SHOUT OUT TO HEATONIST.COM Some time ago I ordered some hot sauces from Heatonist – Purveyors of fine hot sauces . Bottles arrived packaged by 3 in a small cardboard box, with some fill in material (bubble wrap I think, I might be wrong, it was ~ 6 monthsago).
Some time passed, I ordered more sauces. And today the package arrived. Inside some new boxes with aesthetically pleasing design:Inside:
There was no plastic padding, fillers or anything like this. Box has holes that keep the bottles without touching each other, and safe from (almost?) all kind of damage: Great! I'm really happy that they managed to send those with as few plastic parts as possible (there is still small wrapper on top of each bottle, and the box itself was taped using plastic tape, not paper ones, but still – it's great to see someone doing something to reduce plastic waste. Posted on 2020-02-12|Tags
environment , heatonist, package
, plastic
, sauce
|Leave a comment on Shout out toheatonist.com
POSTS NAVIGATION
Page 1 Page 2 … Page 149Next page
SEARCH
Search for: Search
FOLLOW ME
* Comments RSS
* Posts RSS
POPULAR POSTS
* “ERROR: operator does not exist: integer = text” how to fixit?
280 views | 0 comments * Explaining the unexplainable – part 3 273 views | 0 comments * Waiting for 9.1 – FOREACH IN ARRAY 234 views | 0 comments * Explaining the unexplainable – part 2 198 views | 0 comments * How much RAM is PostgreSQL using? 169 views | 0 comments * CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 163 views | 0 comments * Incrementing counters in database 158 views | 0 comments * Waiting for PostgreSQL 13 – Allow pg_stat_statements to track planning statistics. 146 views | 0 comments * Waiting for PostgreSQL 11 – Fast ALTER TABLE ADD COLUMN with anon-NULL default
143 views | 0 comments * Why is UPSERT so complicated?131
views | 0 comments
POSTGRESQL
* Documentation
* Explain Analyze analyzer* IRC help channel
* Mailing Lists search* PG Planet
* PostgreSQL Home PageABOUT ME
* CPAN
* GitLab
* Linked In
* Why upgrade PG?
* explain.D.C
* paste.D.C
* Waiting for … expand childmenu
* … PostgreSQL 13
* … PostgreSQL 12
* … PostgreSQL 11
* … PostgreSQL 10
* … PostgreSQL 9.6 * … PostgreSQL 9.5 * … PostgreSQL 9.4 * … PostgreSQL 9.3 * … PostgreSQL 9.2 * … PostgreSQL 9.1 * … PostgreSQL 9.0 * … PostgreSQL 8.5 * … PostgreSQL 8.4* Projects
* Contact
Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0