�ݺ�ߣshows by User: pgdayasia

�ݺ�ߣshows by User: pgdayasia / http://www.slideshare.net/images/logo.gif �ݺ�ߣshows by User: pgdayasia / Mon, 26 Mar 2018 02:11:08 GMT �ݺ�ߣShare feed for �ݺ�ߣshows by User: pgdayasia PGConf APAC 2018: Sponsored Talk by Fujitsu - The growing mandatory requirements to protect data /slideshow/pgconf-apac-2018-sponsored-talk-by-fujitsu-the-growing-mandatory-requirements-to-protect-data-91894192/91894192 thegrowingmandatoryrequirementstoprotectdata-180326021108
Speaker: Rajni Baliyan As the volume of data of a personal nature and commodification of information collected and analysed increases; so is the focus on privacy and data security. Many countries are examining international and domestic laws in order to protect consumers and organisations alike. The Australian Senate has recently passed a bill containing mandatory requirements to notify the privacy commissioner and consumers when data is at risk of causing serious harm in the case of a data breach occurring. Europe has also announced new laws that allow consumers more control over their data. These laws allow consumers to tell companies to erase any data held about them. These new laws will have a significant impact on organisations that store personal information. This talk will examine some of these legislative changes and how specific PostgreSQL features can assist organisations in meeting their obligations and avoid heavy fines associated with breaching them. ]]>
Speaker: Rajni Baliyan As the volume of data of a personal nature and commodification of information collected and analysed increases; so is the focus on privacy and data security. Many countries are examining international and domestic laws in order to protect consumers and organisations alike. The Australian Senate has recently passed a bill containing mandatory requirements to notify the privacy commissioner and consumers when data is at risk of causing serious harm in the case of a data breach occurring. Europe has also announced new laws that allow consumers more control over their data. These laws allow consumers to tell companies to erase any data held about them. These new laws will have a significant impact on organisations that store personal information. This talk will examine some of these legislative changes and how specific PostgreSQL features can assist organisations in meeting their obligations and avoid heavy fines associated with breaching them. ]]> Mon, 26 Mar 2018 02:11:08 GMT /slideshow/pgconf-apac-2018-sponsored-talk-by-fujitsu-the-growing-mandatory-requirements-to-protect-data-91894192/91894192 pgdayasia@slideshare.net(pgdayasia) PGConf APAC 2018: Sponsored Talk by Fujitsu - The growing mandatory requirements to protect data pgdayasia Speaker: Rajni Baliyan As the volume of data of a personal nature and commodification of information collected and analysed increases; so is the focus on privacy and data security. Many countries are examining international and domestic laws in order to protect consumers and organisations alike. The Australian Senate has recently passed a bill containing mandatory requirements to notify the privacy commissioner and consumers when data is at risk of causing serious harm in the case of a data breach occurring. Europe has also announced new laws that allow consumers more control over their data. These laws allow consumers to tell companies to erase any data held about them. These new laws will have a significant impact on organisations that store personal information. This talk will examine some of these legislative changes and how specific PostgreSQL features can assist organisations in meeting their obligations and avoid heavy fines associated with breaching them. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/thegrowingmandatoryrequirementstoprotectdata-180326021108-thumbnail.jpg?width=120&height=120&fit=bounds" /> Speaker: Rajni Baliyan As the volume of data of a personal nature and commodification of information collected and analysed increases; so is the focus on privacy and data security. Many countries are examining international and domestic laws in order to protect consumers and organisations alike. The Australian Senate has recently passed a bill containing mandatory requirements to notify the privacy commissioner and consumers when data is at risk of causing serious harm in the case of a data breach occurring. Europe has also announced new laws that allow consumers more control over their data. These laws allow consumers to tell companies to erase any data held about them. These new laws will have a significant impact on organisations that store personal information. This talk will examine some of these legislative changes and how specific PostgreSQL features can assist organisations in meeting their obligations and avoid heavy fines associated with breaching them.

PGConf APAC 2018: Sponsored Talk by Fujitsu - The growing mandatory requirements to protect data from PGConf APAC

]]> 1012 4 https://cdn.slidesharecdn.com/ss_thumbnails/thegrowingmandatoryrequirementstoprotectdata-180326021108-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 PGConf APAC 2018: PostgreSQL 10 - Replication goes Logical /slideshow/pgconf-apac-2018-postgresql-10-replication-goes-logical/91894067 replication-goes-logical-180326020759
While the physical replication in PostgreSQL is quite robust, however, it doesn’t fit well in the picture when: - You need partial replication only - You want to replicate between different major versions of PostgreSQL - You need to replicate multiple databases to the same target - Transformation of the data is needed - You want to replicate in order to upgrade without downtime The answer to these use cases is logical replication This talk will discuss and cover these use cases followed by a logical replication demo.]]>
While the physical replication in PostgreSQL is quite robust, however, it doesn’t fit well in the picture when: - You need partial replication only - You want to replicate between different major versions of PostgreSQL - You need to replicate multiple databases to the same target - Transformation of the data is needed - You want to replicate in order to upgrade without downtime The answer to these use cases is logical replication This talk will discuss and cover these use cases followed by a logical replication demo.]]> Mon, 26 Mar 2018 02:07:59 GMT /slideshow/pgconf-apac-2018-postgresql-10-replication-goes-logical/91894067 pgdayasia@slideshare.net(pgdayasia) PGConf APAC 2018: PostgreSQL 10 - Replication goes Logical pgdayasia While the physical replication in PostgreSQL is quite robust, however, it doesn’t fit well in the picture when: - You need partial replication only - You want to replicate between different major versions of PostgreSQL - You need to replicate multiple databases to the same target - Transformation of the data is needed - You want to replicate in order to upgrade without downtime The answer to these use cases is logical replication This talk will discuss and cover these use cases followed by a logical replication demo. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/replication-goes-logical-180326020759-thumbnail.jpg?width=120&height=120&fit=bounds" /> While the physical replication in PostgreSQL is quite robust, however, it doesn’t fit well in the picture when: - You need partial replication only - You want to replicate between different major versions of PostgreSQL - You need to replicate multiple databases to the same target - Transformation of the data is needed - You want to replicate in order to upgrade without downtime The answer to these use cases is logical replication This talk will discuss and cover these use cases followed by a logical replication demo.

