ºÝºÝߣshows by User: hansjurgenschonig / http://www.slideshare.net/images/logo.gif ºÝºÝߣshows by User: hansjurgenschonig / Sat, 05 Nov 2016 08:51:26 GMT ºÝºÝߣShare feed for ºÝºÝߣshows by User: hansjurgenschonig PostgreSQL instance encryption: More database security /slideshow/postgresql-instance-encryption-more-database-security/68231898 tallinnkeynote-161105085126
By default PostgreSQL will store data on disk in its standard format. However, in many cases business or legal requirements require data to on disk be encrypted. On disk-encryption was paid for by German industry and is a classical case showing how business and Open Source can coexist. This talk shows, that it can be actually cheaper to implement a feature into an Open Source product than to license a commercial product such as Oracle, DB2, Informix, or MS SQL Server. Open Source can make a valuable contribution to save costs for everybody.]]>
By default PostgreSQL will store data on disk in its standard format. However, in many cases business or legal requirements require data to on disk be encrypted. On disk-encryption was paid for by German industry and is a classical case showing how business and Open Source can coexist. This talk shows, that it can be actually cheaper to implement a feature into an Open Source product than to license a commercial product such as Oracle, DB2, Informix, or MS SQL Server. Open Source can make a valuable contribution to save costs for everybody.]]> Sat, 05 Nov 2016 08:51:26 GMT /slideshow/postgresql-instance-encryption-more-database-security/68231898 hansjurgenschonig@slideshare.net(hansjurgenschonig) PostgreSQL instance encryption: More database security hansjurgenschonig By default PostgreSQL will store data on disk in its standard format. However, in many cases business or legal requirements require data to on disk be encrypted. On disk-encryption was paid for by German industry and is a classical case showing how business and Open Source can coexist. This talk shows, that it can be actually cheaper to implement a feature into an Open Source product than to license a commercial product such as Oracle, DB2, Informix, or MS SQL Server. Open Source can make a valuable contribution to save costs for everybody. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/tallinnkeynote-161105085126-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> By default PostgreSQL will store data on disk in its standard format. However, in many cases business or legal requirements require data to on disk be encrypted. On disk-encryption was paid for by German industry and is a classical case showing how business and Open Source can coexist. This talk shows, that it can be actually cheaper to implement a feature into an Open Source product than to license a commercial product such as Oracle, DB2, Informix, or MS SQL Server. Open Source can make a valuable contribution to save costs for everybody.
PostgreSQL instance encryption: More database security from Hans-J端rgen Sch旦nig
]]> 1294 2 https://cdn.slidesharecdn.com/ss_thumbnails/tallinnkeynote-161105085126-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 Replication Tutorial /slideshow/postgresql-replication-tutorial/55869435 replicationtutorial-151206174833-lva1-app6891
PostgreSQL is one of the most advanced relational databases. It offers superb replication capabilities. The most important features are: Streaming replication, Point-In-Time-Recovery, advanced monitoring, etc.]]>
PostgreSQL is one of the most advanced relational databases. It offers superb replication capabilities. The most important features are: Streaming replication, Point-In-Time-Recovery, advanced monitoring, etc.]]> Sun, 06 Dec 2015 17:48:32 GMT /slideshow/postgresql-replication-tutorial/55869435 hansjurgenschonig@slideshare.net(hansjurgenschonig) PostgreSQL Replication Tutorial hansjurgenschonig PostgreSQL is one of the most advanced relational databases. It offers superb replication capabilities. The most important features are: Streaming replication, Point-In-Time-Recovery, advanced monitoring, etc. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/replicationtutorial-151206174833-lva1-app6891-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> PostgreSQL is one of the most advanced relational databases. It offers superb replication capabilities. The most important features are: Streaming replication, Point-In-Time-Recovery, advanced monitoring, etc.
PostgreSQL Replication Tutorial from Hans-J端rgen Sch旦nig
]]> 3034 7 https://cdn.slidesharecdn.com/ss_thumbnails/replicationtutorial-151206174833-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 5min analyse https://de.slideshare.net/slideshow/5min-analyse/55869351 5minanalyse-151206174330-lva1-app6891
Performance Tuning muss in PostgreSQL nicht schwer sein. Oft reichen einige einfache Veränderung, um die Datenbank massiv zu beschleunigen. VIele Performance Probleme sind einfach zu lösen. Diese Präsentation zeigt die gängigsten Methoden, um einfache Probleme schnell und effizient zu beseitigen]]>
Performance Tuning muss in PostgreSQL nicht schwer sein. Oft reichen einige einfache Veränderung, um die Datenbank massiv zu beschleunigen. VIele Performance Probleme sind einfach zu lösen. Diese Präsentation zeigt die gängigsten Methoden, um einfache Probleme schnell und effizient zu beseitigen]]> Sun, 06 Dec 2015 17:43:30 GMT https://de.slideshare.net/slideshow/5min-analyse/55869351 hansjurgenschonig@slideshare.net(hansjurgenschonig) 5min analyse hansjurgenschonig Performance Tuning muss in PostgreSQL nicht schwer sein. Oft reichen einige einfache Veränderung, um die Datenbank massiv zu beschleunigen. VIele Performance Probleme sind einfach zu lösen. Diese Präsentation zeigt die gängigsten Methoden, um einfache Probleme schnell und effizient zu beseitigen <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/5minanalyse-151206174330-lva1-app6891-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Performance Tuning muss in PostgreSQL nicht schwer sein. Oft reichen einige einfache Veränderung, um die Datenbank massiv zu beschleunigen. VIele Performance Probleme sind einfach zu lösen. Diese Präsentation zeigt die gängigsten Methoden, um einfache Probleme schnell und effizient zu beseitigen
from Hans-J端rgen Sch旦nig
]]> 602 13 https://cdn.slidesharecdn.com/ss_thumbnails/5minanalyse-151206174330-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 Explain explain https://de.slideshare.net/slideshow/explain-explain-55869280/55869280 explainexplain-151206173909-lva1-app6891
In PostgreSQL kann man sich mit "explain" ansehen, welchen Execution Plan PostgreSQL für eine Query verwendet. Das hilft beim Suchen von Performance Problemen und hilft, den Durchsatz der Database zu steigern. ]]>
In PostgreSQL kann man sich mit "explain" ansehen, welchen Execution Plan PostgreSQL für eine Query verwendet. Das hilft beim Suchen von Performance Problemen und hilft, den Durchsatz der Database zu steigern. ]]> Sun, 06 Dec 2015 17:39:09 GMT https://de.slideshare.net/slideshow/explain-explain-55869280/55869280 hansjurgenschonig@slideshare.net(hansjurgenschonig) Explain explain hansjurgenschonig In PostgreSQL kann man sich mit "explain" ansehen, welchen Execution Plan PostgreSQL für eine Query verwendet. Das hilft beim Suchen von Performance Problemen und hilft, den Durchsatz der Database zu steigern. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/explainexplain-151206173909-lva1-app6891-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> In PostgreSQL kann man sich mit &quot;explain&quot; ansehen, welchen Execution Plan PostgreSQL für eine Query verwendet. Das hilft beim Suchen von Performance Problemen und hilft, den Durchsatz der Database zu steigern.
from Hans-J端rgen Sch旦nig
]]> 386 6 https://cdn.slidesharecdn.com/ss_thumbnails/explainexplain-151206173909-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: Eigene Aggregate schreiben https://de.slideshare.net/slideshow/postgresql-eigene-aggregate-schreiben/50466353 deaggregationhowto-150713125704-lva1-app6892
This talk describes how somebody can write his or her own PostgreSQL custom aggregation functions. Hans also shows, how to run windowing functions and analytics to handle data in PostgreSQL.]]>
This talk describes how somebody can write his or her own PostgreSQL custom aggregation functions. Hans also shows, how to run windowing functions and analytics to handle data in PostgreSQL.]]> Mon, 13 Jul 2015 12:57:04 GMT https://de.slideshare.net/slideshow/postgresql-eigene-aggregate-schreiben/50466353 hansjurgenschonig@slideshare.net(hansjurgenschonig) PostgreSQL: Eigene Aggregate schreiben hansjurgenschonig This talk describes how somebody can write his or her own PostgreSQL custom aggregation functions. Hans also shows, how to run windowing functions and analytics to handle data in PostgreSQL. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/deaggregationhowto-150713125704-lva1-app6892-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> This talk describes how somebody can write his or her own PostgreSQL custom aggregation functions. Hans also shows, how to run windowing functions and analytics to handle data in PostgreSQL.
from Hans-J端rgen Sch旦nig
]]> 1168 113 https://cdn.slidesharecdn.com/ss_thumbnails/deaggregationhowto-150713125704-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 PostgreSQL: The NoSQL way https://de.slideshare.net/slideshow/postgresql-the-nosql-way/47853188 nosql-150507080954-lva1-app6891
PostgreSQL is not only a relational database - it also provides powerful NoSQL functionality such as superior JSON support and so on.]]>
PostgreSQL is not only a relational database - it also provides powerful NoSQL functionality such as superior JSON support and so on.]]> Thu, 07 May 2015 08:09:54 GMT https://de.slideshare.net/slideshow/postgresql-the-nosql-way/47853188 hansjurgenschonig@slideshare.net(hansjurgenschonig) PostgreSQL: The NoSQL way hansjurgenschonig PostgreSQL is not only a relational database - it also provides powerful NoSQL functionality such as superior JSON support and so on. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/nosql-150507080954-lva1-app6891-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> PostgreSQL is not only a relational database - it also provides powerful NoSQL functionality such as superior JSON support and so on.
from Hans-J端rgen Sch旦nig
]]> 1359 75 https://cdn.slidesharecdn.com/ss_thumbnails/nosql-150507080954-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: Data analysis and analytics /slideshow/postgresql-data-analysis-and-analytics/45794037 dataanalysis-150313062033-conversion-gate01
This talk shows, how business intelligence can be performed with PostgreSQL. It features advanced SQL including aggregations, analytics as well as more sophisticated joins such as LATERAL. In addition to that loading data as well as optimizing storage are discussed.]]>
This talk shows, how business intelligence can be performed with PostgreSQL. It features advanced SQL including aggregations, analytics as well as more sophisticated joins such as LATERAL. In addition to that loading data as well as optimizing storage are discussed.]]> Fri, 13 Mar 2015 06:20:33 GMT /slideshow/postgresql-data-analysis-and-analytics/45794037 hansjurgenschonig@slideshare.net(hansjurgenschonig) PostgreSQL: Data analysis and analytics hansjurgenschonig This talk shows, how business intelligence can be performed with PostgreSQL. It features advanced SQL including aggregations, analytics as well as more sophisticated joins such as LATERAL. In addition to that loading data as well as optimizing storage are discussed. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/dataanalysis-150313062033-conversion-gate01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> This talk shows, how business intelligence can be performed with PostgreSQL. It features advanced SQL including aggregations, analytics as well as more sophisticated joins such as LATERAL. In addition to that loading data as well as optimizing storage are discussed.
PostgreSQL: Data analysis and analytics from Hans-J端rgen Sch旦nig
]]> 3798 6 https://cdn.slidesharecdn.com/ss_thumbnails/dataanalysis-150313062033-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 PostgreSQL: Advanced indexing /slideshow/postgresql-advanced-indexing/45741578 2013dublinindexing-150312031852-conversion-gate01
This one is about advanced indexing in PostgreSQL. It guides you through basic concepts as well as through advanced techniques to speed up the database. All important PostgreSQL Index types explained: btree, gin, gist, sp-gist and hashes. Regular expression indexes and LIKE queries are also covered.]]>
This one is about advanced indexing in PostgreSQL. It guides you through basic concepts as well as through advanced techniques to speed up the database. All important PostgreSQL Index types explained: btree, gin, gist, sp-gist and hashes. Regular expression indexes and LIKE queries are also covered.]]> Thu, 12 Mar 2015 03:18:52 GMT /slideshow/postgresql-advanced-indexing/45741578 hansjurgenschonig@slideshare.net(hansjurgenschonig) PostgreSQL: Advanced indexing hansjurgenschonig This one is about advanced indexing in PostgreSQL. It guides you through basic concepts as well as through advanced techniques to speed up the database. All important PostgreSQL Index types explained: btree, gin, gist, sp-gist and hashes. Regular expression indexes and LIKE queries are also covered. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/2013dublinindexing-150312031852-conversion-gate01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> This one is about advanced indexing in PostgreSQL. It guides you through basic concepts as well as through advanced techniques to speed up the database. All important PostgreSQL Index types explained: btree, gin, gist, sp-gist and hashes. Regular expression indexes and LIKE queries are also covered.
PostgreSQL: Advanced indexing from Hans-J端rgen Sch旦nig
]]> 2799 3 https://cdn.slidesharecdn.com/ss_thumbnails/2013dublinindexing-150312031852-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 Walbouncer: Filtering PostgreSQL transaction log /slideshow/walbouncer/45741261 walbouncer-150312030723-conversion-gate01
PostgreSQL is a strong relational database which is highly capable of replication. As of PostgreSQL 9.4 streaming replication is only able to replicate an entire database instance. Walbouncer allows to filter the PostgreSQL WAL and partial replicate single databases.]]>
PostgreSQL is a strong relational database which is highly capable of replication. As of PostgreSQL 9.4 streaming replication is only able to replicate an entire database instance. Walbouncer allows to filter the PostgreSQL WAL and partial replicate single databases.]]> Thu, 12 Mar 2015 03:07:22 GMT /slideshow/walbouncer/45741261 hansjurgenschonig@slideshare.net(hansjurgenschonig) Walbouncer: Filtering PostgreSQL transaction log hansjurgenschonig PostgreSQL is a strong relational database which is highly capable of replication. As of PostgreSQL 9.4 streaming replication is only able to replicate an entire database instance. Walbouncer allows to filter the PostgreSQL WAL and partial replicate single databases. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/walbouncer-150312030723-conversion-gate01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> PostgreSQL is a strong relational database which is highly capable of replication. As of PostgreSQL 9.4 streaming replication is only able to replicate an entire database instance. Walbouncer allows to filter the PostgreSQL WAL and partial replicate single databases.
Walbouncer: Filtering PostgreSQL transaction log from Hans-J端rgen Sch旦nig
]]> 941 2 https://cdn.slidesharecdn.com/ss_thumbnails/walbouncer-150312030723-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 PostgreSQL: Joining 1 million tables /slideshow/postgresql-joining-1-million-tables/45740963 1million-150312025557-conversion-gate01
In SQL joins are a fundamental concepts and many database engines have serious problems when it comes to joining many many tables. PostgreSQL is a pretty cool database - the question is just: How many joins can it take? It is known that Oracle does not accept insanely long queries and MySQL is known to core dump with 2000 tables. This talk shows how to join 1 million tables with PostgreSQL.]]>
In SQL joins are a fundamental concepts and many database engines have serious problems when it comes to joining many many tables. PostgreSQL is a pretty cool database - the question is just: How many joins can it take? It is known that Oracle does not accept insanely long queries and MySQL is known to core dump with 2000 tables. This talk shows how to join 1 million tables with PostgreSQL.]]> Thu, 12 Mar 2015 02:55:57 GMT /slideshow/postgresql-joining-1-million-tables/45740963 hansjurgenschonig@slideshare.net(hansjurgenschonig) PostgreSQL: Joining 1 million tables hansjurgenschonig In SQL joins are a fundamental concepts and many database engines have serious problems when it comes to joining many many tables. PostgreSQL is a pretty cool database - the question is just: How many joins can it take? It is known that Oracle does not accept insanely long queries and MySQL is known to core dump with 2000 tables. This talk shows how to join 1 million tables with PostgreSQL. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/1million-150312025557-conversion-gate01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> In SQL joins are a fundamental concepts and many database engines have serious problems when it comes to joining many many tables. PostgreSQL is a pretty cool database - the question is just: How many joins can it take? It is known that Oracle does not accept insanely long queries and MySQL is known to core dump with 2000 tables. This talk shows how to join 1 million tables with PostgreSQL.
PostgreSQL: Joining 1 million tables from Hans-J端rgen Sch旦nig
]]> 6036 3 https://cdn.slidesharecdn.com/ss_thumbnails/1million-150312025557-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 https://public.slidesharecdn.com/v2/images/profile-picture.png https://cdn.slidesharecdn.com/ss_thumbnails/tallinnkeynote-161105085126-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/postgresql-instance-encryption-more-database-security/68231898 PostgreSQL instance en... https://cdn.slidesharecdn.com/ss_thumbnails/replicationtutorial-151206174833-lva1-app6891-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/postgresql-replication-tutorial/55869435 PostgreSQL Replication... https://cdn.slidesharecdn.com/ss_thumbnails/5minanalyse-151206174330-lva1-app6891-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/5min-analyse/55869351 5min analyse