�ݺ�ߣshows by User: jim

�ݺ�ߣshows by User: jim_mlodgenski / http://www.slideshare.net/images/logo.gif �ݺ�ߣshows by User: jim_mlodgenski / Fri, 13 Oct 2017 13:01:25 GMT �ݺ�ߣShare feed for �ݺ�ߣshows by User: jim_mlodgenski Strategic autovacuum /slideshow/strategic-autovacuum/80776926 strategicautovacuum-171013130125
This talk describes how to tune PostgreSQL's autovacuum]]>
This talk describes how to tune PostgreSQL's autovacuum]]> Fri, 13 Oct 2017 13:01:25 GMT /slideshow/strategic-autovacuum/80776926 jim_mlodgenski@slideshare.net(jim_mlodgenski) Strategic autovacuum jim_mlodgenski This talk describes how to tune PostgreSQL's autovacuum <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/strategicautovacuum-171013130125-thumbnail.jpg?width=120&height=120&fit=bounds" /> This talk describes how to tune PostgreSQL's autovacuum

Strategic autovacuum from Jim Mlodgenski

]]> 704 5 https://cdn.slidesharecdn.com/ss_thumbnails/strategicautovacuum-171013130125-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 Top 10 Mistakes When Migrating From Oracle to PostgreSQL /slideshow/top-10-mistakes-when-migrating-from-oracle-to-postgresql/78128048 ora-pg-mirgration-top-10-170721163711
As more and more people are moving to PostgreSQL from Oracle, a pattern of mistakes is emerging. They can be caused by the tools being used or just not understanding how PostgreSQL is different than Oracle. In this talk we will discuss the top mistakes people generally make when moving to PostgreSQL from Oracle and what the correct course of action. ]]>
As more and more people are moving to PostgreSQL from Oracle, a pattern of mistakes is emerging. They can be caused by the tools being used or just not understanding how PostgreSQL is different than Oracle. In this talk we will discuss the top mistakes people generally make when moving to PostgreSQL from Oracle and what the correct course of action. ]]> Fri, 21 Jul 2017 16:37:11 GMT /slideshow/top-10-mistakes-when-migrating-from-oracle-to-postgresql/78128048 jim_mlodgenski@slideshare.net(jim_mlodgenski) Top 10 Mistakes When Migrating From Oracle to PostgreSQL jim_mlodgenski As more and more people are moving to PostgreSQL from Oracle, a pattern of mistakes is emerging. They can be caused by the tools being used or just not understanding how PostgreSQL is different than Oracle. In this talk we will discuss the top mistakes people generally make when moving to PostgreSQL from Oracle and what the correct course of action. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/ora-pg-mirgration-top-10-170721163711-thumbnail.jpg?width=120&height=120&fit=bounds" /> As more and more people are moving to PostgreSQL from Oracle, a pattern of mistakes is emerging. They can be caused by the tools being used or just not understanding how PostgreSQL is different than Oracle. In this talk we will discuss the top mistakes people generally make when moving to PostgreSQL from Oracle and what the correct course of action.

Top 10 Mistakes When Migrating From Oracle to PostgreSQL from Jim Mlodgenski

]]> 3765 13 https://cdn.slidesharecdn.com/ss_thumbnails/ora-pg-mirgration-top-10-170721163711-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 Oracle postgre sql-mirgration-top-10-mistakes /slideshow/oracle-postgre-sqlmirgrationtop10mistakes/76936228 oracle-postgresql-mirgration-top-10-mistakes-170614120453
The top 10 mistakes people make when they are migrating from Oracle to PostgreSQL]]>
The top 10 mistakes people make when they are migrating from Oracle to PostgreSQL]]> Wed, 14 Jun 2017 12:04:53 GMT /slideshow/oracle-postgre-sqlmirgrationtop10mistakes/76936228 jim_mlodgenski@slideshare.net(jim_mlodgenski) Oracle postgre sql-mirgration-top-10-mistakes jim_mlodgenski The top 10 mistakes people make when they are migrating from Oracle to PostgreSQL <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/oracle-postgresql-mirgration-top-10-mistakes-170614120453-thumbnail.jpg?width=120&height=120&fit=bounds" /> The top 10 mistakes people make when they are migrating from Oracle to PostgreSQL

Oracle postgre sql-mirgration-top-10-mistakes from Jim Mlodgenski

]]> 745 3 https://cdn.slidesharecdn.com/ss_thumbnails/oracle-postgresql-mirgration-top-10-mistakes-170614120453-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 Profiling PL/pgSQL /slideshow/profiling-plpgsql/64257250 plpgsqlprofile-160721175919
This talk describes the plProfiler for PostgreSQL.]]>
This talk describes the plProfiler for PostgreSQL.]]> Thu, 21 Jul 2016 17:59:19 GMT /slideshow/profiling-plpgsql/64257250 jim_mlodgenski@slideshare.net(jim_mlodgenski) Profiling PL/pgSQL jim_mlodgenski This talk describes the plProfiler for PostgreSQL. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/plpgsqlprofile-160721175919-thumbnail.jpg?width=120&height=120&fit=bounds" /> This talk describes the plProfiler for PostgreSQL.

Profiling PL/pgSQL from Jim Mlodgenski

]]> 1362 2 https://cdn.slidesharecdn.com/ss_thumbnails/plpgsqlprofile-160721175919-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 Debugging Your PL/pgSQL Code /slideshow/debugging-your-plpgsql-code/54571385 plpgsqldebugging-151030153917-lva1-app6892
PL/pgSQL is a very robust development language allowing you to write complex business logic. The downside is as the complexity of your functions grows, how do you debug them? We have all used RAISE statements to print out the progress of our functions, but they can quickly overwhelm your logs becoming useless. In this talk, we will: - Walk through the setup of 2 key PostgreSQL extensions, the PL/pgSQL Debugger and the PL Profiler - Demonstrate how the PL Profiler can identify problem areas in your functions - Setting breakpoints in functions and triggers - Stepping through PL/pgSQL functions - Discuss the performance impact of running the extensions on production environments ]]>
PL/pgSQL is a very robust development language allowing you to write complex business logic. The downside is as the complexity of your functions grows, how do you debug them? We have all used RAISE statements to print out the progress of our functions, but they can quickly overwhelm your logs becoming useless. In this talk, we will: - Walk through the setup of 2 key PostgreSQL extensions, the PL/pgSQL Debugger and the PL Profiler - Demonstrate how the PL Profiler can identify problem areas in your functions - Setting breakpoints in functions and triggers - Stepping through PL/pgSQL functions - Discuss the performance impact of running the extensions on production environments ]]> Fri, 30 Oct 2015 15:39:16 GMT /slideshow/debugging-your-plpgsql-code/54571385 jim_mlodgenski@slideshare.net(jim_mlodgenski) Debugging Your PL/pgSQL Code jim_mlodgenski PL/pgSQL is a very robust development language allowing you to write complex business logic. The downside is as the complexity of your functions grows, how do you debug them? We have all used RAISE statements to print out the progress of our functions, but they can quickly overwhelm your logs becoming useless. In this talk, we will: - Walk through the setup of 2 key PostgreSQL extensions, the PL/pgSQL Debugger and the PL Profiler - Demonstrate how the PL Profiler can identify problem areas in your functions - Setting breakpoints in functions and triggers - Stepping through PL/pgSQL functions - Discuss the performance impact of running the extensions on production environments <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/plpgsqldebugging-151030153917-lva1-app6892-thumbnail.jpg?width=120&height=120&fit=bounds" /> PL/pgSQL is a very robust development language allowing you to write complex business logic. The downside is as the complexity of your functions grows, how do you debug them? We have all used RAISE statements to print out the progress of our functions, but they can quickly overwhelm your logs becoming useless. In this talk, we will: - Walk through the setup of 2 key PostgreSQL extensions, the PL/pgSQL Debugger and the PL Profiler - Demonstrate how the PL Profiler can identify problem areas in your functions - Setting breakpoints in functions and triggers - Stepping through PL/pgSQL functions - Discuss the performance impact of running the extensions on production environments