PGConf APAC 2018: PostgreSQL 10 - Replication goes Logical from PGConf APAC

]]> 498 1 https://cdn.slidesharecdn.com/ss_thumbnails/replication-goes-logical-180326020759-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 PGConf APAC 2018 - Lightening Talk #3: How To Contribute to PostgreSQL /slideshow/lightening-talk-3-how-to-contribute-to-postgresql/91813732 lightningtalkhowtocontributetopostgresqlcommunity-180324173824
Speaker: Rajni Baliyan Lightening Talk: How To Contribute to PostgreSQL]]>
Speaker: Rajni Baliyan Lightening Talk: How To Contribute to PostgreSQL]]> Sat, 24 Mar 2018 17:38:24 GMT /slideshow/lightening-talk-3-how-to-contribute-to-postgresql/91813732 pgdayasia@slideshare.net(pgdayasia) PGConf APAC 2018 - Lightening Talk #3: How To Contribute to PostgreSQL pgdayasia Speaker: Rajni Baliyan Lightening Talk: How To Contribute to PostgreSQL <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/lightningtalkhowtocontributetopostgresqlcommunity-180324173824-thumbnail.jpg?width=120&height=120&fit=bounds" /> Speaker: Rajni Baliyan Lightening Talk: How To Contribute to PostgreSQL

PGConf APAC 2018 - Lightening Talk #3: How To Contribute to PostgreSQL from PGConf APAC

]]> 202 2 https://cdn.slidesharecdn.com/ss_thumbnails/lightningtalkhowtocontributetopostgresqlcommunity-180324173824-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 PGConf APAC 2018 - Lightening Talk #2 - Centralizing Authorization in PostgreSQL /slideshow/lightening-talk-2-centralizing-authorization-in-postgresql/91813511 lighteningtalk-gary-centralizingauthorizationinpostgresql-180324173530
Speaker: Gary Evans Lightening Talk - Centralizing Authorization in PostgreSQL]]>
Speaker: Gary Evans Lightening Talk - Centralizing Authorization in PostgreSQL]]> Sat, 24 Mar 2018 17:35:30 GMT /slideshow/lightening-talk-2-centralizing-authorization-in-postgresql/91813511 pgdayasia@slideshare.net(pgdayasia) PGConf APAC 2018 - Lightening Talk #2 - Centralizing Authorization in PostgreSQL pgdayasia Speaker: Gary Evans Lightening Talk - Centralizing Authorization in PostgreSQL <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/lighteningtalk-gary-centralizingauthorizationinpostgresql-180324173530-thumbnail.jpg?width=120&height=120&fit=bounds" /> Speaker: Gary Evans Lightening Talk - Centralizing Authorization in PostgreSQL

PGConf APAC 2018 - Lightening Talk #2 - Centralizing Authorization in PostgreSQL from PGConf APAC

]]> 324 1 https://cdn.slidesharecdn.com/ss_thumbnails/lighteningtalk-gary-centralizingauthorizationinpostgresql-180324173530-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 Sponsored Talk @ PGConf APAC 2018 - Choosing the right partner in your PostgreSQL journey /slideshow/choosing-the-right-partner-in-your-postgresql-journey/91813164 20180323-sponsoredtalkpgconfapac-180324173047
Sponsored Talk by Umair Shahid of 2nd Quadrant (Gold Sponsor and Lunch Sponsor for PGConf APAC 2018).]]>
Sponsored Talk by Umair Shahid of 2nd Quadrant (Gold Sponsor and Lunch Sponsor for PGConf APAC 2018).]]> Sat, 24 Mar 2018 17:30:47 GMT /slideshow/choosing-the-right-partner-in-your-postgresql-journey/91813164 pgdayasia@slideshare.net(pgdayasia) Sponsored Talk @ PGConf APAC 2018 - Choosing the right partner in your PostgreSQL journey pgdayasia Sponsored Talk by Umair Shahid of 2nd Quadrant (Gold Sponsor and Lunch Sponsor for PGConf APAC 2018). <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/20180323-sponsoredtalkpgconfapac-180324173047-thumbnail.jpg?width=120&height=120&fit=bounds" /> Sponsored Talk by Umair Shahid of 2nd Quadrant (Gold Sponsor and Lunch Sponsor for PGConf APAC 2018).

Sponsored Talk @ PGConf APAC 2018 - Choosing the right partner in your PostgreSQL journey from PGConf APAC

]]> 169 1 https://cdn.slidesharecdn.com/ss_thumbnails/20180323-sponsoredtalkpgconfapac-180324173047-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 PGConf APAC 2018 - A PostgreSQL DBAs Toolbelt for 2018 /pgdayasia/a-postgresql-dbas-toolbelt-for-2018 kaarelmoppel-postgresqldbastoolbeltfor2018-180324172848
There's no need to re-invent the wheel! Dozens of people have already tried...and succeeded. This talk is a categorized and illustrated overview on most popular and/or useful PostgreSQL specific scripts, utilities and whole toolsets that DBAs should be aware of for solving daily tasks. Inlcuding - performance monitoring, logs management/analyzis, identifying/fixing most common adminstration problems around areas of general performance metrics, tuning, locking, indexing, bloat, leaving out high-availability topics. Covered are venerable oldies from wiki.postgresql.org as well as my newer favourites from Github.]]>
There's no need to re-invent the wheel! Dozens of people have already tried...and succeeded. This talk is a categorized and illustrated overview on most popular and/or useful PostgreSQL specific scripts, utilities and whole toolsets that DBAs should be aware of for solving daily tasks. Inlcuding - performance monitoring, logs management/analyzis, identifying/fixing most common adminstration problems around areas of general performance metrics, tuning, locking, indexing, bloat, leaving out high-availability topics. Covered are venerable oldies from wiki.postgresql.org as well as my newer favourites from Github.]]> Sat, 24 Mar 2018 17:28:48 GMT /pgdayasia/a-postgresql-dbas-toolbelt-for-2018 pgdayasia@slideshare.net(pgdayasia) PGConf APAC 2018 - A PostgreSQL DBAs Toolbelt for 2018 pgdayasia There's no need to re-invent the wheel! Dozens of people have already tried...and succeeded. This talk is a categorized and illustrated overview on most popular and/or useful PostgreSQL specific scripts, utilities and whole toolsets that DBAs should be aware of for solving daily tasks. Inlcuding - performance monitoring, logs management/analyzis, identifying/fixing most common adminstration problems around areas of general performance metrics, tuning, locking, indexing, bloat, leaving out high-availability topics. Covered are venerable oldies from wiki.postgresql.org as well as my newer favourites from Github. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/kaarelmoppel-postgresqldbastoolbeltfor2018-180324172848-thumbnail.jpg?width=120&height=120&fit=bounds" /> There's no need to re-invent the wheel! Dozens of people have already tried...and succeeded. This talk is a categorized and illustrated overview on most popular and/or useful PostgreSQL specific scripts, utilities and whole toolsets that DBAs should be aware of for solving daily tasks. Inlcuding - performance monitoring, logs management/analyzis, identifying/fixing most common adminstration problems around areas of general performance metrics, tuning, locking, indexing, bloat, leaving out high-availability topics. Covered are venerable oldies from wiki.postgresql.org as well as my newer favourites from Github.

