�ݺ�ߣshows by User: citus

�ݺ�ߣshows by User: citus_data / http://www.slideshare.net/images/logo.gif �ݺ�ߣshows by User: citus_data / Thu, 26 Mar 2020 00:49:26 GMT �ݺ�ߣShare feed for �ݺ�ߣshows by User: citus_data Architecting peta-byte-scale analytics by scaling out Postgres on Azure with CItus | Devops Meetup Zurich | Alicja Kucharczyk /slideshow/architecting-petabytescale-analytics-by-scaling-out-postgres-on-azure-with-citus-devops-meetup-zurich-alicja-kucharczyk/230868643 citushyperscale-meetupzurich2020-03-04-200326004926
A story about powering a 1.5 petabyte internal analytics application at Microsoft with 2816 cores and 18.7 TB of memory in the Citus cluster. The internal RQV analytics dashboard at Microsoft helps the Windows team to assess the quality of upcoming Windows releases. The system tracks 20,000 diagnostic and quality metrics, digests data from 800 million Windows devices and currently supports over 6 million queries per day, with hundreds of concurrent users. The RQV analytics dashboard relies on Postgres—along with the Citus extension to Postgres to scale out horizontally—and is deployed on Microsoft Azure. ]]>
A story about powering a 1.5 petabyte internal analytics application at Microsoft with 2816 cores and 18.7 TB of memory in the Citus cluster. The internal RQV analytics dashboard at Microsoft helps the Windows team to assess the quality of upcoming Windows releases. The system tracks 20,000 diagnostic and quality metrics, digests data from 800 million Windows devices and currently supports over 6 million queries per day, with hundreds of concurrent users. The RQV analytics dashboard relies on Postgres—along with the Citus extension to Postgres to scale out horizontally—and is deployed on Microsoft Azure. ]]> Thu, 26 Mar 2020 00:49:26 GMT /slideshow/architecting-petabytescale-analytics-by-scaling-out-postgres-on-azure-with-citus-devops-meetup-zurich-alicja-kucharczyk/230868643 citus_data@slideshare.net(citus_data) Architecting peta-byte-scale analytics by scaling out Postgres on Azure with CItus | Devops Meetup Zurich | Alicja Kucharczyk citus_data A story about powering a 1.5 petabyte internal analytics application at Microsoft with 2816 cores and 18.7 TB of memory in the Citus cluster. The internal RQV analytics dashboard at Microsoft helps the Windows team to assess the quality of upcoming Windows releases. The system tracks 20,000 diagnostic and quality metrics, digests data from 800 million Windows devices and currently supports over 6 million queries per day, with hundreds of concurrent users. The RQV analytics dashboard relies on Postgres—along with the Citus extension to Postgres to scale out horizontally—and is deployed on Microsoft Azure. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/citushyperscale-meetupzurich2020-03-04-200326004926-thumbnail.jpg?width=120&height=120&fit=bounds" /> A story about powering a 1.5 petabyte internal analytics application at Microsoft with 2816 cores and 18.7 TB of memory in the Citus cluster. The internal RQV analytics dashboard at Microsoft helps the Windows team to assess the quality of upcoming Windows releases. The system tracks 20,000 diagnostic and quality metrics, digests data from 800 million Windows devices and currently supports over 6 million queries per day, with hundreds of concurrent users. The RQV analytics dashboard relies on Postgres—along with the Citus extension to Postgres to scale out horizontally—and is deployed on Microsoft Azure.

Architecting peta-byte-scale analytics by scaling out Postgres on Azure with CItus | Devops Meetup Zurich | Alicja Kucharczyk from Citus Data

]]> 612 0 https://cdn.slidesharecdn.com/ss_thumbnails/citushyperscale-meetupzurich2020-03-04-200326004926-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Data Modeling, Normalization, and De-Normalization | PostgresOpen 2019 | Dimitri Fontaine /slideshow/data-modeling-normalization-and-denormalization-postgresopen-2019-dimitri-fontaine/214409388 datamodeling-200103001754
As a developer using PostgreSQL one of the most important tasks you have to deal with is modeling the database schema for your application. In order to achieve a solid design, it’s important to understand how the schema is then going to be used as well as the trade-offs it involves. As Fred Brooks said: “Show me your flowcharts and conceal your tables, and I shall continue to be mystified. Show me your tables, and I won’t usually need your flowcharts; they’ll be obvious.” In this talk we're going to see practical normalisation examples and their benefits, and also review some anti-patterns and their typical PostgreSQL solutions, including Denormalization techniques thanks to advanced Data Types.]]>
As a developer using PostgreSQL one of the most important tasks you have to deal with is modeling the database schema for your application. In order to achieve a solid design, it’s important to understand how the schema is then going to be used as well as the trade-offs it involves. As Fred Brooks said: “Show me your flowcharts and conceal your tables, and I shall continue to be mystified. Show me your tables, and I won’t usually need your flowcharts; they’ll be obvious.” In this talk we're going to see practical normalisation examples and their benefits, and also review some anti-patterns and their typical PostgreSQL solutions, including Denormalization techniques thanks to advanced Data Types.]]> Fri, 03 Jan 2020 00:17:54 GMT /slideshow/data-modeling-normalization-and-denormalization-postgresopen-2019-dimitri-fontaine/214409388 citus_data@slideshare.net(citus_data) Data Modeling, Normalization, and De-Normalization | PostgresOpen 2019 | Dimitri Fontaine citus_data As a developer using PostgreSQL one of the most important tasks you have to deal with is modeling the database schema for your application. In order to achieve a solid design, it’s important to understand how the schema is then going to be used as well as the trade-offs it involves. As Fred Brooks said: “Show me your flowcharts and conceal your tables, and I shall continue to be mystified. Show me your tables, and I won’t usually need your flowcharts; they’ll be obvious.” In this talk we're going to see practical normalisation examples and their benefits, and also review some anti-patterns and their typical PostgreSQL solutions, including Denormalization techniques thanks to advanced Data Types. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/datamodeling-200103001754-thumbnail.jpg?width=120&height=120&fit=bounds" /> As a developer using PostgreSQL one of the most important tasks you have to deal with is modeling the database schema for your application. In order to achieve a solid design, it’s important to understand how the schema is then going to be used as well as the trade-offs it involves. As Fred Brooks said: “Show me your flowcharts and conceal your tables, and I shall continue to be mystified. Show me your tables, and I won’t usually need your flowcharts; they’ll be obvious.” In this talk we're going to see practical normalisation examples and their benefits, and also review some anti-patterns and their typical PostgreSQL solutions, including Denormalization techniques thanks to advanced Data Types.