Debugging Your PL/pgSQL Code from Jim Mlodgenski

]]> 1591 4 https://cdn.slidesharecdn.com/ss_thumbnails/plpgsqldebugging-151030153917-lva1-app6892-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 An Introduction To PostgreSQL Triggers /slideshow/an-introduction-to-postresql-triggers/54571300 triggers-intro-151030153659-lva1-app6891
Triggers are those little bits of code running in your database that gets executed when something happens that you care about. Whether you are a developer who puts all of your business logic inside of PL/pgSQL functions or someone who uses an ORM and wants to stay away from database code, you will likely end up using triggers at some point. The fact that the most recommend way of implementing table partitioning in PostgreSQL uses triggers accounts for the importance of understanding triggers. In this talk, we will step through examples of writing various types of triggers using practical uses cases like partitioning and auditing. The structure of a trigger BEFORE vs AFTER triggers Statement Level vs Row Level triggers Conditional triggers Event triggers Debugging triggers Performance overhead of triggers All of the examples will be done using PL/pgSQL so in addition to getting an overview of triggers, you will also get a good understanding of how to code in PL/pgSQL.]]>
Triggers are those little bits of code running in your database that gets executed when something happens that you care about. Whether you are a developer who puts all of your business logic inside of PL/pgSQL functions or someone who uses an ORM and wants to stay away from database code, you will likely end up using triggers at some point. The fact that the most recommend way of implementing table partitioning in PostgreSQL uses triggers accounts for the importance of understanding triggers. In this talk, we will step through examples of writing various types of triggers using practical uses cases like partitioning and auditing. The structure of a trigger BEFORE vs AFTER triggers Statement Level vs Row Level triggers Conditional triggers Event triggers Debugging triggers Performance overhead of triggers All of the examples will be done using PL/pgSQL so in addition to getting an overview of triggers, you will also get a good understanding of how to code in PL/pgSQL.]]> Fri, 30 Oct 2015 15:36:59 GMT /slideshow/an-introduction-to-postresql-triggers/54571300 jim_mlodgenski@slideshare.net(jim_mlodgenski) An Introduction To PostgreSQL Triggers jim_mlodgenski Triggers are those little bits of code running in your database that gets executed when something happens that you care about. Whether you are a developer who puts all of your business logic inside of PL/pgSQL functions or someone who uses an ORM and wants to stay away from database code, you will likely end up using triggers at some point. The fact that the most recommend way of implementing table partitioning in PostgreSQL uses triggers accounts for the importance of understanding triggers. In this talk, we will step through examples of writing various types of triggers using practical uses cases like partitioning and auditing. The structure of a trigger BEFORE vs AFTER triggers Statement Level vs Row Level triggers Conditional triggers Event triggers Debugging triggers Performance overhead of triggers All of the examples will be done using PL/pgSQL so in addition to getting an overview of triggers, you will also get a good understanding of how to code in PL/pgSQL. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/triggers-intro-151030153659-lva1-app6891-thumbnail.jpg?width=120&height=120&fit=bounds" /> Triggers are those little bits of code running in your database that gets executed when something happens that you care about. Whether you are a developer who puts all of your business logic inside of PL/pgSQL functions or someone who uses an ORM and wants to stay away from database code, you will likely end up using triggers at some point. The fact that the most recommend way of implementing table partitioning in PostgreSQL uses triggers accounts for the importance of understanding triggers. In this talk, we will step through examples of writing various types of triggers using practical uses cases like partitioning and auditing. The structure of a trigger BEFORE vs AFTER triggers Statement Level vs Row Level triggers Conditional triggers Event triggers Debugging triggers Performance overhead of triggers All of the examples will be done using PL/pgSQL so in addition to getting an overview of triggers, you will also get a good understanding of how to code in PL/pgSQL.

An Introduction To PostgreSQL Triggers from Jim Mlodgenski

]]> 2564 5 https://cdn.slidesharecdn.com/ss_thumbnails/triggers-intro-151030153659-lva1-app6891-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 Procedural Languages: Tips, Tricks and Gotchas /slideshow/postgresql-functions/45099071 postgresqlfunctions-150224190325-conversion-gate01
One of the most powerful features of PostgreSQL is its diversity of procedural languages, but with that diversity comes a lot of options. Did you ever wonder: - What all of those options are on the CREATE FUNCTION statement? - How do they affect my application? - Does my choice of procedural language affect the performance of my statements? - Should I create a single trigger with IF statements or several simple triggers? - How do I debug my code? - Can I tell which line in my function is taking all of the time?]]>
One of the most powerful features of PostgreSQL is its diversity of procedural languages, but with that diversity comes a lot of options. Did you ever wonder: - What all of those options are on the CREATE FUNCTION statement? - How do they affect my application? - Does my choice of procedural language affect the performance of my statements? - Should I create a single trigger with IF statements or several simple triggers? - How do I debug my code? - Can I tell which line in my function is taking all of the time?]]> Tue, 24 Feb 2015 19:03:25 GMT /slideshow/postgresql-functions/45099071 jim_mlodgenski@slideshare.net(jim_mlodgenski) PostgreSQL Procedural Languages: Tips, Tricks and Gotchas jim_mlodgenski One of the most powerful features of PostgreSQL is its diversity of procedural languages, but with that diversity comes a lot of options. Did you ever wonder: - What all of those options are on the CREATE FUNCTION statement? - How do they affect my application? - Does my choice of procedural language affect the performance of my statements? - Should I create a single trigger with IF statements or several simple triggers? - How do I debug my code? - Can I tell which line in my function is taking all of the time? <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/postgresqlfunctions-150224190325-conversion-gate01-thumbnail.jpg?width=120&height=120&fit=bounds" /> One of the most powerful features of PostgreSQL is its diversity of procedural languages, but with that diversity comes a lot of options. Did you ever wonder: - What all of those options are on the CREATE FUNCTION statement? - How do they affect my application? - Does my choice of procedural language affect the performance of my statements? - Should I create a single trigger with IF statements or several simple triggers? - How do I debug my code? - Can I tell which line in my function is taking all of the time?

PostgreSQL Procedural Languages: Tips, Tricks and Gotchas from Jim Mlodgenski

]]> 2261 1 https://cdn.slidesharecdn.com/ss_thumbnails/postgresqlfunctions-150224190325-conversion-gate01-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 Introduction to PostgreSQL /slideshow/introduction-to-postgresql-42011208/42011208 postgresqlintro-141125113058-conversion-gate01
This is a introduction to PostgreSQL that provides a brief overview of PostgreSQL's architecture, features and ecosystem. It was delivered at NYLUG on Nov 24, 2014. http://www.meetup.com/nylug-meetings/events/180533472/]]>
This is a introduction to PostgreSQL that provides a brief overview of PostgreSQL's architecture, features and ecosystem. It was delivered at NYLUG on Nov 24, 2014. http://www.meetup.com/nylug-meetings/events/180533472/]]> Tue, 25 Nov 2014 11:30:57 GMT /slideshow/introduction-to-postgresql-42011208/42011208 jim_mlodgenski@slideshare.net(jim_mlodgenski) Introduction to PostgreSQL jim_mlodgenski This is a introduction to PostgreSQL that provides a brief overview of PostgreSQL's architecture, features and ecosystem. It was delivered at NYLUG on Nov 24, 2014. http://www.meetup.com/nylug-meetings/events/180533472/ <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/postgresqlintro-141125113058-conversion-gate01-thumbnail.jpg?width=120&height=120&fit=bounds" /> This is a introduction to PostgreSQL that provides a brief overview of PostgreSQL's architecture, features and ecosystem. It was delivered at NYLUG on Nov 24, 2014. http://www.meetup.com/nylug-meetings/events/180533472/

Introduction to PostgreSQL from Jim Mlodgenski

]]> 6639 5 https://cdn.slidesharecdn.com/ss_thumbnails/postgresqlintro-141125113058-conversion-gate01-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post

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