PGConf APAC 2018 - A PostgreSQL DBAs Toolbelt for 2018 from PGConf APAC

]]> 627 2 https://cdn.slidesharecdn.com/ss_thumbnails/kaarelmoppel-postgresqldbastoolbeltfor2018-180324172848-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 PGConf APAC 2018 - Patroni: Kubernetes-native PostgreSQL companion /pgdayasia/patroni-kubernetesnative-postgresql-companion-91812839 alexanderkukushkin-patronikubernetesnativepostgresqlcompanion-180324172625
Speaker: Alexander Kukushkin Kubernetes is a solid leader among different cloud orchestration engines and its adoption rate is growing on a daily basis. Naturally people want to run both their applications and databases on the same infrastructure. There are a lot of ways to deploy and run PostgreSQL on Kubernetes, but most of them are not cloud-native. Around one year ago Zalando started to run HA setup of PostgreSQL on Kubernetes managed by Patroni. Those experiments were quite successful and produced a Helm chart for Patroni. That chart was useful, albeit a single problem: Patroni depended on Etcd, ZooKeeper or Consul. Few people look forward to deploy two applications instead of one and support them later on. In this talk I would like to introduce Kubernetes-native Patroni. I will explain how Patroni uses Kubernetes API to run a leader election and store the cluster state. I’m going to live-demo a deployment of HA PostgreSQL cluster on Minikube and share our own experience of running more than 130 clusters on Kubernetes. Patroni is a Python open-source project developed by Zalando in cooperation with other contributors on GitHub: https://github.com/zalando/patroni]]>
Speaker: Alexander Kukushkin Kubernetes is a solid leader among different cloud orchestration engines and its adoption rate is growing on a daily basis. Naturally people want to run both their applications and databases on the same infrastructure. There are a lot of ways to deploy and run PostgreSQL on Kubernetes, but most of them are not cloud-native. Around one year ago Zalando started to run HA setup of PostgreSQL on Kubernetes managed by Patroni. Those experiments were quite successful and produced a Helm chart for Patroni. That chart was useful, albeit a single problem: Patroni depended on Etcd, ZooKeeper or Consul. Few people look forward to deploy two applications instead of one and support them later on. In this talk I would like to introduce Kubernetes-native Patroni. I will explain how Patroni uses Kubernetes API to run a leader election and store the cluster state. I’m going to live-demo a deployment of HA PostgreSQL cluster on Minikube and share our own experience of running more than 130 clusters on Kubernetes. Patroni is a Python open-source project developed by Zalando in cooperation with other contributors on GitHub: https://github.com/zalando/patroni]]> Sat, 24 Mar 2018 17:26:24 GMT /pgdayasia/patroni-kubernetesnative-postgresql-companion-91812839 pgdayasia@slideshare.net(pgdayasia) PGConf APAC 2018 - Patroni: Kubernetes-native PostgreSQL companion pgdayasia Speaker: Alexander Kukushkin Kubernetes is a solid leader among different cloud orchestration engines and its adoption rate is growing on a daily basis. Naturally people want to run both their applications and databases on the same infrastructure. There are a lot of ways to deploy and run PostgreSQL on Kubernetes, but most of them are not cloud-native. Around one year ago Zalando started to run HA setup of PostgreSQL on Kubernetes managed by Patroni. Those experiments were quite successful and produced a Helm chart for Patroni. That chart was useful, albeit a single problem: Patroni depended on Etcd, ZooKeeper or Consul. Few people look forward to deploy two applications instead of one and support them later on. In this talk I would like to introduce Kubernetes-native Patroni. I will explain how Patroni uses Kubernetes API to run a leader election and store the cluster state. I’m going to live-demo a deployment of HA PostgreSQL cluster on Minikube and share our own experience of running more than 130 clusters on Kubernetes. Patroni is a Python open-source project developed by Zalando in cooperation with other contributors on GitHub: https://github.com/zalando/patroni <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/alexanderkukushkin-patronikubernetesnativepostgresqlcompanion-180324172625-thumbnail.jpg?width=120&height=120&fit=bounds" /> Speaker: Alexander Kukushkin Kubernetes is a solid leader among different cloud orchestration engines and its adoption rate is growing on a daily basis. Naturally people want to run both their applications and databases on the same infrastructure. There are a lot of ways to deploy and run PostgreSQL on Kubernetes, but most of them are not cloud-native. Around one year ago Zalando started to run HA setup of PostgreSQL on Kubernetes managed by Patroni. Those experiments were quite successful and produced a Helm chart for Patroni. That chart was useful, albeit a single problem: Patroni depended on Etcd, ZooKeeper or Consul. Few people look forward to deploy two applications instead of one and support them later on. In this talk I would like to introduce Kubernetes-native Patroni. I will explain how Patroni uses Kubernetes API to run a leader election and store the cluster state. I’m going to live-demo a deployment of HA PostgreSQL cluster on Minikube and share our own experience of running more than 130 clusters on Kubernetes. Patroni is a Python open-source project developed by Zalando in cooperation with other contributors on GitHub: https://github.com/zalando/patroni

