| Postgres Weekly | Issue 56
May 1, 2014
|
| | PostgreSQL: A Full Text Search Engine - Part 1 | |
While you can do basic LIKE queries with Postgres, it can go much further when it comes to text search. Here’s a great overview of what features are available and what full text search in Postgres can do.
| | Tim van der Linden |
|
| Putting stats_temp_directory On A RAM Disk | |
Postgres keeps a lot of various stats under the hood to help the planner work out how to best execute various queries. A little known trick is that you can set up the stats directory on to a RAM disk which has higher risk for loss but can significantly improve performance.
| | Quinn Weaver |
|
| Check out DB Weekly, our general database newsletter | |
DB Weekly is now a few months old and continues to coverage database trends and new releases and technologies each week. Issue 11 looks at Crate Data, a new massively scalable data store, a video guide to DBAs, using normalization on SQL databases, and more. It's a great way to keep your finger on the pulse of database related developments.
| | Cooper Press Sponsored |
|
| Table Partitioning in PostgreSQL | |
When tables pass millions of rows and you’re commonly reporting against them table partitioning may or may not give you some performance improvements. Here’s a basic guide on implementing it.
| | Agnieszka Figiel |
|
| UPSERTisms in Postgres, Part 2: Congestion | |
Last week we highlighted the performance difference of implementing upsert a few different ways in Postgres. There was some response to it, and as a result here’s a followup of how the performance looks with concurrency.
| | Marko Tiikkaja |
|
| |
|