Data Modeling, Normalization, and De-Normalization | PostgresOpen 2019 | Dimitri Fontaine from Citus Data

]]> 236 1 https://cdn.slidesharecdn.com/ss_thumbnails/datamodeling-200103001754-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 JSONB Tricks: Operators, Indexes, and When (Not) to Use It | PostgresOpen 2019 | Colton Shepard /slideshow/jsonb-tricks-operators-indexes-and-when-not-to-use-it-postgresopen-2019-colton-shepard/214407886 jsonbpresentation1-200103001056
When do you use jsonb, and when don’t you? How do you make it fast? What operators are available, and what can they do? How will this change? These are all very good questions, but jsonb support in Postgres moves so fast that it’s hard to keep up. In this talk, you will get details on these topics, complete with practical examples and real-world stories: - When to use jsonb, what it’s good for, and when to not use it - Operators and how to use them effectively - Indexing, operator support for indexes, and the tradeoffs involved - Postgres 12 improvements and new features]]>
When do you use jsonb, and when don’t you? How do you make it fast? What operators are available, and what can they do? How will this change? These are all very good questions, but jsonb support in Postgres moves so fast that it’s hard to keep up. In this talk, you will get details on these topics, complete with practical examples and real-world stories: - When to use jsonb, what it’s good for, and when to not use it - Operators and how to use them effectively - Indexing, operator support for indexes, and the tradeoffs involved - Postgres 12 improvements and new features]]> Fri, 03 Jan 2020 00:10:56 GMT /slideshow/jsonb-tricks-operators-indexes-and-when-not-to-use-it-postgresopen-2019-colton-shepard/214407886 citus_data@slideshare.net(citus_data) JSONB Tricks: Operators, Indexes, and When (Not) to Use It | PostgresOpen 2019 | Colton Shepard citus_data When do you use jsonb, and when don’t you? How do you make it fast? What operators are available, and what can they do? How will this change? These are all very good questions, but jsonb support in Postgres moves so fast that it’s hard to keep up. In this talk, you will get details on these topics, complete with practical examples and real-world stories: - When to use jsonb, what it’s good for, and when to not use it - Operators and how to use them effectively - Indexing, operator support for indexes, and the tradeoffs involved - Postgres 12 improvements and new features <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/jsonbpresentation1-200103001056-thumbnail.jpg?width=120&height=120&fit=bounds" /> When do you use jsonb, and when don’t you? How do you make it fast? What operators are available, and what can they do? How will this change? These are all very good questions, but jsonb support in Postgres moves so fast that it’s hard to keep up. In this talk, you will get details on these topics, complete with practical examples and real-world stories: - When to use jsonb, what it’s good for, and when to not use it - Operators and how to use them effectively - Indexing, operator support for indexes, and the tradeoffs involved - Postgres 12 improvements and new features

JSONB Tricks: Operators, Indexes, and When (Not) to Use It | PostgresOpen 2019 | Colton Shepard from Citus Data

]]> 351 0 https://cdn.slidesharecdn.com/ss_thumbnails/jsonbpresentation1-200103001056-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Tutorial: Implementing your first Postgres extension | PGConf EU 2019 | Burak Yucesoy, Onder Kalaci /citus_data/tutorial-implementing-your-first-postgres-extension-pgconf-eu-2019-burak-yucesoy-onder-kalaci implementingyourfirstpostgresqlextension-200102233539
One of the strongest features of any database is its extensibility and PostgreSQL comes with a rich extension API. It allows you to define new functions, types, and operators. It even allows you to modify some of its core parts like planner, executor or storage engine. You read it right, you can even change the behavior of PostgreSQL planner. How cool is that? Such freedom in extensibility created strong extension community around PostgreSQL and made way for a vast amount of extensions such as pg_stat_statements, citus, postgresql-hll and many more. In this tutorial, we will look at how you can create your own PostgreSQL extension. We will start with more common stuff like defining new functions and types but gradually explore less known parts of the PostgreSQL's extension API like C level hooks which lets you change the behavior of planner, executor and other core parts of the PostgreSQL. We will see how to code, debug, compile and test our extension. After that, we will also look into how to package and distribute our extension for other people to use. To get the best benefit from the tutorial, C and SQL knowledge would be beneficial. Some knowledge on PostgreSQL internals would also be useful but we will cover the necessary details, so it is not necessary.]]>
One of the strongest features of any database is its extensibility and PostgreSQL comes with a rich extension API. It allows you to define new functions, types, and operators. It even allows you to modify some of its core parts like planner, executor or storage engine. You read it right, you can even change the behavior of PostgreSQL planner. How cool is that? Such freedom in extensibility created strong extension community around PostgreSQL and made way for a vast amount of extensions such as pg_stat_statements, citus, postgresql-hll and many more. In this tutorial, we will look at how you can create your own PostgreSQL extension. We will start with more common stuff like defining new functions and types but gradually explore less known parts of the PostgreSQL's extension API like C level hooks which lets you change the behavior of planner, executor and other core parts of the PostgreSQL. We will see how to code, debug, compile and test our extension. After that, we will also look into how to package and distribute our extension for other people to use. To get the best benefit from the tutorial, C and SQL knowledge would be beneficial. Some knowledge on PostgreSQL internals would also be useful but we will cover the necessary details, so it is not necessary.]]> Thu, 02 Jan 2020 23:35:39 GMT /citus_data/tutorial-implementing-your-first-postgres-extension-pgconf-eu-2019-burak-yucesoy-onder-kalaci citus_data@slideshare.net(citus_data) Tutorial: Implementing your first Postgres extension | PGConf EU 2019 | Burak Yucesoy, Onder Kalaci citus_data One of the strongest features of any database is its extensibility and PostgreSQL comes with a rich extension API. It allows you to define new functions, types, and operators. It even allows you to modify some of its core parts like planner, executor or storage engine. You read it right, you can even change the behavior of PostgreSQL planner. How cool is that? Such freedom in extensibility created strong extension community around PostgreSQL and made way for a vast amount of extensions such as pg_stat_statements, citus, postgresql-hll and many more. In this tutorial, we will look at how you can create your own PostgreSQL extension. We will start with more common stuff like defining new functions and types but gradually explore less known parts of the PostgreSQL's extension API like C level hooks which lets you change the behavior of planner, executor and other core parts of the PostgreSQL. We will see how to code, debug, compile and test our extension. After that, we will also look into how to package and distribute our extension for other people to use. To get the best benefit from the tutorial, C and SQL knowledge would be beneficial. Some knowledge on PostgreSQL internals would also be useful but we will cover the necessary details, so it is not necessary. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/implementingyourfirstpostgresqlextension-200102233539-thumbnail.jpg?width=120&height=120&fit=bounds" /> One of the strongest features of any database is its extensibility and PostgreSQL comes with a rich extension API. It allows you to define new functions, types, and operators. It even allows you to modify some of its core parts like planner, executor or storage engine. You read it right, you can even change the behavior of PostgreSQL planner. How cool is that? Such freedom in extensibility created strong extension community around PostgreSQL and made way for a vast amount of extensions such as pg_stat_statements, citus, postgresql-hll and many more. In this tutorial, we will look at how you can create your own PostgreSQL extension. We will start with more common stuff like defining new functions and types but gradually explore less known parts of the PostgreSQL's extension API like C level hooks which lets you change the behavior of planner, executor and other core parts of the PostgreSQL. We will see how to code, debug, compile and test our extension. After that, we will also look into how to package and distribute our extension for other people to use. To get the best benefit from the tutorial, C and SQL knowledge would be beneficial. Some knowledge on PostgreSQL internals would also be useful but we will cover the necessary details, so it is not necessary.

Tutorial: Implementing your first Postgres extension | PGConf EU 2019 | Burak Yucesoy, Onder Kalaci from Citus Data

]]> 234 1 https://cdn.slidesharecdn.com/ss_thumbnails/implementingyourfirstpostgresqlextension-200102233539-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Whats wrong with postgres | PGConf EU 2019 | Craig Kerstiens /slideshow/whats-wrong-with-postgres-pgconf-eu-2019-craig-kerstiens/214397821 whatswrongwithpostgres-200102232510
Postgres is a powerful database, it continues to improve in terms of performance, extensibility, and more broadly in features. However it is not perfect. Here I'll cover a highly opinionated view of all the areas Postgres falls flat, with some rough thought ideas on how we can make it better. Opinions are all informed by 10 years of interacting with customers running literally millions of databases for users.]]>
Postgres is a powerful database, it continues to improve in terms of performance, extensibility, and more broadly in features. However it is not perfect. Here I'll cover a highly opinionated view of all the areas Postgres falls flat, with some rough thought ideas on how we can make it better. Opinions are all informed by 10 years of interacting with customers running literally millions of databases for users.]]> Thu, 02 Jan 2020 23:25:10 GMT /slideshow/whats-wrong-with-postgres-pgconf-eu-2019-craig-kerstiens/214397821 citus_data@slideshare.net(citus_data) Whats wrong with postgres | PGConf EU 2019 | Craig Kerstiens citus_data Postgres is a powerful database, it continues to improve in terms of performance, extensibility, and more broadly in features. However it is not perfect. Here I'll cover a highly opinionated view of all the areas Postgres falls flat, with some rough thought ideas on how we can make it better. Opinions are all informed by 10 years of interacting with customers running literally millions of databases for users. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/whatswrongwithpostgres-200102232510-thumbnail.jpg?width=120&height=120&fit=bounds" /> Postgres is a powerful database, it continues to improve in terms of performance, extensibility, and more broadly in features. However it is not perfect. Here I'll cover a highly opinionated view of all the areas Postgres falls flat, with some rough thought ideas on how we can make it better. Opinions are all informed by 10 years of interacting with customers running literally millions of databases for users.