PGConf APAC 2018 - Patroni: Kubernetes-native PostgreSQL companion from PGConf APAC

]]> 739 1 https://cdn.slidesharecdn.com/ss_thumbnails/alexanderkukushkin-patronikubernetesnativepostgresqlcompanion-180324172625-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 PGConf APAC 2018 - High performance json postgre-sql vs. mongodb /slideshow/high-performance-json-postgresql-vs-mongodb/91812445 high-performancejsonpostgresqlvs-180324172102
Speakers: Dominic Dwyer & Wei Shan Ang This talk was presented in Percona Live Europe 2017. However, we did not have enough time to test against more scenario. We will be giving an updated talk with a more comprehensive tests and numbers. We hope to run it against citusDB and MongoRocks as well to provide a comprehensive comparison. https://www.percona.com/live/e17/sessions/high-performance-json-postgresql-vs-mongodb]]>
Speakers: Dominic Dwyer & Wei Shan Ang This talk was presented in Percona Live Europe 2017. However, we did not have enough time to test against more scenario. We will be giving an updated talk with a more comprehensive tests and numbers. We hope to run it against citusDB and MongoRocks as well to provide a comprehensive comparison. https://www.percona.com/live/e17/sessions/high-performance-json-postgresql-vs-mongodb]]> Sat, 24 Mar 2018 17:21:02 GMT /slideshow/high-performance-json-postgresql-vs-mongodb/91812445 pgdayasia@slideshare.net(pgdayasia) PGConf APAC 2018 - High performance json postgre-sql vs. mongodb pgdayasia Speakers: Dominic Dwyer & Wei Shan Ang This talk was presented in Percona Live Europe 2017. However, we did not have enough time to test against more scenario. We will be giving an updated talk with a more comprehensive tests and numbers. We hope to run it against citusDB and MongoRocks as well to provide a comprehensive comparison. https://www.percona.com/live/e17/sessions/high-performance-json-postgresql-vs-mongodb <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/high-performancejsonpostgresqlvs-180324172102-thumbnail.jpg?width=120&height=120&fit=bounds" /> Speakers: Dominic Dwyer & Wei Shan Ang This talk was presented in Percona Live Europe 2017. However, we did not have enough time to test against more scenario. We will be giving an updated talk with a more comprehensive tests and numbers. We hope to run it against citusDB and MongoRocks as well to provide a comprehensive comparison. https://www.percona.com/live/e17/sessions/high-performance-json-postgresql-vs-mongodb

PGConf APAC 2018 - High performance json postgre-sql vs. mongodb from PGConf APAC

]]> 736 1 https://cdn.slidesharecdn.com/ss_thumbnails/high-performancejsonpostgresqlvs-180324172102-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 PGConf APAC 2018 - Monitoring PostgreSQL at Scale /slideshow/monitoring-postgresql-at-scale/91812304 monitoringpostgresatscale-180324171904
Speaker: Lukas Fittl Your PostgreSQL database is one of the most important pieces of your architecture - yet the level of introspection available in Postgres is often hard to work with. Its easy to get very detailed information, but what should you really watch out for, send reports on and alert on? In this talk we'll discuss how query performance statistics can be made accessible to application developers, critical entries one should monitor in the PostgreSQL log files, how to collect EXPLAIN plans at scale, how to watch over autovacuum and VACUUM operations, and how to flag issues based on schema statistics. We'll also talk a bit about monitoring multi-server setups, first going into high availability and read standbys, logical replication, and then reviewing how monitoring looks like for sharded databases like Citus. The talk will primarily describe free/open-source tools and statistics views readily available from within Postgres.]]>
Speaker: Lukas Fittl Your PostgreSQL database is one of the most important pieces of your architecture - yet the level of introspection available in Postgres is often hard to work with. Its easy to get very detailed information, but what should you really watch out for, send reports on and alert on? In this talk we'll discuss how query performance statistics can be made accessible to application developers, critical entries one should monitor in the PostgreSQL log files, how to collect EXPLAIN plans at scale, how to watch over autovacuum and VACUUM operations, and how to flag issues based on schema statistics. We'll also talk a bit about monitoring multi-server setups, first going into high availability and read standbys, logical replication, and then reviewing how monitoring looks like for sharded databases like Citus. The talk will primarily describe free/open-source tools and statistics views readily available from within Postgres.]]> Sat, 24 Mar 2018 17:19:04 GMT /slideshow/monitoring-postgresql-at-scale/91812304 pgdayasia@slideshare.net(pgdayasia) PGConf APAC 2018 - Monitoring PostgreSQL at Scale pgdayasia Speaker: Lukas Fittl Your PostgreSQL database is one of the most important pieces of your architecture - yet the level of introspection available in Postgres is often hard to work with. Its easy to get very detailed information, but what should you really watch out for, send reports on and alert on? In this talk we'll discuss how query performance statistics can be made accessible to application developers, critical entries one should monitor in the PostgreSQL log files, how to collect EXPLAIN plans at scale, how to watch over autovacuum and VACUUM operations, and how to flag issues based on schema statistics. We'll also talk a bit about monitoring multi-server setups, first going into high availability and read standbys, logical replication, and then reviewing how monitoring looks like for sharded databases like Citus. The talk will primarily describe free/open-source tools and statistics views readily available from within Postgres. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/monitoringpostgresatscale-180324171904-thumbnail.jpg?width=120&height=120&fit=bounds" /> Speaker: Lukas Fittl Your PostgreSQL database is one of the most important pieces of your architecture - yet the level of introspection available in Postgres is often hard to work with. Its easy to get very detailed information, but what should you really watch out for, send reports on and alert on? In this talk we'll discuss how query performance statistics can be made accessible to application developers, critical entries one should monitor in the PostgreSQL log files, how to collect EXPLAIN plans at scale, how to watch over autovacuum and VACUUM operations, and how to flag issues based on schema statistics. We'll also talk a bit about monitoring multi-server setups, first going into high availability and read standbys, logical replication, and then reviewing how monitoring looks like for sharded databases like Citus. The talk will primarily describe free/open-source tools and statistics views readily available from within Postgres.

PGConf APAC 2018 - Monitoring PostgreSQL at Scale from PGConf APAC

]]> 357 1 https://cdn.slidesharecdn.com/ss_thumbnails/monitoringpostgresatscale-180324171904-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 PGConf APAC 2018 - Where's Waldo - Text Search and Pattern in PostgreSQL /slideshow/wheres-waldo-text-search-and-pattern-in-postgresql/91812080 joeconway-whereswaldo-textsearchandpattern-180324171611
Speaker: Joe Conway There are many use cases for text search and pattern matching, and there are also a wide variety of techniques available in PostgreSQL to perform text search and pattern matching. Figuring out the best "match" between use case and technique can be confusing. This talk will review the possibilities and provide guidance regarding when to use what method, and especially how to properly deal with the related index methods to ensure speedy searches. This talk covers: * The primary available search methods * Examples illustrating when to use each * Extensive discussion of index use * Timing comparisons using realistic examples]]>
Speaker: Joe Conway There are many use cases for text search and pattern matching, and there are also a wide variety of techniques available in PostgreSQL to perform text search and pattern matching. Figuring out the best "match" between use case and technique can be confusing. This talk will review the possibilities and provide guidance regarding when to use what method, and especially how to properly deal with the related index methods to ensure speedy searches. This talk covers: * The primary available search methods * Examples illustrating when to use each * Extensive discussion of index use * Timing comparisons using realistic examples]]> Sat, 24 Mar 2018 17:16:11 GMT /slideshow/wheres-waldo-text-search-and-pattern-in-postgresql/91812080 pgdayasia@slideshare.net(pgdayasia) PGConf APAC 2018 - Where's Waldo - Text Search and Pattern in PostgreSQL pgdayasia Speaker: Joe Conway There are many use cases for text search and pattern matching, and there are also a wide variety of techniques available in PostgreSQL to perform text search and pattern matching. Figuring out the best "match" between use case and technique can be confusing. This talk will review the possibilities and provide guidance regarding when to use what method, and especially how to properly deal with the related index methods to ensure speedy searches. This talk covers: * The primary available search methods * Examples illustrating when to use each * Extensive discussion of index use * Timing comparisons using realistic examples <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/joeconway-whereswaldo-textsearchandpattern-180324171611-thumbnail.jpg?width=120&height=120&fit=bounds" /> Speaker: Joe Conway There are many use cases for text search and pattern matching, and there are also a wide variety of techniques available in PostgreSQL to perform text search and pattern matching. Figuring out the best "match" between use case and technique can be confusing. This talk will review the possibilities and provide guidance regarding when to use what method, and especially how to properly deal with the related index methods to ensure speedy searches. This talk covers: * The primary available search methods * Examples illustrating when to use each * Extensive discussion of index use * Timing comparisons using realistic examples

PGConf APAC 2018 - Where's Waldo - Text Search and Pattern in PostgreSQL from PGConf APAC

]]> 205 2 https://cdn.slidesharecdn.com/ss_thumbnails/joeconway-whereswaldo-textsearchandpattern-180324171611-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 PGConf APAC 2018 - Managing replication clusters with repmgr, Barman and PgBouncer /slideshow/managing-replication-clusters-with-repmgr-barman-and-pgbouncer/91811920 ianbarwick-managingreplicationclustersrepmgrbarmanpgbouncer-180324171404
Speaker: Ian Barwick PostgreSQL and reliability go hand-in-hand - but your data is only truly safe with a solid and trusted backup system in place, and no matter how good your application is, it's useless if it can't talk to your database. In this talk we'll demonstrate how to set up a reliable replication cluster using open source tools closely associated with the PostgreSQL project. The talk will cover following areas: - how to set up and manage a replication cluster with `repmgr` - how to set up and manage reliable backups with `Barman` - how to manage failover and application connections with `repmgr` and `PgBouncer` Ian Barwick has worked for 2ndQuadrant since 2014, and as well as making various contributions to PostgreSQL itself, is lead `repmgr` developer. He lives in Tokyo, Japan.]]>
Speaker: Ian Barwick PostgreSQL and reliability go hand-in-hand - but your data is only truly safe with a solid and trusted backup system in place, and no matter how good your application is, it's useless if it can't talk to your database. In this talk we'll demonstrate how to set up a reliable replication cluster using open source tools closely associated with the PostgreSQL project. The talk will cover following areas: - how to set up and manage a replication cluster with `repmgr` - how to set up and manage reliable backups with `Barman` - how to manage failover and application connections with `repmgr` and `PgBouncer` Ian Barwick has worked for 2ndQuadrant since 2014, and as well as making various contributions to PostgreSQL itself, is lead `repmgr` developer. He lives in Tokyo, Japan.]]> Sat, 24 Mar 2018 17:14:03 GMT /slideshow/managing-replication-clusters-with-repmgr-barman-and-pgbouncer/91811920 pgdayasia@slideshare.net(pgdayasia) PGConf APAC 2018 - Managing replication clusters with repmgr, Barman and PgBouncer pgdayasia Speaker: Ian Barwick PostgreSQL and reliability go hand-in-hand - but your data is only truly safe with a solid and trusted backup system in place, and no matter how good your application is, it's useless if it can't talk to your database. In this talk we'll demonstrate how to set up a reliable replication cluster using open source tools closely associated with the PostgreSQL project. The talk will cover following areas: - how to set up and manage a replication cluster with `repmgr` - how to set up and manage reliable backups with `Barman` - how to manage failover and application connections with `repmgr` and `PgBouncer` Ian Barwick has worked for 2ndQuadrant since 2014, and as well as making various contributions to PostgreSQL itself, is lead `repmgr` developer. He lives in Tokyo, Japan. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/ianbarwick-managingreplicationclustersrepmgrbarmanpgbouncer-180324171404-thumbnail.jpg?width=120&height=120&fit=bounds" /> Speaker: Ian Barwick PostgreSQL and reliability go hand-in-hand - but your data is only truly safe with a solid and trusted backup system in place, and no matter how good your application is, it's useless if it can't talk to your database. In this talk we'll demonstrate how to set up a reliable replication cluster using open source tools closely associated with the PostgreSQL project. The talk will cover following areas: - how to set up and manage a replication cluster with `repmgr` - how to set up and manage reliable backups with `Barman` - how to manage failover and application connections with `repmgr` and `PgBouncer` Ian Barwick has worked for 2ndQuadrant since 2014, and as well as making various contributions to PostgreSQL itself, is lead `repmgr` developer. He lives in Tokyo, Japan.

PGConf APAC 2018 - Managing replication clusters with repmgr, Barman and PgBouncer from PGConf APAC

]]> 1715 2 https://cdn.slidesharecdn.com/ss_thumbnails/ianbarwick-managingreplicationclustersrepmgrbarmanpgbouncer-180324171404-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 PGConf APAC 2018 - PostgreSQL HA with Pgpool-II and whats been happening in Pgpool-II world lately.... /slideshow/postgresql-ha-with-pgpoolii-and-whats-been-happening-in-pgpoolii-world-lately/91811717 muhhammadusama-postgresqlhawithpgpool-iiandwhatsbeen-180324171130
Speaker: Muhammad Usama Pgpool-II has been around to complement PostgreSQL over a decade and provides many features like connection pooling, failover, query caching, load balancing, and HA. High Availability (HA) is very critical to most enterprise application, the clients needs the ability to automatically reconnect with a secondary node when the master nodes goes down. This is where Pgpool-II watchdog feature comes in, the core feature of Pgpool-II provides HA by eliminating the SPOF is the Watchdog. This watchdog feature has been around for a while but it went through major overhauling and enhancements in recent releases. This talk aims to explain the watchdog feature, the recent enhancements went into the watchdog and describe how it can be used to provide PostgreSQL HA and automatic failover. Their is rising trend of enterprise deployment shifting to cloud based environment, Pgpool II can be used in the cloud without any issues. In this talk we will give some ideas how Pgpool-II is used to provide PostgreSQL HA in cloud environment. Finally we will summarise the major features that have been added in the recent major release of Pgpool II and whats in the pipeline for the next major release.]]>
Speaker: Muhammad Usama Pgpool-II has been around to complement PostgreSQL over a decade and provides many features like connection pooling, failover, query caching, load balancing, and HA. High Availability (HA) is very critical to most enterprise application, the clients needs the ability to automatically reconnect with a secondary node when the master nodes goes down. This is where Pgpool-II watchdog feature comes in, the core feature of Pgpool-II provides HA by eliminating the SPOF is the Watchdog. This watchdog feature has been around for a while but it went through major overhauling and enhancements in recent releases. This talk aims to explain the watchdog feature, the recent enhancements went into the watchdog and describe how it can be used to provide PostgreSQL HA and automatic failover. Their is rising trend of enterprise deployment shifting to cloud based environment, Pgpool II can be used in the cloud without any issues. In this talk we will give some ideas how Pgpool-II is used to provide PostgreSQL HA in cloud environment. Finally we will summarise the major features that have been added in the recent major release of Pgpool II and whats in the pipeline for the next major release.]]> Sat, 24 Mar 2018 17:11:30 GMT /slideshow/postgresql-ha-with-pgpoolii-and-whats-been-happening-in-pgpoolii-world-lately/91811717 pgdayasia@slideshare.net(pgdayasia) PGConf APAC 2018 - PostgreSQL HA with Pgpool-II and whats been happening in Pgpool-II world lately.... pgdayasia Speaker: Muhammad Usama Pgpool-II has been around to complement PostgreSQL over a decade and provides many features like connection pooling, failover, query caching, load balancing, and HA. High Availability (HA) is very critical to most enterprise application, the clients needs the ability to automatically reconnect with a secondary node when the master nodes goes down. This is where Pgpool-II watchdog feature comes in, the core feature of Pgpool-II provides HA by eliminating the SPOF is the Watchdog. This watchdog feature has been around for a while but it went through major overhauling and enhancements in recent releases. This talk aims to explain the watchdog feature, the recent enhancements went into the watchdog and describe how it can be used to provide PostgreSQL HA and automatic failover. Their is rising trend of enterprise deployment shifting to cloud based environment, Pgpool II can be used in the cloud without any issues. In this talk we will give some ideas how Pgpool-II is used to provide PostgreSQL HA in cloud environment. Finally we will summarise the major features that have been added in the recent major release of Pgpool II and whats in the pipeline for the next major release. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/muhhammadusama-postgresqlhawithpgpool-iiandwhatsbeen-180324171130-thumbnail.jpg?width=120&height=120&fit=bounds" /> Speaker: Muhammad Usama Pgpool-II has been around to complement PostgreSQL over a decade and provides many features like connection pooling, failover, query caching, load balancing, and HA. High Availability (HA) is very critical to most enterprise application, the clients needs the ability to automatically reconnect with a secondary node when the master nodes goes down. This is where Pgpool-II watchdog feature comes in, the core feature of Pgpool-II provides HA by eliminating the SPOF is the Watchdog. This watchdog feature has been around for a while but it went through major overhauling and enhancements in recent releases. This talk aims to explain the watchdog feature, the recent enhancements went into the watchdog and describe how it can be used to provide PostgreSQL HA and automatic failover. Their is rising trend of enterprise deployment shifting to cloud based environment, Pgpool II can be used in the cloud without any issues. In this talk we will give some ideas how Pgpool-II is used to provide PostgreSQL HA in cloud environment. Finally we will summarise the major features that have been added in the recent major release of Pgpool II and whats in the pipeline for the next major release.

PGConf APAC 2018 - PostgreSQL HA with Pgpool-II and whats been happening in Pgpool-II world lately.... from PGConf APAC

]]> 704 2 https://cdn.slidesharecdn.com/ss_thumbnails/muhhammadusama-postgresqlhawithpgpool-iiandwhatsbeen-180324171130-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 PGConf APAC 2018 - PostgreSQL performance comparison in various clouds /slideshow/postgresql-performance-comparison-in-various-clouds/91811540 oskarisaarenmaa-postgresqlcloudperformance-180324170908
Speaker: Oskari Saarenmaa Aiven PostgreSQL is available in five different public cloud providers' infrastructure in more than 60 regions around the world, including 18 in APAC. This has given us a unique opportunity to benchmark and compare performance of similar configurations in different environments. We'll share our benchmark methods and results, comparing various PostgreSQL configurations and workloads across different clouds.]]>
Speaker: Oskari Saarenmaa Aiven PostgreSQL is available in five different public cloud providers' infrastructure in more than 60 regions around the world, including 18 in APAC. This has given us a unique opportunity to benchmark and compare performance of similar configurations in different environments. We'll share our benchmark methods and results, comparing various PostgreSQL configurations and workloads across different clouds.]]> Sat, 24 Mar 2018 17:09:08 GMT /slideshow/postgresql-performance-comparison-in-various-clouds/91811540 pgdayasia@slideshare.net(pgdayasia) PGConf APAC 2018 - PostgreSQL performance comparison in various clouds pgdayasia Speaker: Oskari Saarenmaa Aiven PostgreSQL is available in five different public cloud providers' infrastructure in more than 60 regions around the world, including 18 in APAC. This has given us a unique opportunity to benchmark and compare performance of similar configurations in different environments. We'll share our benchmark methods and results, comparing various PostgreSQL configurations and workloads across different clouds. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/oskarisaarenmaa-postgresqlcloudperformance-180324170908-thumbnail.jpg?width=120&height=120&fit=bounds" /> Speaker: Oskari Saarenmaa Aiven PostgreSQL is available in five different public cloud providers' infrastructure in more than 60 regions around the world, including 18 in APAC. This has given us a unique opportunity to benchmark and compare performance of similar configurations in different environments. We'll share our benchmark methods and results, comparing various PostgreSQL configurations and workloads across different clouds.

