2,694 Works

Implementing Parallelism in PostgreSQL

Robert Haas
Where We Are Today, and What's On The Horizon PostgreSQL's architecture is based heavily on the idea that each connection is served by a single backend process, but CPU core counts are rising much faster than CPU speeds, and large data sets can't be efficiently processed serially. Adding parallelism to PostgreSQL requires significant architectural changes to many areas of the system, including background workers, shared memory, memory allocation, locking, GUC, transactions, snapshots, and more. In...

Gaia Variability Studies: case for Postgres-XC.

Krzysztof Nienartowicz
Mapping a billion stars throughout our Galaxy and beyond Gaia is a cornerstone European Space Agency mission that will create an extraordinarily precise three-dimensional map of more than a billion stars throughout our Galaxy and beyond, mapping their motions, luminosity, temperature and composition. This huge stellar census will provide the data needed to tackle an enormous range of important problems related to the origin, structure and evolutionary history of our Galaxy. I will describe how...

Explaining the Postgres Query Optimizer

Bruce Momjian
The optimizer is the "brain" of the database, interpreting SQL queries and determining the fastest method of execution. This talk uses the EXPLAIN command to show how the optimizer interprets queries and determines optimal execution. Examples include scan methods, index selection, join types, and how ANALYZE statistics influence their selection. The talk will assist developers and administrators in understanding how Postgres optimally executes their queries and what steps they can take to understand and perhaps...

Balancing Database Storage Latency And Throughput

Greg Smith
by Greg Smith The easiest type of benchmark to run on a database is checking its throughput: the total transactions processed during some period of time. But throughput isn't what application users care about. They want low latency. Latency and throughput have a complex dependency on each other, and you'll need a whole new type of test to balance them well. Recent advances in benchmarking tools, like the rate limit in pgbench 9.4, make it...

Warm standby done right

Heikki Linnakangas
People has been setting up warm standby systems with streaming replication since version 9.0, and even longer with file-based log-shipping. However, there has been a few pitfalls that many people don't know about, while others have simply accepted the risks. PostgreSQL 9.5 brings a bunch of new features and subtle changes that make warm standby setups more robust than ever. In 9.5, the interaction between a WAL archive and failover has been revised. pg_rewind makes...

Transacting with foreign servers

Ashutosh Bapat
Managing transactions involving multiple foreign servers. PostgreSQL has Foreign Data Wrappers and they are writable too! Upcoming features like partitioning, foreign table inheritance and join-push down for foreign tables pave the path for sharding. One missing piece in the puzzle is the distributed transaction manager required to maintain the atomicity and consistency of transactions involving foreign servers. The presentation talks about the current status of such transactions and discusses the path forward towards distributed transaction...

Tracing PostgreSQL performance

Ilya Kosmodemiansky

The Art of Performance Evaluation

Yuto Hayamizu
"Contrary to common belief, performance evaluation is an art." (Raj Jain, 1991) Successful performance evaluation may not be achieved with merely executing common benchmarking tools. This talk presents fundamental principles of performance evaluation and how you can put them into practice. Do you understand what exactly "pgbench" does? Is it appropriate workload for your performance evaluation goal? Common benchmarking tools like "pgbench" are handy for just comparing system A and system B, but if you...

Shabang

Joe Conway
Scripting with Postgres Sometimes bash is just the way to go! This talk will cover tips and techniques for effective bash scripting with PostgreSQL. Sometimes bash is just the way to go! This talk will cover tips and techniques for effective bash scripting with PostgreSQL. It will include guidance about: Pros/cons of shell scripts Function library creation and use Executing SQL Set/get PostgreSQL data from/into script variables Keeping PostgreSQL functions in sync with scripts Locking...

Multi-Tenancy in PostgreSQL

Arul Shaji
This talk is about the need of multi-tenancy in PostgreSQL, and the way to achieve multi-tenancy in PostgreSQL. What is a multi-tenant cluster? Why multi-tenant cluster is needed? PostgreSQL Provides multi-tenancy with the following - Shared Database, Shared Namespace - Separate Databases - Shared Database, Separate Namespace However multi-tenancy means more than this. - Issues with a multi-tenant cluster - What can be done and what can we do to make it easier. This talk...

9.5 Coming to You Live

Keith Fiske
New features by demo This all-demo, no-slide talk will show off 9.5's new features. With every new Postgres release comes new features and improvements to make your life easier. Come see some of the new 9.5 features in action and learn how this next release will make your life better.

Lecture 14. Glycobiology.

Gregory Alan Weiss
UCI Chem 128 Introduction to Chemical Biology (Winter 2013) Instructor: Gregory Weiss, Ph.D. Description: Introduction to the basic principles of chemical biology: structures and reactivity; chemical mechanisms of enzyme catalysis; chemistry of signaling, biosynthesis, and metabolic pathways. Index of Topics: 0:02:04 Enzyme Functions 0:06:10 Serine Based Proteases 0:10:44 Protein Based Inhibition of Proteases 0:13:10 Covalent or Mechanism-Based Protease Inhibitors 0:15:02 Inhibition of Serine Esterases 0:17:07 Enzymes Use Co-Factors (Vitamins) 0:21:31 The Origins of Stereospecificity in...

Lecture 04. Combinatorial Chemistry and Biology.

Gregory Alan Weiss
UCI Chem 128 Introduction to Chemical Biology (Winter 2013) Instructor: Gregory Weiss, Ph.D. Description: Introduction to the basic principles of chemical biology: structures and reactivity; chemical mechanisms of enzyme catalysis; chemistry of signaling, biosynthesis, and metabolic pathways. Index of Topics: 0:28:06 MO Theory 0:32:32 Do Not Use Curved Arrows for Hydrogen Bonds 0:34:00 The Molecules of Life on Earth 0:37:40 Chemistry of CN 0:50:27 Formation of DAMN 0:53:32 Prebiotic Synthesis 1:06:29 Oligomers of Nucleotide Subunits...

Lecture 03. Reactivity and Arrow Pushing.

Gregory Alan Weiss
UCI Chem 128 Introduction to Chemical Biology (Winter 2013) Instructor: Gregory Weiss, Ph.D. Description: Introduction to the basic principles of chemical biology: structures and reactivity; chemical mechanisms of enzyme catalysis; chemistry of signaling, biosynthesis, and metabolic pathways. Index of Topics: 0:07:01 What is Life? 0:09:07 Arrows Depict the Overlap of Molecular Orbitals 0:19:57 The Three Components of Orbital Overlap 0:24:27 Charge-Charge or Coulombic Effects 0:26:31 Molecular Orbital Theory Explains the Otherwise Unexplained 0:28:05 Combining Atomic...

Simulation F00 - Strain rates

Florian Steinbach, Paul D. Bons, Albert Griera, Daniela Jansen, Maria-Gema Llorens, Jens Roessiger & Ilka Weikusat
This video shows the von Mises strain rates in a numerical simulation of polycrystalline ice under the influence of pure shear deformation and dynamic recrystallisation. Supplementary material to Steinbach et al.: Strain localisation and dynamic recrystallisation in the ice-air aggregate: A numerical study, The Cryosphere, 2016.

Lecture 07. Tunneling Microscopy and Vibrations

Athan J. Shaka
UCI Chem 131A Quantum Principles (Winter 2014) Instructor: A.J. Shaka, Ph.D Description: This course provides an introduction to quantum mechanics and principles of quantum chemistry with applications to nuclear motions and the electronic structure of the hydrogen atom. It also examines the Schrödinger equation and study how it describes the behavior of very light particles, the quantum description of rotating and vibrating molecules is compared to the classical description, and the quantum description of the...

Lecture 05. Model 1D Quantum Systems: The \"Particle in a Box\"

Athan J. Shaka
UCI Chem 131A Quantum Principles (Winter 2014) Instructor: A.J. Shaka, Ph.D Description: This course provides an introduction to quantum mechanics and principles of quantum chemistry with applications to nuclear motions and the electronic structure of the hydrogen atom. It also examines the Schrödinger equation and study how it describes the behavior of very light particles, the quantum description of rotating and vibrating molecules is compared to the classical description, and the quantum description of the...