0 Postgresql Federation /jim_mlodgenski/postgresql-fedaration postgresqlfedaration-140221131236-phpapp02
As more and more alternative data stores come into use, the problem of being able to easily use and report on the data scattered across those data stores becomes increasingly difficult. PostgreSQL has a feature called Foreign Data Wrappers that allows external data sources to be queried from PostgreSQL and look like a standard table. Using Foreign Data Wrappers, users can create a report that joins data residing in Oracle, Hadoop and MongoDB all in a single query. In this talk, we'll discuss how to set up a Foreign Data Wrapper for various data sources and the pros and cons using them. We'll also discuss the growing ecosystem of Foreign Data Wrapper and a little about how to write one. ]]>
As more and more alternative data stores come into use, the problem of being able to easily use and report on the data scattered across those data stores becomes increasingly difficult. PostgreSQL has a feature called Foreign Data Wrappers that allows external data sources to be queried from PostgreSQL and look like a standard table. Using Foreign Data Wrappers, users can create a report that joins data residing in Oracle, Hadoop and MongoDB all in a single query. In this talk, we'll discuss how to set up a Foreign Data Wrapper for various data sources and the pros and cons using them. We'll also discuss the growing ecosystem of Foreign Data Wrapper and a little about how to write one. ]]> Fri, 21 Feb 2014 13:12:36 GMT /jim_mlodgenski/postgresql-fedaration jim_mlodgenski@slideshare.net(jim_mlodgenski) Postgresql Federation jim_mlodgenski As more and more alternative data stores come into use, the problem of being able to easily use and report on the data scattered across those data stores becomes increasingly difficult. PostgreSQL has a feature called Foreign Data Wrappers that allows external data sources to be queried from PostgreSQL and look like a standard table. Using Foreign Data Wrappers, users can create a report that joins data residing in Oracle, Hadoop and MongoDB all in a single query. In this talk, we'll discuss how to set up a Foreign Data Wrapper for various data sources and the pros and cons using them. We'll also discuss the growing ecosystem of Foreign Data Wrapper and a little about how to write one. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/postgresqlfedaration-140221131236-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds" /> As more and more alternative data stores come into use, the problem of being able to easily use and report on the data scattered across those data stores becomes increasingly difficult. PostgreSQL has a feature called Foreign Data Wrappers that allows external data sources to be queried from PostgreSQL and look like a standard table. Using Foreign Data Wrappers, users can create a report that joins data residing in Oracle, Hadoop and MongoDB all in a single query. In this talk, we'll discuss how to set up a Foreign Data Wrapper for various data sources and the pros and cons using them. We'll also discuss the growing ecosystem of Foreign Data Wrapper and a little about how to write one.

Postgresql Federation from Jim Mlodgenski

]]> 6536 5 https://cdn.slidesharecdn.com/ss_thumbnails/postgresqlfedaration-140221131236-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post

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

