Skip to content

Instantly share code, notes, and snippets.

@wlaurance

wlaurance/pgqs.md

Created March 24, 2014 19:00
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save wlaurance/9746795 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save wlaurance/9746795 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres questions
Raw
pgqs.md

Postgres

###How to * ?

  • monitor
  • backup
  • restore from backup
  • replicate
  • keep hot spare ready
@wlaurance
Copy link
Author

wlaurance commented Mar 31, 2014

http://instagram-engineering.tumblr.com/post/40781627982/handling-growth-with-postgres-5-tips-from-instagram

@wlaurance
Copy link
Author

wlaurance commented Mar 31, 2014

https://www.youtube.com/watch?v=twTWnZb0Ib4

@wlaurance
Copy link
Author

wlaurance commented Apr 4, 2014

Postgres Hardware Optimization Guide http://momjian.us/main/writings/pgsql/hw_performance/index.html

@wlaurance
Copy link
Author

wlaurance commented Apr 4, 2014

S3 WAL backup http://blog.opbeat.com/posts/postgresql-backup-to-s3-part-one/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment