Les nouveautés des produits dérivés

Offres d'emplois autour de PostgreSQL en août

PostgreSQL Local

PostgreSQL dans les média

PostgreSQL Weekly News / les nouvelles hebdomadaires vous sont offertes cette semaine par David Fetter. Traduction par l'équipe PostgreSQLFr sous licence CC BY-NC-SA.

Proposez vos articles ou annonces avant dimanche 15:00 (heure du Pacifique). Merci de les envoyer en anglais à david (a) fetter.org, en allemand à pwn (a) pgug.de, en italien à pwn (a) itpug.org et en espagnol à pwn (a) arpug.com.ar.

(lien vers l'article original)

Correctifs appliqués

Kevin Grittner a poussé :

  • Various cleanups for REFRESH MATERIALIZED VIEW CONCURRENTLY. Open and lock each index before checking definition in RMVC. The ExclusiveLock on the related table is not viewed as sufficient to ensure that no changes are made to the index definition, and invalidation messages from other backends might have been missed. Additionally, use RelationGetIndexExpressions() and check for NIL rather than doing our own loop. Protect against redefinition of tid and rowvar operators in RMVC. While working on this, noticed that the fixes for bugs found during the CF made the UPDATE statement useless, since no rows could qualify for that treatment any more. Ripping out code to support the UPDATE statement simplified the operator cleanups. Change slightly confusing local field name. Use meaningful alias names on queries in refresh_by_match_merge(). Per concerns of raised by Andres Freund and comments and suggestions from Noah Misch. Some additional issues remain, which will be addressed separately. http://git.postgresql.org/pg/commitdiff/841c29c8b3be98ee30486ee245ebee782d4dedd4

Tom Lane a poussé :

  • Simplify query_planner's API by having it return the top-level RelOptInfo. Formerly, query_planner returned one or possibly two Paths for the topmost join relation, so that grouping_planner didn't see the join RelOptInfo (at least not directly; it didn't have any hesitation about examining cheapest_path->parent, though). However, correct selection of the Paths involved a significant amount of coupling between query_planner and grouping_planner, a problem which has gotten worse over time. It seems best to give up on this API choice and instead return the topmost RelOptInfo explicitly. Then grouping_planner can pull out the Paths it wants from the rel's path list. In this way we can remove all knowledge of grouping behaviors from query_planner. The only real benefit of the old way is that in the case of an empty FROM clause, we never made any RelOptInfos at all, just a Path. Now we have to gin up a dummy RelOptInfo to represent the empty FROM clause. That's not a very big deal though. While at it, simplify query_planner's API a bit more by having the caller set up root->tuple_fraction and root->limit_tuples, rather than passing those values as separate parameters. Since query_planner no longer does anything with either value, requiring it to fill the PlannerInfo fields seemed pretty arbitrary. This patch just rearranges code; it doesn't (intentionally) change any behaviors. Followup patches will do more interesting things. http://git.postgresql.org/pg/commitdiff/3ced8837db2cd602422bb36102cec73289691d40

Bruce Momjian a poussé :

Fujii Masao a poussé :

Peter Eisentraut a poussé :

Correctifs rejetés (à ce jour)

  • No one was disappointed this week

Correctifs en attente

  • Michael Paquier sent in a patch to fix the documentation of FOR UPDATE/FOR SHARE in the cases of GROUP BY, DISTINCT, HAVING and window functions.
  • Michael Paquier sent in another revision of a patch to refactor the way background workers are implemented.
  • Amit Kapila sent in another revision of a patch to move unused buffers to the freelist.
  • Merlin Moncure sent in two more revisions of a patch to optimize StrategyGetBuffer.
  • Fujii Masao sent in a patch to remove the non-fast promotion path for replica to master.
  • Fabien COELHO sent in a patch to improve the pgbench measurements and progress report.
  • Tom Lane sent in a patch to fix an issue which manifested as a bug in row_to_json() where the planner incorrectly optimizes away ExecProject() if a scan plan node is not doing any useful projection.
  • Karl O. Pinc sent in a patch to document the fact that subqueries can't modify data.
  • Alvaro Herrera sent in a patch to factor duplicate code out of heap_deform_tuple and slot_deform_tuple, both because there's no point in duplicating it, and because there could potentially have been a third copy in the upcoming minmax patch.
  • Vik Fearing sent in a patch to enable collecting statistics when the CLUSTER command is run.
  • Tom Lane sent in a patch to emit a hint message when logging goes to or from stderr.
  • Vik Fearing sent in a patch to allow pg_sleep() to take an interval as a parameter.
  • Bruce Momjian sent in a patch to change the schema name control in pg_dump for ALTER OWNER via setting search_path rather than naming it explicitly in the object.
  • Andrew Tipton sent in a PoC patch to fix an issue with background workers.