<story><title>Deploying PostgreSQL Clusters Using StatefulSets</title><url>http://blog.kubernetes.io/2017/02/postgresql-clusters-kubernetes-statefulsets.html</url></story><parent_chain><item><author>danmaz74</author><text>Slightly OT, but, from a quick glance at the post, it looks like the postgres data is persisted on a network file system.&lt;p&gt;Does anybody have any experience with a big enough and this kind of configuration, and what is the performance compared with SSD local disks? Intuitively I wouldn&amp;#x27;t expect a networked disk to be a viable solution for postgres, but seeing it proposed like this makes me think that maybe my intuition was wrong...</text></item></parent_chain><comment><author>lobster_johnson</author><text>People have run Postgres on network disks — Elastic Block Storage (EBS) volumes on AWS, or Persistent Disks on Google Cloud — for a long time.&lt;p&gt;They&amp;#x27;re implemented like a software SAN, with dedicated network paths, and throughput&amp;#x2F;latency is very good. Not as good as local, but still good enough for most apps.&lt;p&gt;On Google Cloud, you do have to option of using a local SSD [1], but it comes with a bunch of limitations. It maxes out at 375GB (though you can allocate up to 8 per VM). They&amp;#x27;re somewhat expensive. They&amp;#x27;re not durable; if you stop the VM, the disk is lost. They&amp;#x27;re classified as &amp;quot;scratch disks&amp;quot; in the UI, which is a good indicator of their intended purpose.&lt;p&gt;Edit: Using a networked &lt;i&gt;file system&lt;/i&gt;, however, is a bad idea.&lt;p&gt;[1] &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;cloud.google.com&amp;#x2F;compute&amp;#x2F;docs&amp;#x2F;disks&amp;#x2F;local-ssd&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;cloud.google.com&amp;#x2F;compute&amp;#x2F;docs&amp;#x2F;disks&amp;#x2F;local-ssd&lt;/a&gt;</text></comment>
<story><title>Deploying PostgreSQL Clusters Using StatefulSets</title><url>http://blog.kubernetes.io/2017/02/postgresql-clusters-kubernetes-statefulsets.html</url></story><parent_chain><item><author>danmaz74</author><text>Slightly OT, but, from a quick glance at the post, it looks like the postgres data is persisted on a network file system.&lt;p&gt;Does anybody have any experience with a big enough and this kind of configuration, and what is the performance compared with SSD local disks? Intuitively I wouldn&amp;#x27;t expect a networked disk to be a viable solution for postgres, but seeing it proposed like this makes me think that maybe my intuition was wrong...</text></item></parent_chain><comment><author>koolba</author><text>Forget performance, I&amp;#x27;d be more worried about file locking, file fsync, and directory fsync. All are critical for a database and an &amp;quot;optimized&amp;quot; NFS driver that lies about the latter two can lead to corruption or data loss.</text></comment>