The latest articles on DEV Community by Matt Davis (@logandavis343). https://dev.to/logandavis343 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F108194%2Fd8b494db-c945-4da1-921c-8f0b0f90bbc1.jpeg https://dev.to/logandavis343 en Matt Davis Mon, 05 Nov 2018 14:15:48 +0000 https://dev.to/logandavis343/postgresql-efficient-queries---indexing-5656 https://dev.to/logandavis343/postgresql-efficient-queries---indexing-5656 <p><a href="https://www.smoothterminal.com/articles/efficient-queries-indexing">PostgreSQL: Efficient Queries - Indexing</a></p> <p>For those who have been following this series, you will know that we have seen some in depth ways we can analyze and understand what is going on within our queries. Now we're going to focus on a few things we can do to make them a little more efficient. Let's get started.</p> postgres sql tutorial Matt Davis Fri, 02 Nov 2018 15:28:54 +0000 https://dev.to/logandavis343/explaining-postgresql-37kh https://dev.to/logandavis343/explaining-postgresql-37kh <h2> <a href="https://www.smoothterminal.com/articles/explain" rel="noopener noreferrer">Explaining PostgreSQL</a> </h2> <p>Hey guys and welcome to our continuing series on performance tuning our PostgreSQL databases. Today we're focusing on a very important method in the PostgreSQL command line up and that is explanation. To understand the idea behind explanation we first need to gain an understanding about the PostgreSQL query planner. For those who have watched our video about <a href="https://www.smoothterminal.com/articles/analyze" rel="noopener noreferrer">analyzing</a>, some of this will be a review. For others, this will be critical information.</p> postgres tutorial sql Matt Davis Fri, 26 Oct 2018 16:10:24 +0000 https://dev.to/logandavis343/postgresql-analyze-2l6b https://dev.to/logandavis343/postgresql-analyze-2l6b <p><a href="https://www.smoothterminal.com/articles/analyze">https://www.smoothterminal.com/articles/analyze</a></p> <p>Hey guys, we've written an article on keeping PostgreSQL updated on the status of our tables so it can run queries as efficiently as possible.</p> postgres tutorial performance Matt Davis Wed, 24 Oct 2018 13:56:36 +0000 https://dev.to/logandavis343/postgresql-vacuum--autovacuum-2jc5 https://dev.to/logandavis343/postgresql-vacuum--autovacuum-2jc5 <p>Hey guys, in this article we'll be focusing on understanding a narrow but very critical aspect of performance tuning with PostgreSQL. Specifically, we're going to be discussing Vacuum and Autovacuum.</p> <p><a href="https://www.smoothterminal.com/articles/vacuum-autovacuum">PostgreSQL: Vacuum / Autovacuum</a></p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--PisG-_xc--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://blog.hostonnet.com/wp-content/uploads/2013/06/postgresql.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--PisG-_xc--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://blog.hostonnet.com/wp-content/uploads/2013/06/postgresql.png" alt="PostgreSQL"></a></p> postgres tutorial autovacuum Matt Davis Mon, 22 Oct 2018 15:23:33 +0000 https://dev.to/logandavis343/getting-started-with-react-360-and-elixir-1h48 https://dev.to/logandavis343/getting-started-with-react-360-and-elixir-1h48 <h4>Great walkthrough explaining how to configure and use React 360, phoenix, and Elixir.</h4> <p><a href="https://www.smoothterminal.com/articles/getting-started-with-react-360-and-elixir">Getting Started with React 360 and Elixir</a></p> react360 elixir tutorial Matt Davis Thu, 18 Oct 2018 15:12:31 +0000 https://dev.to/logandavis343/postgresql-configuration-part-2-479b https://dev.to/logandavis343/postgresql-configuration-part-2-479b <p><a href="https://www.smoothterminal.com/articles/general-configuration-1">https://www.smoothterminal.com/articles/general-configuration-1</a></p> postgres learning tutorial Matt Davis Wed, 17 Oct 2018 14:20:14 +0000 https://dev.to/logandavis343/dropbox-details-their-edge-services-on-replacing-redux-and-the-debate-over-protobuffers-16db https://dev.to/logandavis343/dropbox-details-their-edge-services-on-replacing-redux-and-the-debate-over-protobuffers-16db <p><a href="https://www.smoothterminal.com/articles/dropbox-details-their-edge-services-on-replacing-redux-and-the-debate-over-protobuffers">https://www.smoothterminal.com/articles/dropbox-details-their-edge-services-on-replacing-redux-and-the-debate-over-protobuffers</a></p> Matt Davis Tue, 16 Oct 2018 13:27:53 +0000 https://dev.to/logandavis343/postgresql-4k0l https://dev.to/logandavis343/postgresql-4k0l <p>Get up and running with PostgreSQL!</p> <p><a href="https://www.smoothterminal.com/articles/general-configuration-1">https://www.smoothterminal.com/articles/general-configuration-1</a></p> postgres setup installation