Whats wrong with postgres | PGConf EU 2019 | Craig Kerstiens from Citus Data

]]> 212 0 https://cdn.slidesharecdn.com/ss_thumbnails/whatswrongwithpostgres-200102232510-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 When it all goes wrong | PGConf EU 2019 | Will Leinweber /slideshow/when-it-all-goes-wrong-pgconf-eu-2019-will-leinweber/186417514 2019-10-17whenpostgresgoeswrongpgconfeu-191024205533
You're woken up in the middle of the night to your phone. Your app is down and you're on call to fix it. Eventually you track it down to "something with the db," but what exactly is wrong? And of course, you're sure that nothing changed recently… Knowing what to fix, and even where to start looking, is a skill that takes a long time to develop. Especially since Postgres normally works very well for months at a time, not letting you get practice! In this talk, I'll share not only the more common failure cases and how to fix them, but also a general approach to efficiently figuring out what's wrong in the first place.]]>
You're woken up in the middle of the night to your phone. Your app is down and you're on call to fix it. Eventually you track it down to "something with the db," but what exactly is wrong? And of course, you're sure that nothing changed recently… Knowing what to fix, and even where to start looking, is a skill that takes a long time to develop. Especially since Postgres normally works very well for months at a time, not letting you get practice! In this talk, I'll share not only the more common failure cases and how to fix them, but also a general approach to efficiently figuring out what's wrong in the first place.]]> Thu, 24 Oct 2019 20:55:33 GMT /slideshow/when-it-all-goes-wrong-pgconf-eu-2019-will-leinweber/186417514 citus_data@slideshare.net(citus_data) When it all goes wrong | PGConf EU 2019 | Will Leinweber citus_data You're woken up in the middle of the night to your phone. Your app is down and you're on call to fix it. Eventually you track it down to "something with the db," but what exactly is wrong? And of course, you're sure that nothing changed recently… Knowing what to fix, and even where to start looking, is a skill that takes a long time to develop. Especially since Postgres normally works very well for months at a time, not letting you get practice! In this talk, I'll share not only the more common failure cases and how to fix them, but also a general approach to efficiently figuring out what's wrong in the first place. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/2019-10-17whenpostgresgoeswrongpgconfeu-191024205533-thumbnail.jpg?width=120&height=120&fit=bounds" /> You're woken up in the middle of the night to your phone. Your app is down and you're on call to fix it. Eventually you track it down to "something with the db," but what exactly is wrong? And of course, you're sure that nothing changed recently… Knowing what to fix, and even where to start looking, is a skill that takes a long time to develop. Especially since Postgres normally works very well for months at a time, not letting you get practice! In this talk, I'll share not only the more common failure cases and how to fix them, but also a general approach to efficiently figuring out what's wrong in the first place.

When it all goes wrong | PGConf EU 2019 | Will Leinweber from Citus Data

]]> 175 0 https://cdn.slidesharecdn.com/ss_thumbnails/2019-10-17whenpostgresgoeswrongpgconfeu-191024205533-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Amazing SQL your ORM can (or can't) do | PGConf EU 2019 | Louise Grandjonc /slideshow/amazing-sql-your-orm-can-or-cant-do-pgconf-eu-2019-louise-grandjonc/186416484 pgconfeu2019-191024205237
SQL can seem like an obscure and complex but powerful language. Learning it can be intimidating. As a developer, we can easily be tempted using basic SQL provided by the ORM. But did you know that you can use window functions in some ORMs? Same goes for a lot of other fun SQL functionalities. In this talk we will explore some advanced SQL features that you might find useful. We will discover the wonderful world of joins (lateral, cross…), subqueries, grouping sets, window functions, common table expressions. But most importantly this talk is not only a talk to show you how great SQL is. This talk is here to show you how to use it in real life. What are the features supported by your ORM? And how can you use them if they don’t support them? Wether you know SQL or not, whether you are a developer or a DBA working with developers, you might learn a lot about SQL, ORMs, and application development using Postgres.]]>
SQL can seem like an obscure and complex but powerful language. Learning it can be intimidating. As a developer, we can easily be tempted using basic SQL provided by the ORM. But did you know that you can use window functions in some ORMs? Same goes for a lot of other fun SQL functionalities. In this talk we will explore some advanced SQL features that you might find useful. We will discover the wonderful world of joins (lateral, cross…), subqueries, grouping sets, window functions, common table expressions. But most importantly this talk is not only a talk to show you how great SQL is. This talk is here to show you how to use it in real life. What are the features supported by your ORM? And how can you use them if they don’t support them? Wether you know SQL or not, whether you are a developer or a DBA working with developers, you might learn a lot about SQL, ORMs, and application development using Postgres.]]> Thu, 24 Oct 2019 20:52:37 GMT /slideshow/amazing-sql-your-orm-can-or-cant-do-pgconf-eu-2019-louise-grandjonc/186416484 citus_data@slideshare.net(citus_data) Amazing SQL your ORM can (or can't) do | PGConf EU 2019 | Louise Grandjonc citus_data SQL can seem like an obscure and complex but powerful language. Learning it can be intimidating. As a developer, we can easily be tempted using basic SQL provided by the ORM. But did you know that you can use window functions in some ORMs? Same goes for a lot of other fun SQL functionalities. In this talk we will explore some advanced SQL features that you might find useful. We will discover the wonderful world of joins (lateral, cross…), subqueries, grouping sets, window functions, common table expressions. But most importantly this talk is not only a talk to show you how great SQL is. This talk is here to show you how to use it in real life. What are the features supported by your ORM? And how can you use them if they don’t support them? Wether you know SQL or not, whether you are a developer or a DBA working with developers, you might learn a lot about SQL, ORMs, and application development using Postgres. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/pgconfeu2019-191024205237-thumbnail.jpg?width=120&height=120&fit=bounds" /> SQL can seem like an obscure and complex but powerful language. Learning it can be intimidating. As a developer, we can easily be tempted using basic SQL provided by the ORM. But did you know that you can use window functions in some ORMs? Same goes for a lot of other fun SQL functionalities. In this talk we will explore some advanced SQL features that you might find useful. We will discover the wonderful world of joins (lateral, cross…), subqueries, grouping sets, window functions, common table expressions. But most importantly this talk is not only a talk to show you how great SQL is. This talk is here to show you how to use it in real life. What are the features supported by your ORM? And how can you use them if they don’t support them? Wether you know SQL or not, whether you are a developer or a DBA working with developers, you might learn a lot about SQL, ORMs, and application development using Postgres.

Amazing SQL your ORM can (or can't) do | PGConf EU 2019 | Louise Grandjonc from Citus Data

]]> 288 3 https://cdn.slidesharecdn.com/ss_thumbnails/pgconfeu2019-191024205237-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 What Microsoft is doing with Postgres & the Citus Data acquisition | PGConf EU 2019 | Utku Azman /slideshow/what-microsoft-is-doing-with-postgres-the-citus-data-acquisition-pgconf-eu-2019-utku-azman/186415050 pgconfeukeynotemicrosoft-191024204830
Many people have asked us: “Why did Microsoft acquire Citus Data?” and “What do you plan to do with the Citus open source extension to Postgres?” Come join us to see the exciting work we are doing with Postgres and open source at Microsoft.]]>
Many people have asked us: “Why did Microsoft acquire Citus Data?” and “What do you plan to do with the Citus open source extension to Postgres?” Come join us to see the exciting work we are doing with Postgres and open source at Microsoft.]]> Thu, 24 Oct 2019 20:48:29 GMT /slideshow/what-microsoft-is-doing-with-postgres-the-citus-data-acquisition-pgconf-eu-2019-utku-azman/186415050 citus_data@slideshare.net(citus_data) What Microsoft is doing with Postgres & the Citus Data acquisition | PGConf EU 2019 | Utku Azman citus_data Many people have asked us: “Why did Microsoft acquire Citus Data?” and “What do you plan to do with the Citus open source extension to Postgres?” Come join us to see the exciting work we are doing with Postgres and open source at Microsoft. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/pgconfeukeynotemicrosoft-191024204830-thumbnail.jpg?width=120&height=120&fit=bounds" /> Many people have asked us: “Why did Microsoft acquire Citus Data?” and “What do you plan to do with the Citus open source extension to Postgres?” Come join us to see the exciting work we are doing with Postgres and open source at Microsoft.

