title: Hidden Features of PostgreSQL
body: <p>I'm surprised this hasn't been posted yet. Any interesting tricks that you know about in Postgres? Obscure config options and scaling/perf tricks are particularly welcome. </p>
  
  <p>I'm sure we can beat the 9 comments on the corresponding <a href="https://stackoverflow.com/questions/368858/hidden-features-of-mysql/600830#600830">MySQL thread</a> :)</p>