DDoS protection technology is far from being \"install & forget\"

Jochanan Sommerfeld
Each of these techniques can then also be deployed in few different ways. Both, protection techniques and deployment architectures will obviously affect the quality of protection while under attack. Although many organizations are failing with DDoS protection, I would say, that most of today's attacks can be successfully mitigated. But don't get me wrong, an effective mitigation requires good understanding on how the technology operates plus a deep knowledge of your network and the applications...

Post-its, post-its, post-its everywhere (and how they relate to physical keys)

Jos Weyers
A password shouldnt be on a post-it note. In plain view. On the console. The password to a locked door is called a key. So if a reporter wants to get the point across that certain people shouldn't have access to a particular key, would it be wise for said reporter to show that key to the world? This talk show how not to run this story, why we should care and maybe make you...

Mining for Bugs with Graph Database Queries

Fabian Yamaguchi
While graph databases are primarily known as the backbone of the modern dating world, this nerd has found a much more interesting application for them: program analysis. This talk aims to demonstrate that graph databases and the typical program representations developed in compiler construction are a match made in heaven, allowing large code bases to be mined for vulnerabilities using complex bug descriptions encoded in simple, and not so simple graph database queries. This talk...

Shall we play a game?

Tamás Szakály
Everybody plays games, and a bunch of us plays computer games. Despite this, very few of usconsider them as interesting targets. Granted, you won't likely be able to hack into a corporate network via games, but you can target the people running the company via their games. You should also consider that a game could grant Not So Admirable people access to your network - the network that all your phones, your cameras, and your...

Otti Csaba: Security in our hands (?)

András Fehér, Sándor Kapitány & Dániel Martinkovics
A kézgeometria azonosítás egy széles körben elterjedt és használható technológia, amely bizonyos esetekben hatékonyan képes helyettesíteni a környezeti körülményekkel szemben kevésbé ellenálló társait, ugyanakkor kevesen tudják csak azt, hogy valójában hogyan muködik. Élo bemutatónk keretében megvizsgáljuk a technológia elonyeit, hátrányait, felfedjük sebezhetoségeit, és olyan támadásokat hajtunk végre, amelyek túlmutatnak magán a technológián.

Introducing disc lock opening tools and methods

Váradi Tamás
Mivel a mai zárak legjobbikáról beszélünk, érdemes vizsgálni, hogy a tárcsás zárakkal szerelt lakatok, kerékpár- és motorlakatok, cilinderzárak mind-mind a legmagasabb biztonsági kategóriába tartoznak, és nem utolsósorban a legdrágább zárószerkezeteknek számítanak. Megfelelő speciális szerszámmal és technikával, valamint nem kevés gyakorlással azonban ezek a zárak tervezhető időtartamon belül nyithatók, és a módszer megfelelő tematika mellett elsajátítható. A nyitóeszközök bemutatása mellett belepillantást engedek a módszerbe a tárcsás zárak kategóriáinak bemutatásán keresztül.

Understanding PostgreSQL timelines

Heikki Linnakangas
Whenever you perform point-in-time-recovery or failover in PostgreSQL, a new timeline is created. In the best case, timelines help you stay sane in complicated recovery situations and keep your database consistent. In the worst case, they will thoroughly confuse you. This talk explains timelines, how they are used by the system, and how you can stay sane with them and even take advantage of them. Version 9.3 brings some improvements to the handling of timelines,...

Billion Tables Project (BTP)

Álvaro Hernández Tortosa & José Luis Tallón
Aka how long a "\dt" takes on a 1B tables database Usually "large" databases are considered as such for the high number of records they hold, reaching billions or even more than that. But what about creating a billion... tables? Sometime ago, this apparently crazy question was found in a database soup (http://it.toolbox.com/blogs/database-soup/one-billion-tables-or-bust-46270). It may not be your day-to-day task, but the task of creating them exposes some topics about PostgreSQL internals, performance and large...

Registration Year

  • 2016
    2,694

Resource Types

  • Audiovisual
    2,395