What Microsoft is doing with Postgres & the Citus Data acquisition | PGConf EU 2019 | Utku Azman from Citus Data

]]> 403 0 https://cdn.slidesharecdn.com/ss_thumbnails/pgconfeukeynotemicrosoft-191024204830-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Deep Postgres Extensions in Rust | PGCon 2019 | Jeff Davis /slideshow/deep-postgres-extensions-in-rust-pgcon-2019-jeff-davis/167853721 532rusttalk-190831011515
Postgres relies heavily on an extension ecosystem, but that is almost 100% dependent on C; which cuts out developers, libraries, and ideas from the world of Postgres. postgres-extension.rs changes that by supporting development of extensions in Rust. Rust is a memory-safe language that integrates nicely in any environment, has powerful libraries, a vibrant ecosystem, and a prolific developer community. Rust is a unique language because it supports high-level features but all the magic happens at compile-time, and the resulting code is not dependent on an intrusive or bulky runtime. That makes it ideal for integrating with postgres, which has a lot of its own runtime, like memory contexts and signal handlers. postgres-extension.rs offers this integration, allowing the development of extensions in rust, even if deeply-integrated into the postgres internals, and helping handle tricky issues like error handling. This is done through a collection of Rust function declarations, macros, and utility functions that allow rust code to call into postgres, and safely handle resulting errors.]]>
Postgres relies heavily on an extension ecosystem, but that is almost 100% dependent on C; which cuts out developers, libraries, and ideas from the world of Postgres. postgres-extension.rs changes that by supporting development of extensions in Rust. Rust is a memory-safe language that integrates nicely in any environment, has powerful libraries, a vibrant ecosystem, and a prolific developer community. Rust is a unique language because it supports high-level features but all the magic happens at compile-time, and the resulting code is not dependent on an intrusive or bulky runtime. That makes it ideal for integrating with postgres, which has a lot of its own runtime, like memory contexts and signal handlers. postgres-extension.rs offers this integration, allowing the development of extensions in rust, even if deeply-integrated into the postgres internals, and helping handle tricky issues like error handling. This is done through a collection of Rust function declarations, macros, and utility functions that allow rust code to call into postgres, and safely handle resulting errors.]]> Sat, 31 Aug 2019 01:15:15 GMT /slideshow/deep-postgres-extensions-in-rust-pgcon-2019-jeff-davis/167853721 citus_data@slideshare.net(citus_data) Deep Postgres Extensions in Rust | PGCon 2019 | Jeff Davis citus_data Postgres relies heavily on an extension ecosystem, but that is almost 100% dependent on C; which cuts out developers, libraries, and ideas from the world of Postgres. postgres-extension.rs changes that by supporting development of extensions in Rust. Rust is a memory-safe language that integrates nicely in any environment, has powerful libraries, a vibrant ecosystem, and a prolific developer community. Rust is a unique language because it supports high-level features but all the magic happens at compile-time, and the resulting code is not dependent on an intrusive or bulky runtime. That makes it ideal for integrating with postgres, which has a lot of its own runtime, like memory contexts and signal handlers. postgres-extension.rs offers this integration, allowing the development of extensions in rust, even if deeply-integrated into the postgres internals, and helping handle tricky issues like error handling. This is done through a collection of Rust function declarations, macros, and utility functions that allow rust code to call into postgres, and safely handle resulting errors. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/532rusttalk-190831011515-thumbnail.jpg?width=120&height=120&fit=bounds" /> Postgres relies heavily on an extension ecosystem, but that is almost 100% dependent on C; which cuts out developers, libraries, and ideas from the world of Postgres. postgres-extension.rs changes that by supporting development of extensions in Rust. Rust is a memory-safe language that integrates nicely in any environment, has powerful libraries, a vibrant ecosystem, and a prolific developer community. Rust is a unique language because it supports high-level features but all the magic happens at compile-time, and the resulting code is not dependent on an intrusive or bulky runtime. That makes it ideal for integrating with postgres, which has a lot of its own runtime, like memory contexts and signal handlers. postgres-extension.rs offers this integration, allowing the development of extensions in rust, even if deeply-integrated into the postgres internals, and helping handle tricky issues like error handling. This is done through a collection of Rust function declarations, macros, and utility functions that allow rust code to call into postgres, and safely handle resulting errors.

Deep Postgres Extensions in Rust | PGCon 2019 | Jeff Davis from Citus Data

]]> 288 1 https://cdn.slidesharecdn.com/ss_thumbnails/532rusttalk-190831011515-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Why Postgres Why This Database Why Now | SF Bay Area Postgres Meetup | Claire Giordano /slideshow/why-postgres-why-this-database-why-now-sf-bay-area-postgres-meetup-claire-giordano/167852974 why-postgresql-why-this-database-why-now-sfbayareapostgres-23july2019-claire-giordano-microsoft1-190831010252
I spent the early part of my career working on developer tools, operating systems, high-speed file systems, and scale-out storage. Not databases. Frankly, I always thought that databases were a bit boring. So almost 2 years in to my new job at a Postgres company, I continue to be amazed at the enthusiasm of the PostgreSQL developer community and users. I mean, people’s eyes light up when you ask them why they love Postgres. Sure, a lot of us get animated when talking about our newest gadget, or Ronaldo’s phenomenal free-kick goal in the World Cup, or mint chip gelato from La Strega Nocciola—but most platform software simply doesn’t trigger this kind of passion. So why does Postgres? Why is this open source database having such a “moment”? Well, I’ve been trying to understand, looking at this “Postgres moment” from a few different angles. In this talk I’ll share what I’ve observed to be the top 10 business, technology, and community reasons so many of you have so much affection for PostgreSQL.]]>
I spent the early part of my career working on developer tools, operating systems, high-speed file systems, and scale-out storage. Not databases. Frankly, I always thought that databases were a bit boring. So almost 2 years in to my new job at a Postgres company, I continue to be amazed at the enthusiasm of the PostgreSQL developer community and users. I mean, people’s eyes light up when you ask them why they love Postgres. Sure, a lot of us get animated when talking about our newest gadget, or Ronaldo’s phenomenal free-kick goal in the World Cup, or mint chip gelato from La Strega Nocciola—but most platform software simply doesn’t trigger this kind of passion. So why does Postgres? Why is this open source database having such a “moment”? Well, I’ve been trying to understand, looking at this “Postgres moment” from a few different angles. In this talk I’ll share what I’ve observed to be the top 10 business, technology, and community reasons so many of you have so much affection for PostgreSQL.]]> Sat, 31 Aug 2019 01:02:52 GMT /slideshow/why-postgres-why-this-database-why-now-sf-bay-area-postgres-meetup-claire-giordano/167852974 citus_data@slideshare.net(citus_data) Why Postgres Why This Database Why Now | SF Bay Area Postgres Meetup | Claire Giordano citus_data I spent the early part of my career working on developer tools, operating systems, high-speed file systems, and scale-out storage. Not databases. Frankly, I always thought that databases were a bit boring. So almost 2 years in to my new job at a Postgres company, I continue to be amazed at the enthusiasm of the PostgreSQL developer community and users. I mean, people’s eyes light up when you ask them why they love Postgres. Sure, a lot of us get animated when talking about our newest gadget, or Ronaldo’s phenomenal free-kick goal in the World Cup, or mint chip gelato from La Strega Nocciola—but most platform software simply doesn’t trigger this kind of passion. So why does Postgres? Why is this open source database having such a “moment”? Well, I’ve been trying to understand, looking at this “Postgres moment” from a few different angles. In this talk I’ll share what I’ve observed to be the top 10 business, technology, and community reasons so many of you have so much affection for PostgreSQL. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/why-postgresql-why-this-database-why-now-sfbayareapostgres-23july2019-claire-giordano-microsoft1-190831010252-thumbnail.jpg?width=120&height=120&fit=bounds" /> I spent the early part of my career working on developer tools, operating systems, high-speed file systems, and scale-out storage. Not databases. Frankly, I always thought that databases were a bit boring. So almost 2 years in to my new job at a Postgres company, I continue to be amazed at the enthusiasm of the PostgreSQL developer community and users. I mean, people’s eyes light up when you ask them why they love Postgres. Sure, a lot of us get animated when talking about our newest gadget, or Ronaldo’s phenomenal free-kick goal in the World Cup, or mint chip gelato from La Strega Nocciola—but most platform software simply doesn’t trigger this kind of passion. So why does Postgres? Why is this open source database having such a “moment”? Well, I’ve been trying to understand, looking at this “Postgres moment” from a few different angles. In this talk I’ll share what I’ve observed to be the top 10 business, technology, and community reasons so many of you have so much affection for PostgreSQL.

