| Postgres Weekly |
Issue 77
October 15, 2014
|
|
| PostgreSQL 9.4 Beta 3 Released |
|
We’ve all been excitedly waiting for Postgres 9.4 and in particular the new JSONB features, and while we have a little longer to wait, the latest beta with fixes is here and available now.
|
| postgresql.org |
|
| Following a Select Statement Through Postgres Internals |
|
This is hands down the best walk through I’ve seen of what happens when you run a standard SELECT query in Postgres. If you’re an end user and want to dig a little deeper this walk through is a great start.
|
| Pat Shaughnessy |
|
| Pagination Done the Right Way |
|
Paginated results can often wreck havoc on the performance of your database. If you need to paginate anything in your app, here’s what you need to know.
|
| Markus Winand |
|
| Exploring the Postgres Gin index |
|
Postgres has a pretty vast array of Postgres indexes, all of which can be immensly valuable, but you have to know when to use which. Gin is one of the lesser known, but can be especially handy and here’s the perfect crash course.
|
| Derek Parker |
|
| SQL for Marketers |
|
SQL isn’t the most friendly of languages, but it is incredibly powerful. Furthermore, the amount of valuable data that lies in relational databases continues to grow, if you’re not a developer here’s an awesome intro to SQL.
|
| Periscope |
|
|
|
|