0 Leveraging Hadoop in your PostgreSQL Environment /slideshow/postrgesql-hadoop/23619992 postrgesqlhadoop-130628094421-phpapp01
This talk will begin with a discussion of the strengths of PostgreSQL and Hadoop. We will then lead into a high level overview of Hadoop and its community of projects like Hive, Flume and Sqoop. Finally, we will dig down into various use cases detailing how you can leverage Hadoop technologies for your PostgreSQL databases today. The use cases will range from using HDFS for simple database backups to using PostgreSQL and Foreign Data Wrappers to do low latency analytics on your Big Data.]]>
This talk will begin with a discussion of the strengths of PostgreSQL and Hadoop. We will then lead into a high level overview of Hadoop and its community of projects like Hive, Flume and Sqoop. Finally, we will dig down into various use cases detailing how you can leverage Hadoop technologies for your PostgreSQL databases today. The use cases will range from using HDFS for simple database backups to using PostgreSQL and Foreign Data Wrappers to do low latency analytics on your Big Data.]]> Fri, 28 Jun 2013 09:44:21 GMT /slideshow/postrgesql-hadoop/23619992 jim_mlodgenski@slideshare.net(jim_mlodgenski) Leveraging Hadoop in your PostgreSQL Environment jim_mlodgenski This talk will begin with a discussion of the strengths of PostgreSQL and Hadoop. We will then lead into a high level overview of Hadoop and its community of projects like Hive, Flume and Sqoop. Finally, we will dig down into various use cases detailing how you can leverage Hadoop technologies for your PostgreSQL databases today. The use cases will range from using HDFS for simple database backups to using PostgreSQL and Foreign Data Wrappers to do low latency analytics on your Big Data. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/postrgesqlhadoop-130628094421-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds" /> This talk will begin with a discussion of the strengths of PostgreSQL and Hadoop. We will then lead into a high level overview of Hadoop and its community of projects like Hive, Flume and Sqoop. Finally, we will dig down into various use cases detailing how you can leverage Hadoop technologies for your PostgreSQL databases today. The use cases will range from using HDFS for simple database backups to using PostgreSQL and Foreign Data Wrappers to do low latency analytics on your Big Data.

Leveraging Hadoop in your PostgreSQL Environment from Jim Mlodgenski

]]> 14032 6 https://cdn.slidesharecdn.com/ss_thumbnails/postrgesqlhadoop-130628094421-phpapp01-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 Scaling PostreSQL with Stado /slideshow/scaling-postresql-with-stado/9478813 scalingpostresqlwithstado-110929165517-phpapp02
]]>
]]> Thu, 29 Sep 2011 16:55:14 GMT /slideshow/scaling-postresql-with-stado/9478813 jim_mlodgenski@slideshare.net(jim_mlodgenski) Scaling PostreSQL with Stado jim_mlodgenski <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/scalingpostresqlwithstado-110929165517-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds" />

Scaling PostreSQL with Stado from Jim Mlodgenski

]]> 3088 5 https://cdn.slidesharecdn.com/ss_thumbnails/scalingpostresqlwithstado-110929165517-phpapp02-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 Multi-Master Replication with Slony /slideshow/multimaster-replication-with-slony/7452950 slonymultimaster-110330154442-phpapp02
ne of the most sought after features in PostgreSQL is a scalable multi-master replication solution. While there does exists some tools to create multi-master clusters such as Bucardo and pgpool-II, they may not be the right fit for an application. In this session, you will learn some of the strengths and weaknesses of these more popular multi-master solutions for PostgreSQL and how they compare to using Slony for your multi-master needs. We will explore the types of deployments best suited for a Slony deployment and the steps necessary to configure a multi-master solution for PostgreSQL.]]>
ne of the most sought after features in PostgreSQL is a scalable multi-master replication solution. While there does exists some tools to create multi-master clusters such as Bucardo and pgpool-II, they may not be the right fit for an application. In this session, you will learn some of the strengths and weaknesses of these more popular multi-master solutions for PostgreSQL and how they compare to using Slony for your multi-master needs. We will explore the types of deployments best suited for a Slony deployment and the steps necessary to configure a multi-master solution for PostgreSQL.]]> Wed, 30 Mar 2011 15:44:38 GMT /slideshow/multimaster-replication-with-slony/7452950 jim_mlodgenski@slideshare.net(jim_mlodgenski) Multi-Master Replication with Slony jim_mlodgenski ne of the most sought after features in PostgreSQL is a scalable multi-master replication solution. While there does exists some tools to create multi-master clusters such as Bucardo and pgpool-II, they may not be the right fit for an application. In this session, you will learn some of the strengths and weaknesses of these more popular multi-master solutions for PostgreSQL and how they compare to using Slony for your multi-master needs. We will explore the types of deployments best suited for a Slony deployment and the steps necessary to configure a multi-master solution for PostgreSQL. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/slonymultimaster-110330154442-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds" /> ne of the most sought after features in PostgreSQL is a scalable multi-master replication solution. While there does exists some tools to create multi-master clusters such as Bucardo and pgpool-II, they may not be the right fit for an application. In this session, you will learn some of the strengths and weaknesses of these more popular multi-master solutions for PostgreSQL and how they compare to using Slony for your multi-master needs. We will explore the types of deployments best suited for a Slony deployment and the steps necessary to configure a multi-master solution for PostgreSQL.

