Parallel Sequential Scan

Publié le: 11 juillet 2015
sur la chaîne: Andrea Ross

560

by Amit Kapila & Robert Haas

Unleashing a heard of elephants

Parallel query is close to becoming a reality in PostgreSQL! A year ago, much of the low-level infrastructure needed for parallelism, such as dynamic shared memory and dynamic background workers, had been completed, but no user-visible facilities made use of this infrastructure. Major work on error handling, transaction control, and state sharing has been completed, and further patches, including a patch for parallel sequential scan, are pending.

In this talk, we will talk about parallel sequential scan itself, including performance considerations, the work allocation strategy, and the cost model; and we will also discuss the infrastructure that supports parallel sequential scan, including state sharing for GUCs, transaction state, snapshots, and combo CIDs; error handling and transaction management; and the handling of heavyweight locking. Finally, we'll discuss the future of parallelism in PostgreSQL now that the basic infrastructure is (mostly) complete.

Sur cette page du site, vous pouvez voir la vidéo en ligne Parallel Sequential Scan durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Andrea Ross 11 juillet 2015, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 560 fois et il a aimé 2 téléspectateurs. Bon visionnage!

190