Why Postgres Why This Database Why Now | SF Bay Area Postgres Meetup | Claire Giordano from Citus Data

]]> 209 1 https://cdn.slidesharecdn.com/ss_thumbnails/why-postgresql-why-this-database-why-now-sfbayareapostgres-23july2019-claire-giordano-microsoft1-190831010252-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 A story on Postgres index types | PostgresLondon 2019 | Louise Grandjonc /slideshow/a-story-on-postgres-index-types-postgreslondon-2019-louise-grandjonc/167851508 crocotalkpgconfeu-181025134818-190831003241
Want to know everything about indexes in postgres? Here are the slides for a postgresql talk, and if you want to know more, you can read articles on www.louisemeta.com.]]>
Want to know everything about indexes in postgres? Here are the slides for a postgresql talk, and if you want to know more, you can read articles on www.louisemeta.com.]]> Sat, 31 Aug 2019 00:32:41 GMT /slideshow/a-story-on-postgres-index-types-postgreslondon-2019-louise-grandjonc/167851508 citus_data@slideshare.net(citus_data) A story on Postgres index types | PostgresLondon 2019 | Louise Grandjonc citus_data Want to know everything about indexes in postgres? Here are the slides for a postgresql talk, and if you want to know more, you can read articles on www.louisemeta.com. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/crocotalkpgconfeu-181025134818-190831003241-thumbnail.jpg?width=120&height=120&fit=bounds" /> Want to know everything about indexes in postgres? Here are the slides for a postgresql talk, and if you want to know more, you can read articles on www.louisemeta.com.

A story on Postgres index types | PostgresLondon 2019 | Louise Grandjonc from Citus Data

]]> 185 3 https://cdn.slidesharecdn.com/ss_thumbnails/crocotalkpgconfeu-181025134818-190831003241-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Why developers need marketing now more than ever | GlueCon 2019 | Claire Giordano /slideshow/why-developers-need-marketing-now-more-than-ever-gluecon-2019-claire-giordano/148809150 gluecon2019-giordano-keynote-v5-annotated1-190604010642
Many in today’s developer world look down on marketing. I mean, after all, the marketing team is usually “not technical.” And they’re not developers. It’s 2019 and while we try to promote inclusiveness of all types, inclusiveness doesn’t seem to apply to marketers. Why? Is that OK? Who does that hurt? I grew up in engineering and spent the first 15 years of my career as a developer or an engineering manager of some type. So now that I’m in marketing, it surprised me when one of my engineering colleagues blurted out “But it’s a technical conference!” when he learned one of my talks was accepted to a technical conference. This keynote is about why developers really need marketing. About how good marketing managers can make it so visitors to your website don’t leave empty-handed, confused about what your technology actually does or why it matters. About how the ability to translate technology into what-users-actually-care-about can make your project be the one that takes off. About why Dormain Drewitz said at Monktoberfest: “I work in product marketing. My preferred programming language is English.” Finally, this talk explores how to be sensitive to the bias against marketing that pervades some of our teams—and how to instead embrace teamwork best practices employed by sailors, where everyone in the boat has an important role to play if you are to win the race.]]>
Many in today’s developer world look down on marketing. I mean, after all, the marketing team is usually “not technical.” And they’re not developers. It’s 2019 and while we try to promote inclusiveness of all types, inclusiveness doesn’t seem to apply to marketers. Why? Is that OK? Who does that hurt? I grew up in engineering and spent the first 15 years of my career as a developer or an engineering manager of some type. So now that I’m in marketing, it surprised me when one of my engineering colleagues blurted out “But it’s a technical conference!” when he learned one of my talks was accepted to a technical conference. This keynote is about why developers really need marketing. About how good marketing managers can make it so visitors to your website don’t leave empty-handed, confused about what your technology actually does or why it matters. About how the ability to translate technology into what-users-actually-care-about can make your project be the one that takes off. About why Dormain Drewitz said at Monktoberfest: “I work in product marketing. My preferred programming language is English.” Finally, this talk explores how to be sensitive to the bias against marketing that pervades some of our teams—and how to instead embrace teamwork best practices employed by sailors, where everyone in the boat has an important role to play if you are to win the race.]]> Tue, 04 Jun 2019 01:06:42 GMT /slideshow/why-developers-need-marketing-now-more-than-ever-gluecon-2019-claire-giordano/148809150 citus_data@slideshare.net(citus_data) Why developers need marketing now more than ever | GlueCon 2019 | Claire Giordano citus_data Many in today’s developer world look down on marketing. I mean, after all, the marketing team is usually “not technical.” And they’re not developers. It’s 2019 and while we try to promote inclusiveness of all types, inclusiveness doesn’t seem to apply to marketers. Why? Is that OK? Who does that hurt? I grew up in engineering and spent the first 15 years of my career as a developer or an engineering manager of some type. So now that I’m in marketing, it surprised me when one of my engineering colleagues blurted out “But it’s a technical conference!” when he learned one of my talks was accepted to a technical conference. This keynote is about why developers really need marketing. About how good marketing managers can make it so visitors to your website don’t leave empty-handed, confused about what your technology actually does or why it matters. About how the ability to translate technology into what-users-actually-care-about can make your project be the one that takes off. About why Dormain Drewitz said at Monktoberfest: “I work in product marketing. My preferred programming language is English.” Finally, this talk explores how to be sensitive to the bias against marketing that pervades some of our teams—and how to instead embrace teamwork best practices employed by sailors, where everyone in the boat has an important role to play if you are to win the race. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/gluecon2019-giordano-keynote-v5-annotated1-190604010642-thumbnail.jpg?width=120&height=120&fit=bounds" /> Many in today’s developer world look down on marketing. I mean, after all, the marketing team is usually “not technical.” And they’re not developers. It’s 2019 and while we try to promote inclusiveness of all types, inclusiveness doesn’t seem to apply to marketers. Why? Is that OK? Who does that hurt? I grew up in engineering and spent the first 15 years of my career as a developer or an engineering manager of some type. So now that I’m in marketing, it surprised me when one of my engineering colleagues blurted out “But it’s a technical conference!” when he learned one of my talks was accepted to a technical conference. This keynote is about why developers really need marketing. About how good marketing managers can make it so visitors to your website don’t leave empty-handed, confused about what your technology actually does or why it matters. About how the ability to translate technology into what-users-actually-care-about can make your project be the one that takes off. About why Dormain Drewitz said at Monktoberfest: “I work in product marketing. My preferred programming language is English.” Finally, this talk explores how to be sensitive to the bias against marketing that pervades some of our teams—and how to instead embrace teamwork best practices employed by sailors, where everyone in the boat has an important role to play if you are to win the race.

Why developers need marketing now more than ever | GlueCon 2019 | Claire Giordano from Citus Data

]]> 215 1 https://cdn.slidesharecdn.com/ss_thumbnails/gluecon2019-giordano-keynote-v5-annotated1-190604010642-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 The Art of PostgreSQL | PostgreSQL Ukraine | Dimitri Fontaine /slideshow/the-art-of-postgresql-postgresql-ukraine-dimitri-fontaine/148809080 theartofpostgresql1-190604010432
PostgreSQL is the World’s Most Advanced Open Source Relational Database and by the end of this talk you will understand what that means for you, an application developer. What kind of problems PostgreSQL can solve for you, and how much you can rely on PostgreSQL in your daily activities, including unit-testing.]]>
PostgreSQL is the World’s Most Advanced Open Source Relational Database and by the end of this talk you will understand what that means for you, an application developer. What kind of problems PostgreSQL can solve for you, and how much you can rely on PostgreSQL in your daily activities, including unit-testing.]]> Tue, 04 Jun 2019 01:04:32 GMT /slideshow/the-art-of-postgresql-postgresql-ukraine-dimitri-fontaine/148809080 citus_data@slideshare.net(citus_data) The Art of PostgreSQL | PostgreSQL Ukraine | Dimitri Fontaine citus_data PostgreSQL is the World’s Most Advanced Open Source Relational Database and by the end of this talk you will understand what that means for you, an application developer. What kind of problems PostgreSQL can solve for you, and how much you can rely on PostgreSQL in your daily activities, including unit-testing. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/theartofpostgresql1-190604010432-thumbnail.jpg?width=120&height=120&fit=bounds" /> PostgreSQL is the World’s Most Advanced Open Source Relational Database and by the end of this talk you will understand what that means for you, an application developer. What kind of problems PostgreSQL can solve for you, and how much you can rely on PostgreSQL in your daily activities, including unit-testing.

The Art of PostgreSQL | PostgreSQL Ukraine | Dimitri Fontaine from Citus Data

]]> 289 1 https://cdn.slidesharecdn.com/ss_thumbnails/theartofpostgresql1-190604010432-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Optimizing your app by understanding your Postgres | RailsConf 2019 | Samay Sharma /slideshow/optimizing-your-app-by-understanding-your-postgres-railsconf-2019-samay-sharma/148808932 understandingpostgresrailsconf2019-190604005946
I’m a Postgres person. Period. After talking to many Rails developers about their application performance, I realized many performance issues can be solved by understanding your database a bit better. So I thought I’d share the statistics Postgres captures for you and how you can use them to find slow queries, un-used indexes, or tables which are not getting vacuumed correctly. This talk will cover Postgres tools and tips for the above, including pgstatstatements, useful catalog tables, and recently added Postgres features such as CREATE STATISTICS.]]>
I’m a Postgres person. Period. After talking to many Rails developers about their application performance, I realized many performance issues can be solved by understanding your database a bit better. So I thought I’d share the statistics Postgres captures for you and how you can use them to find slow queries, un-used indexes, or tables which are not getting vacuumed correctly. This talk will cover Postgres tools and tips for the above, including pgstatstatements, useful catalog tables, and recently added Postgres features such as CREATE STATISTICS.]]> Tue, 04 Jun 2019 00:59:46 GMT /slideshow/optimizing-your-app-by-understanding-your-postgres-railsconf-2019-samay-sharma/148808932 citus_data@slideshare.net(citus_data) Optimizing your app by understanding your Postgres | RailsConf 2019 | Samay Sharma citus_data I’m a Postgres person. Period. After talking to many Rails developers about their application performance, I realized many performance issues can be solved by understanding your database a bit better. So I thought I’d share the statistics Postgres captures for you and how you can use them to find slow queries, un-used indexes, or tables which are not getting vacuumed correctly. This talk will cover Postgres tools and tips for the above, including pgstatstatements, useful catalog tables, and recently added Postgres features such as CREATE STATISTICS. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/understandingpostgresrailsconf2019-190604005946-thumbnail.jpg?width=120&height=120&fit=bounds" /> I’m a Postgres person. Period. After talking to many Rails developers about their application performance, I realized many performance issues can be solved by understanding your database a bit better. So I thought I’d share the statistics Postgres captures for you and how you can use them to find slow queries, un-used indexes, or tables which are not getting vacuumed correctly. This talk will cover Postgres tools and tips for the above, including pgstatstatements, useful catalog tables, and recently added Postgres features such as CREATE STATISTICS.

Optimizing your app by understanding your Postgres | RailsConf 2019 | Samay Sharma from Citus Data

]]> 436 1 https://cdn.slidesharecdn.com/ss_thumbnails/understandingpostgresrailsconf2019-190604005946-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 When it all goes wrong (with Postgres) | RailsConf 2019 | Will Leinweber /slideshow/when-it-all-goes-wrong-with-postgres-railsconf-2019-will-leinweber/148808806 2019-05-01railsconfwhenitallgoeswrong-190604005551
You're woken up in the middle of the night to your phone. Your app is down and you're on call to fix it. Eventually you track it down to "something with the db," but what exactly is wrong? And of course, you're sure that nothing changed recently… Knowing what to fix, and even where to start looking, is a skill that takes a long time to develop. Especially since Postgres normally works very well for months at a time, not letting you get practice! In this talk, I'll share not only the more common failure cases and how to fix them, but also a general approach to efficiently figuring out what's wrong in the first place.]]>
You're woken up in the middle of the night to your phone. Your app is down and you're on call to fix it. Eventually you track it down to "something with the db," but what exactly is wrong? And of course, you're sure that nothing changed recently… Knowing what to fix, and even where to start looking, is a skill that takes a long time to develop. Especially since Postgres normally works very well for months at a time, not letting you get practice! In this talk, I'll share not only the more common failure cases and how to fix them, but also a general approach to efficiently figuring out what's wrong in the first place.]]> Tue, 04 Jun 2019 00:55:51 GMT /slideshow/when-it-all-goes-wrong-with-postgres-railsconf-2019-will-leinweber/148808806 citus_data@slideshare.net(citus_data) When it all goes wrong (with Postgres) | RailsConf 2019 | Will Leinweber citus_data You're woken up in the middle of the night to your phone. Your app is down and you're on call to fix it. Eventually you track it down to "something with the db," but what exactly is wrong? And of course, you're sure that nothing changed recently… Knowing what to fix, and even where to start looking, is a skill that takes a long time to develop. Especially since Postgres normally works very well for months at a time, not letting you get practice! In this talk, I'll share not only the more common failure cases and how to fix them, but also a general approach to efficiently figuring out what's wrong in the first place. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/2019-05-01railsconfwhenitallgoeswrong-190604005551-thumbnail.jpg?width=120&height=120&fit=bounds" /> You're woken up in the middle of the night to your phone. Your app is down and you're on call to fix it. Eventually you track it down to "something with the db," but what exactly is wrong? And of course, you're sure that nothing changed recently… Knowing what to fix, and even where to start looking, is a skill that takes a long time to develop. Especially since Postgres normally works very well for months at a time, not letting you get practice! In this talk, I'll share not only the more common failure cases and how to fix them, but also a general approach to efficiently figuring out what's wrong in the first place.