Multi-Master Replication with Slony from Jim Mlodgenski

]]> 4530 4 https://cdn.slidesharecdn.com/ss_thumbnails/slonymultimaster-110330154442-phpapp02-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 Scaling PostgreSQL With GridSQL /slideshow/scaling-postgresql-with-gridsql/7452910 scalingwithgridsql-110330154056-phpapp01
GridSQL is commonly thought of as a replication solution along the likes of Slony and Bucardo, but the open source GridSQL project actually allows PostgreSQL queries to be parallelized across many servers allowing performance to scale nearly linearly. In this session, we will discuss the advantages to using GridSQL for large multi-terabyte data warehouses and how to design your PostgreSQL schemas and queries to leverage GridSQL. We will dig into how GridSQL plans a query capable of spanning multiple PostgreSQL servers and executes across those nodes. We will delve into some performance expectations and where GridSQL should be deployed.]]>
GridSQL is commonly thought of as a replication solution along the likes of Slony and Bucardo, but the open source GridSQL project actually allows PostgreSQL queries to be parallelized across many servers allowing performance to scale nearly linearly. In this session, we will discuss the advantages to using GridSQL for large multi-terabyte data warehouses and how to design your PostgreSQL schemas and queries to leverage GridSQL. We will dig into how GridSQL plans a query capable of spanning multiple PostgreSQL servers and executes across those nodes. We will delve into some performance expectations and where GridSQL should be deployed.]]> Wed, 30 Mar 2011 15:40:54 GMT /slideshow/scaling-postgresql-with-gridsql/7452910 jim_mlodgenski@slideshare.net(jim_mlodgenski) Scaling PostgreSQL With GridSQL jim_mlodgenski GridSQL is commonly thought of as a replication solution along the likes of Slony and Bucardo, but the open source GridSQL project actually allows PostgreSQL queries to be parallelized across many servers allowing performance to scale nearly linearly. In this session, we will discuss the advantages to using GridSQL for large multi-terabyte data warehouses and how to design your PostgreSQL schemas and queries to leverage GridSQL. We will dig into how GridSQL plans a query capable of spanning multiple PostgreSQL servers and executes across those nodes. We will delve into some performance expectations and where GridSQL should be deployed. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/scalingwithgridsql-110330154056-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds" /> GridSQL is commonly thought of as a replication solution along the likes of Slony and Bucardo, but the open source GridSQL project actually allows PostgreSQL queries to be parallelized across many servers allowing performance to scale nearly linearly. In this session, we will discuss the advantages to using GridSQL for large multi-terabyte data warehouses and how to design your PostgreSQL schemas and queries to leverage GridSQL. We will dig into how GridSQL plans a query capable of spanning multiple PostgreSQL servers and executes across those nodes. We will delve into some performance expectations and where GridSQL should be deployed.

Scaling PostgreSQL With GridSQL from Jim Mlodgenski

]]> 3921 4 https://cdn.slidesharecdn.com/ss_thumbnails/scalingwithgridsql-110330154056-phpapp01-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://public.slidesharecdn.com/v2/images/profile-picture.png https://cdn.slidesharecdn.com/ss_thumbnails/strategicautovacuum-171013130125-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/strategic-autovacuum/80776926 Strategic autovacuum https://cdn.slidesharecdn.com/ss_thumbnails/ora-pg-mirgration-top-10-170721163711-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/top-10-mistakes-when-migrating-from-oracle-to-postgresql/78128048 Top 10 Mistakes When M... https://cdn.slidesharecdn.com/ss_thumbnails/oracle-postgresql-mirgration-top-10-mistakes-170614120453-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/oracle-postgre-sqlmirgrationtop10mistakes/76936228 Oracle postgre sql-mir...