PGConf APAC 2018 - PostgreSQL performance comparison in various clouds from PGConf APAC

]]> 359 3 https://cdn.slidesharecdn.com/ss_thumbnails/oskarisaarenmaa-postgresqlcloudperformance-180324170908-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 Sponsored Talk @ PGConf APAC 2018 - Migrating Oracle to EDB Postgres Approach and Use Case Study /slideshow/migrating-oracle-to-edb-postgres-approach-and-use-case-study/91811465 jenishvyas-pgconfsingaporeedbpresentationv3-180324170814
Sponsored Talk by Jenish Vyas of EnterpriseDB (Gold Sponsor for PGConf APAC 2018).]]>
Sponsored Talk by Jenish Vyas of EnterpriseDB (Gold Sponsor for PGConf APAC 2018).]]> Sat, 24 Mar 2018 17:08:13 GMT /slideshow/migrating-oracle-to-edb-postgres-approach-and-use-case-study/91811465 pgdayasia@slideshare.net(pgdayasia) Sponsored Talk @ PGConf APAC 2018 - Migrating Oracle to EDB Postgres Approach and Use Case Study pgdayasia Sponsored Talk by Jenish Vyas of EnterpriseDB (Gold Sponsor for PGConf APAC 2018). <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/jenishvyas-pgconfsingaporeedbpresentationv3-180324170814-thumbnail.jpg?width=120&height=120&fit=bounds" /> Sponsored Talk by Jenish Vyas of EnterpriseDB (Gold Sponsor for PGConf APAC 2018).

Sponsored Talk @ PGConf APAC 2018 - Migrating Oracle to EDB Postgres Approach and Use Case Study from PGConf APAC

]]> 178 5 https://cdn.slidesharecdn.com/ss_thumbnails/jenishvyas-pgconfsingaporeedbpresentationv3-180324170814-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 PGConf APAC 2018 - Tale from Trenches /slideshow/tale-from-trenches/91811232 sameerkumar-talefromtrenches-180324170509
About a year ago I was caught up in line-of-fire when a production system started behaving abruptly - A batch process which would finish in 15minutes started taking 1.5 hours - We started facing OLTP read queries on standby being cancelled - We faced a sudden slowness on the Primary server and we were forced to do a forceful switch to standby. We were able to figure out that some peculiarities of the application code and batch process were responsible for this. But we could not fix the application code (as it is packaged application). In this talk I would like to share more details of how we debugged, what was the problem we were facing and how we applied a work around for it. We also learnt that a query returning in 10minutes may not be as dangerous as a query returning in 10sec but executed 100s of times in an hour. I will share in detail- - How to map the process/top stats from OS with pg_stat_activity - How to get and read explain plan - How to judge if a query is costly - What tools helped us - A peculiar autovacuum/vacuum Vs Replication conflict we ran into - Various parameters to tune autvacuum and auto-analyze process - What we have done to work-around the problem - What we have put in place for better monitoring and information gathering ]]>
About a year ago I was caught up in line-of-fire when a production system started behaving abruptly - A batch process which would finish in 15minutes started taking 1.5 hours - We started facing OLTP read queries on standby being cancelled - We faced a sudden slowness on the Primary server and we were forced to do a forceful switch to standby. We were able to figure out that some peculiarities of the application code and batch process were responsible for this. But we could not fix the application code (as it is packaged application). In this talk I would like to share more details of how we debugged, what was the problem we were facing and how we applied a work around for it. We also learnt that a query returning in 10minutes may not be as dangerous as a query returning in 10sec but executed 100s of times in an hour. I will share in detail- - How to map the process/top stats from OS with pg_stat_activity - How to get and read explain plan - How to judge if a query is costly - What tools helped us - A peculiar autovacuum/vacuum Vs Replication conflict we ran into - Various parameters to tune autvacuum and auto-analyze process - What we have done to work-around the problem - What we have put in place for better monitoring and information gathering ]]> Sat, 24 Mar 2018 17:05:09 GMT /slideshow/tale-from-trenches/91811232 pgdayasia@slideshare.net(pgdayasia) PGConf APAC 2018 - Tale from Trenches pgdayasia About a year ago I was caught up in line-of-fire when a production system started behaving abruptly - A batch process which would finish in 15minutes started taking 1.5 hours - We started facing OLTP read queries on standby being cancelled - We faced a sudden slowness on the Primary server and we were forced to do a forceful switch to standby. We were able to figure out that some peculiarities of the application code and batch process were responsible for this. But we could not fix the application code (as it is packaged application). In this talk I would like to share more details of how we debugged, what was the problem we were facing and how we applied a work around for it. We also learnt that a query returning in 10minutes may not be as dangerous as a query returning in 10sec but executed 100s of times in an hour. I will share in detail- - How to map the process/top stats from OS with pg_stat_activity - How to get and read explain plan - How to judge if a query is costly - What tools helped us - A peculiar autovacuum/vacuum Vs Replication conflict we ran into - Various parameters to tune autvacuum and auto-analyze process - What we have done to work-around the problem - What we have put in place for better monitoring and information gathering <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sameerkumar-talefromtrenches-180324170509-thumbnail.jpg?width=120&height=120&fit=bounds" /> About a year ago I was caught up in line-of-fire when a production system started behaving abruptly - A batch process which would finish in 15minutes started taking 1.5 hours - We started facing OLTP read queries on standby being cancelled - We faced a sudden slowness on the Primary server and we were forced to do a forceful switch to standby. We were able to figure out that some peculiarities of the application code and batch process were responsible for this. But we could not fix the application code (as it is packaged application). In this talk I would like to share more details of how we debugged, what was the problem we were facing and how we applied a work around for it. We also learnt that a query returning in 10minutes may not be as dangerous as a query returning in 10sec but executed 100s of times in an hour. I will share in detail- - How to map the process/top stats from OS with pg_stat_activity - How to get and read explain plan - How to judge if a query is costly - What tools helped us - A peculiar autovacuum/vacuum Vs Replication conflict we ran into - Various parameters to tune autvacuum and auto-analyze process - What we have done to work-around the problem - What we have put in place for better monitoring and information gathering

PGConf APAC 2018 - Tale from Trenches from PGConf APAC

]]> 260 1 https://cdn.slidesharecdn.com/ss_thumbnails/sameerkumar-talefromtrenches-180324170509-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 PGConf APAC 2018 Keynote: PostgreSQL goes eleven /slideshow/keynote-postgresql-goes-eleven/91810963 pggoes2eleven-pgconf-180324170127
PostgreSQL goes eleven]]>
PostgreSQL goes eleven]]> Sat, 24 Mar 2018 17:01:27 GMT /slideshow/keynote-postgresql-goes-eleven/91810963 pgdayasia@slideshare.net(pgdayasia) PGConf APAC 2018 Keynote: PostgreSQL goes eleven pgdayasia PostgreSQL goes eleven <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/pggoes2eleven-pgconf-180324170127-thumbnail.jpg?width=120&height=120&fit=bounds" /> PostgreSQL goes eleven

PGConf APAC 2018 Keynote: PostgreSQL goes eleven from PGConf APAC

]]> 166 1 https://cdn.slidesharecdn.com/ss_thumbnails/pggoes2eleven-pgconf-180324170127-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 Amazon (AWS) Aurora /slideshow/amazon-aws-aurora/74776691 pgdayasia-amazonaurora-170410024330
This presentation was used by Blair during his talk on Aurora and PostgreSQl compatibility for Aurora at pgDay Asia 2017. The talk was part of dedicated PostgreSQL track at FOSSASIA 2017]]>
This presentation was used by Blair during his talk on Aurora and PostgreSQl compatibility for Aurora at pgDay Asia 2017. The talk was part of dedicated PostgreSQL track at FOSSASIA 2017]]> Mon, 10 Apr 2017 02:43:30 GMT /slideshow/amazon-aws-aurora/74776691 pgdayasia@slideshare.net(pgdayasia) Amazon (AWS) Aurora pgdayasia This presentation was used by Blair during his talk on Aurora and PostgreSQl compatibility for Aurora at pgDay Asia 2017. The talk was part of dedicated PostgreSQL track at FOSSASIA 2017 <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/pgdayasia-amazonaurora-170410024330-thumbnail.jpg?width=120&height=120&fit=bounds" /> This presentation was used by Blair during his talk on Aurora and PostgreSQl compatibility for Aurora at pgDay Asia 2017. The talk was part of dedicated PostgreSQL track at FOSSASIA 2017

Amazon (AWS) Aurora from PGConf APAC

]]> 761 5 https://cdn.slidesharecdn.com/ss_thumbnails/pgdayasia-amazonaurora-170410024330-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 Use Case: PostGIS and Agribotics /slideshow/use-case-postgis-and-agribotics/73327824 postgisandagribotics-170320003828
This ppt was used by Gary for his talk on PostGIS and Agribotics at pgDay Asia 2017]]>
This ppt was used by Gary for his talk on PostGIS and Agribotics at pgDay Asia 2017]]> Mon, 20 Mar 2017 00:38:28 GMT /slideshow/use-case-postgis-and-agribotics/73327824 pgdayasia@slideshare.net(pgdayasia) Use Case: PostGIS and Agribotics pgdayasia This ppt was used by Gary for his talk on PostGIS and Agribotics at pgDay Asia 2017 <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/postgisandagribotics-170320003828-thumbnail.jpg?width=120&height=120&fit=bounds" /> This ppt was used by Gary for his talk on PostGIS and Agribotics at pgDay Asia 2017

Use Case: PostGIS and Agribotics from PGConf APAC

]]> 745 7 https://cdn.slidesharecdn.com/ss_thumbnails/postgisandagribotics-170320003828-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 teach an elephant to rock'n'roll /slideshow/how-to-teach-an-elephant-to-rocknroll/73295091 maximpgdayasia2017-170319053541
This presentation was used by Maxim Boguk to talk about some really advaced query tuning techniques!]]>
This presentation was used by Maxim Boguk to talk about some really advaced query tuning techniques!]]> Sun, 19 Mar 2017 05:35:41 GMT /slideshow/how-to-teach-an-elephant-to-rocknroll/73295091 pgdayasia@slideshare.net(pgdayasia) How to teach an elephant to rock'n'roll pgdayasia This presentation was used by Maxim Boguk to talk about some really advaced query tuning techniques! <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/maximpgdayasia2017-170319053541-thumbnail.jpg?width=120&height=120&fit=bounds" /> This presentation was used by Maxim Boguk to talk about some really advaced query tuning techniques!

How to teach an elephant to rock'n'roll from PGConf APAC

]]> 3506 4 https://cdn.slidesharecdn.com/ss_thumbnails/maximpgdayasia2017-170319053541-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 PostgreSQL on Amazon RDS /slideshow/postgresql-on-amazon-rds/73284194 postgresqlonamazonrds-170318160902
PostgreSQL is one of the most loved databases and that is why AWS could not hold back from offering PostgreSQL as RDS. There are some really nice features in RDS which can be good for DBA and inspiring for Enterprises to build resilient solution with PostgreSQL.]]>
PostgreSQL is one of the most loved databases and that is why AWS could not hold back from offering PostgreSQL as RDS. There are some really nice features in RDS which can be good for DBA and inspiring for Enterprises to build resilient solution with PostgreSQL.]]> Sat, 18 Mar 2017 16:09:02 GMT /slideshow/postgresql-on-amazon-rds/73284194 pgdayasia@slideshare.net(pgdayasia) PostgreSQL on Amazon RDS pgdayasia PostgreSQL is one of the most loved databases and that is why AWS could not hold back from offering PostgreSQL as RDS. There are some really nice features in RDS which can be good for DBA and inspiring for Enterprises to build resilient solution with PostgreSQL. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/postgresqlonamazonrds-170318160902-thumbnail.jpg?width=120&height=120&fit=bounds" /> PostgreSQL is one of the most loved databases and that is why AWS could not hold back from offering PostgreSQL as RDS. There are some really nice features in RDS which can be good for DBA and inspiring for Enterprises to build resilient solution with PostgreSQL.

PostgreSQL on Amazon RDS from PGConf APAC

]]> 435 5 https://cdn.slidesharecdn.com/ss_thumbnails/postgresqlonamazonrds-170318160902-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-pgdayasia-48x48.jpg?cb=1525231506 PGConf APAC is the PostgreSQL conference series for all PostgreSQL enthusiasts in the Asia Pacific region. The third PGConf APAC will be held from 22nd – 23rd March, 2018. pgconfapac.org https://cdn.slidesharecdn.com/ss_thumbnails/thegrowingmandatoryrequirementstoprotectdata-180326021108-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/pgconf-apac-2018-sponsored-talk-by-fujitsu-the-growing-mandatory-requirements-to-protect-data-91894192/91894192 PGConf APAC 2018: Spon... https://cdn.slidesharecdn.com/ss_thumbnails/replication-goes-logical-180326020759-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/pgconf-apac-2018-postgresql-10-replication-goes-logical/91894067 PGConf APAC 2018: Post... https://cdn.slidesharecdn.com/ss_thumbnails/lightningtalkhowtocontributetopostgresqlcommunity-180324173824-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/lightening-talk-3-how-to-contribute-to-postgresql/91813732 PGConf APAC 2018 - Lig...