When it all goes wrong (with Postgres) | RailsConf 2019 | Will Leinweber from Citus Data

]]> 95 1 https://cdn.slidesharecdn.com/ss_thumbnails/2019-05-01railsconfwhenitallgoeswrong-190604005551-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 The Art of PostgreSQL | PostgreSQL Ukraine Meetup | Dimitri Fontaine /slideshow/the-art-of-postgresql-postgresql-ukraine-meetup-dimitri-fontaine/142825473 theartofpostgresql-190429203613
PostgreSQL is the World’s Most Advanced Open Source Relational Database and by the end of this talk you will understand what that means for you, an application developer. What kind of problems PostgreSQL can solve for you, and how much you can rely on PostgreSQL in your daily activities, including unit-testing.]]>
PostgreSQL is the World’s Most Advanced Open Source Relational Database and by the end of this talk you will understand what that means for you, an application developer. What kind of problems PostgreSQL can solve for you, and how much you can rely on PostgreSQL in your daily activities, including unit-testing.]]> Mon, 29 Apr 2019 20:36:13 GMT /slideshow/the-art-of-postgresql-postgresql-ukraine-meetup-dimitri-fontaine/142825473 citus_data@slideshare.net(citus_data) The Art of PostgreSQL | PostgreSQL Ukraine Meetup | Dimitri Fontaine citus_data PostgreSQL is the World’s Most Advanced Open Source Relational Database and by the end of this talk you will understand what that means for you, an application developer. What kind of problems PostgreSQL can solve for you, and how much you can rely on PostgreSQL in your daily activities, including unit-testing. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/theartofpostgresql-190429203613-thumbnail.jpg?width=120&height=120&fit=bounds" /> PostgreSQL is the World’s Most Advanced Open Source Relational Database and by the end of this talk you will understand what that means for you, an application developer. What kind of problems PostgreSQL can solve for you, and how much you can rely on PostgreSQL in your daily activities, including unit-testing.

The Art of PostgreSQL | PostgreSQL Ukraine Meetup | Dimitri Fontaine from Citus Data

]]> 479 3 https://cdn.slidesharecdn.com/ss_thumbnails/theartofpostgresql-190429203613-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Using Postgres and Citus for Lightning Fast Analytics, also ft. Rollups | Live Demo | Sai Srirampur /slideshow/using-postgres-and-citus-for-lightning-fast-analytics-also-ft-rollups-live-demo-sai-srirampur/137767462 citusdata03-190322231611
Watch Sai Srirampur, Solutions Engineer at Citus Data (now part of the Microsoft family), give a live demo of how you can use Postgres and the Citus extension to Postgres to manage real-time analytics workloads. View if you & your application need: >> A relational database that scales for customer-facing analytics dashboards, with real-time data ingest and a large volume of queries >> A way to scale out Postgres horizontally, to address the performance hiccups you’re experiencing as you run into the resource limits of single-node Postgres >> A way to roll-up and pre-aggregate data to build fast data pipelines and enable sub-second response times. >> A way to consolidate your database platforms, to avoid having separate stores for your transactional and analytics workloads Using a 4-node Citus database cluster in the cloud, Sai will show you how Citus shards Postgres to give you lightning fast performance, at scale. Also featuring rollups.]]>
Watch Sai Srirampur, Solutions Engineer at Citus Data (now part of the Microsoft family), give a live demo of how you can use Postgres and the Citus extension to Postgres to manage real-time analytics workloads. View if you & your application need: >> A relational database that scales for customer-facing analytics dashboards, with real-time data ingest and a large volume of queries >> A way to scale out Postgres horizontally, to address the performance hiccups you’re experiencing as you run into the resource limits of single-node Postgres >> A way to roll-up and pre-aggregate data to build fast data pipelines and enable sub-second response times. >> A way to consolidate your database platforms, to avoid having separate stores for your transactional and analytics workloads Using a 4-node Citus database cluster in the cloud, Sai will show you how Citus shards Postgres to give you lightning fast performance, at scale. Also featuring rollups.]]> Fri, 22 Mar 2019 23:16:11 GMT /slideshow/using-postgres-and-citus-for-lightning-fast-analytics-also-ft-rollups-live-demo-sai-srirampur/137767462 citus_data@slideshare.net(citus_data) Using Postgres and Citus for Lightning Fast Analytics, also ft. Rollups | Live Demo | Sai Srirampur citus_data Watch Sai Srirampur, Solutions Engineer at Citus Data (now part of the Microsoft family), give a live demo of how you can use Postgres and the Citus extension to Postgres to manage real-time analytics workloads. View if you & your application need: >> A relational database that scales for customer-facing analytics dashboards, with real-time data ingest and a large volume of queries >> A way to scale out Postgres horizontally, to address the performance hiccups you’re experiencing as you run into the resource limits of single-node Postgres >> A way to roll-up and pre-aggregate data to build fast data pipelines and enable sub-second response times. >> A way to consolidate your database platforms, to avoid having separate stores for your transactional and analytics workloads Using a 4-node Citus database cluster in the cloud, Sai will show you how Citus shards Postgres to give you lightning fast performance, at scale. Also featuring rollups. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/citusdata03-190322231611-thumbnail.jpg?width=120&height=120&fit=bounds" /> Watch Sai Srirampur, Solutions Engineer at Citus Data (now part of the Microsoft family), give a live demo of how you can use Postgres and the Citus extension to Postgres to manage real-time analytics workloads. View if you & your application need: >> A relational database that scales for customer-facing analytics dashboards, with real-time data ingest and a large volume of queries >> A way to scale out Postgres horizontally, to address the performance hiccups you’re experiencing as you run into the resource limits of single-node Postgres >> A way to roll-up and pre-aggregate data to build fast data pipelines and enable sub-second response times. >> A way to consolidate your database platforms, to avoid having separate stores for your transactional and analytics workloads Using a 4-node Citus database cluster in the cloud, Sai will show you how Citus shards Postgres to give you lightning fast performance, at scale. Also featuring rollups.

Using Postgres and Citus for Lightning Fast Analytics, also ft. Rollups | Live Demo | Sai Srirampur from Citus Data

]]> 257 1 https://cdn.slidesharecdn.com/ss_thumbnails/citusdata03-190322231611-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 How to write SQL queries | pgDay Paris 2019 | Dimitri Fontaine /slideshow/how-to-write-sql-queries-pgday-paris-2019-dimitri-fontaine/137759207 howtowriteansqlquery-190322205729
Most of the time we see finished SQL queries, either in code repositories, blog posts of talk slides. This talk focus on the process of how to write an SQL query, from a problem statement expressed in English to code review and long term maintenance of SQL code.]]>
Most of the time we see finished SQL queries, either in code repositories, blog posts of talk slides. This talk focus on the process of how to write an SQL query, from a problem statement expressed in English to code review and long term maintenance of SQL code.]]> Fri, 22 Mar 2019 20:57:29 GMT /slideshow/how-to-write-sql-queries-pgday-paris-2019-dimitri-fontaine/137759207 citus_data@slideshare.net(citus_data) How to write SQL queries | pgDay Paris 2019 | Dimitri Fontaine citus_data Most of the time we see finished SQL queries, either in code repositories, blog posts of talk slides. This talk focus on the process of how to write an SQL query, from a problem statement expressed in English to code review and long term maintenance of SQL code. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/howtowriteansqlquery-190322205729-thumbnail.jpg?width=120&height=120&fit=bounds" /> Most of the time we see finished SQL queries, either in code repositories, blog posts of talk slides. This talk focus on the process of how to write an SQL query, from a problem statement expressed in English to code review and long term maintenance of SQL code.

How to write SQL queries | pgDay Paris 2019 | Dimitri Fontaine from Citus Data

]]> 139 2 https://cdn.slidesharecdn.com/ss_thumbnails/howtowriteansqlquery-190322205729-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 When it all Goes Wrong |Nordic PGDay 2019 | Will Leinweber /slideshow/when-it-all-goes-wrong-nordic-pgday-2019-will-leinweber/137758598 2019-03-19leinweberwhenitallgoeswrong-190322204946
You're woken up in the middle of the night to your phone. Your app is down and you're on call to fix it. Eventually you track it down to "something with the db," but what exactly is wrong? And of course, you're sure that nothing changed recently… Knowing what to fix, and even where to start looking, is a skill that takes a long time to develop. Especially since Postgres normally works very well for months at a time, not letting you get practice! In this talk, I'll share not only the more common failure cases and how to fix them, but also a general approach to efficiently figuring out what's wrong in the first place.]]>
You're woken up in the middle of the night to your phone. Your app is down and you're on call to fix it. Eventually you track it down to "something with the db," but what exactly is wrong? And of course, you're sure that nothing changed recently… Knowing what to fix, and even where to start looking, is a skill that takes a long time to develop. Especially since Postgres normally works very well for months at a time, not letting you get practice! In this talk, I'll share not only the more common failure cases and how to fix them, but also a general approach to efficiently figuring out what's wrong in the first place.]]> Fri, 22 Mar 2019 20:49:46 GMT /slideshow/when-it-all-goes-wrong-nordic-pgday-2019-will-leinweber/137758598 citus_data@slideshare.net(citus_data) When it all Goes Wrong |Nordic PGDay 2019 | Will Leinweber citus_data You're woken up in the middle of the night to your phone. Your app is down and you're on call to fix it. Eventually you track it down to "something with the db," but what exactly is wrong? And of course, you're sure that nothing changed recently… Knowing what to fix, and even where to start looking, is a skill that takes a long time to develop. Especially since Postgres normally works very well for months at a time, not letting you get practice! In this talk, I'll share not only the more common failure cases and how to fix them, but also a general approach to efficiently figuring out what's wrong in the first place. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/2019-03-19leinweberwhenitallgoeswrong-190322204946-thumbnail.jpg?width=120&height=120&fit=bounds" /> You're woken up in the middle of the night to your phone. Your app is down and you're on call to fix it. Eventually you track it down to "something with the db," but what exactly is wrong? And of course, you're sure that nothing changed recently… Knowing what to fix, and even where to start looking, is a skill that takes a long time to develop. Especially since Postgres normally works very well for months at a time, not letting you get practice! In this talk, I'll share not only the more common failure cases and how to fix them, but also a general approach to efficiently figuring out what's wrong in the first place.

When it all Goes Wrong |Nordic PGDay 2019 | Will Leinweber from Citus Data

]]> 86 1 https://cdn.slidesharecdn.com/ss_thumbnails/2019-03-19leinweberwhenitallgoeswrong-190322204946-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Why PostgreSQL Why This Database Why Now | Nordic PGDay 2019 | Claire Giordano /citus_data/why-postgresql-why-this-database-why-now-nordic-pgday-2019-claire-giordano why-postgresql-why-this-database-why-now-nordic-pgday-mar-2019-claire-giordano-citus-data-190322204115
I spent the early part of my career working on developer tools, operating systems, high-speed file systems, and scale-out storage. Not databases. Frankly, I always thought that databases were a bit boring. So one year in to my new job at a Postgres company, I continue to be amazed at the enthusiasm of the PostgreSQL developer community and users. I mean, people’s eyes light up when you ask them why they love Postgres. Sure, a lot of us get animated when talking about our newest iPhone, or Ronaldo’s phenomenal free-kick goal in the World Cup, or mint chip gelato from La Strega Nociola—but most platform software simply doesn’t trigger this kind of passion. So why does Postgres? Why is this open source database having such a “moment”? Why now? Well, I’ve been trying to find out, looking at this “Postgres moment” from a few different angles. In this talk I’ll share what I’ve observed to be the top 10 business, technology, and community reasons so many of you have so much affection for PostgreSQL.]]>
I spent the early part of my career working on developer tools, operating systems, high-speed file systems, and scale-out storage. Not databases. Frankly, I always thought that databases were a bit boring. So one year in to my new job at a Postgres company, I continue to be amazed at the enthusiasm of the PostgreSQL developer community and users. I mean, people’s eyes light up when you ask them why they love Postgres. Sure, a lot of us get animated when talking about our newest iPhone, or Ronaldo’s phenomenal free-kick goal in the World Cup, or mint chip gelato from La Strega Nociola—but most platform software simply doesn’t trigger this kind of passion. So why does Postgres? Why is this open source database having such a “moment”? Why now? Well, I’ve been trying to find out, looking at this “Postgres moment” from a few different angles. In this talk I’ll share what I’ve observed to be the top 10 business, technology, and community reasons so many of you have so much affection for PostgreSQL.]]> Fri, 22 Mar 2019 20:41:15 GMT /citus_data/why-postgresql-why-this-database-why-now-nordic-pgday-2019-claire-giordano citus_data@slideshare.net(citus_data) Why PostgreSQL Why This Database Why Now | Nordic PGDay 2019 | Claire Giordano citus_data I spent the early part of my career working on developer tools, operating systems, high-speed file systems, and scale-out storage. Not databases. Frankly, I always thought that databases were a bit boring. So one year in to my new job at a Postgres company, I continue to be amazed at the enthusiasm of the PostgreSQL developer community and users. I mean, people’s eyes light up when you ask them why they love Postgres. Sure, a lot of us get animated when talking about our newest iPhone, or Ronaldo’s phenomenal free-kick goal in the World Cup, or mint chip gelato from La Strega Nociola—but most platform software simply doesn’t trigger this kind of passion. So why does Postgres? Why is this open source database having such a “moment”? Why now? Well, I’ve been trying to find out, looking at this “Postgres moment” from a few different angles. In this talk I’ll share what I’ve observed to be the top 10 business, technology, and community reasons so many of you have so much affection for PostgreSQL. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/why-postgresql-why-this-database-why-now-nordic-pgday-mar-2019-claire-giordano-citus-data-190322204115-thumbnail.jpg?width=120&height=120&fit=bounds" /> I spent the early part of my career working on developer tools, operating systems, high-speed file systems, and scale-out storage. Not databases. Frankly, I always thought that databases were a bit boring. So one year in to my new job at a Postgres company, I continue to be amazed at the enthusiasm of the PostgreSQL developer community and users. I mean, people’s eyes light up when you ask them why they love Postgres. Sure, a lot of us get animated when talking about our newest iPhone, or Ronaldo’s phenomenal free-kick goal in the World Cup, or mint chip gelato from La Strega Nociola—but most platform software simply doesn’t trigger this kind of passion. So why does Postgres? Why is this open source database having such a “moment”? Why now? Well, I’ve been trying to find out, looking at this “Postgres moment” from a few different angles. In this talk I’ll share what I’ve observed to be the top 10 business, technology, and community reasons so many of you have so much affection for PostgreSQL.

Why PostgreSQL Why This Database Why Now | Nordic PGDay 2019 | Claire Giordano from Citus Data

]]> 221 1 https://cdn.slidesharecdn.com/ss_thumbnails/why-postgresql-why-this-database-why-now-nordic-pgday-mar-2019-claire-giordano-citus-data-190322204115-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 https://cdn.slidesharecdn.com/profile-photo-citus_data-48x48.jpg?cb=1604612223 www.citusdata.com https://cdn.slidesharecdn.com/ss_thumbnails/citushyperscale-meetupzurich2020-03-04-200326004926-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/architecting-petabytescale-analytics-by-scaling-out-postgres-on-azure-with-citus-devops-meetup-zurich-alicja-kucharczyk/230868643 Architecting peta-byte... https://cdn.slidesharecdn.com/ss_thumbnails/datamodeling-200103001754-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/data-modeling-normalization-and-denormalization-postgresopen-2019-dimitri-fontaine/214409388 Data Modeling, Normali... https://cdn.slidesharecdn.com/ss_thumbnails/jsonbpresentation1-200103001056-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/jsonb-tricks-operators-indexes-and-when-not-to-use-it-postgresopen-2019-colton-shepard/214407886 JSONB Tricks: Operator...