5 ms·
As someone who's familiar and uses postgres, but not familiar with the more detailed things databases/postgres related where would be a good place to start? I
by tabeth 9y ago
As someone who's familiar and uses postgres, but not familiar with the more detailed things databases/postgres related where would be a good place to start?
I don't know what I don't know and am not familiar with situations in which the new functionality introduced here should be used.
TLDR: am database/postgres noob. Help?
- zitterbewegung 9y agoThe manuals are really well written and easy to access. I would start at the release notes from the manual and then look at the corresponding manual pages. https://www.postgresql.org/docs/10/static/release-10.html#idm46046834158304 https://www.postgresql.org/docs/10/static/release-10.html#id... https://www.postgresql.org/docs/ https://www.postgresql.org/docs/
- tibbon 9y agoI find they are well written for some things, but not others. They are good manuals for documentation, but not guides. I was trying to read about certain lock events recently, and understand their impacts, and aside from a single reference in the manually there was absolutely nothing. They tell the what, but rarely the why.
- tarsinge 9y agoNot specific to Postgres but I found that knowing how to write complex and efficient SQL queries can be overlooked but is a very useful skill, and then understanding indexes and query plans allows to drastically improve performances and thus reduce scaling needs Edit: wording
- snuxoll 9y agoUnderstanding your database configuration is important as well. I spent way longer than I'd like to admit trying to improve performance of complex query that would not execute the way I wanted it to no matter what, PostgreSQL absolutely refused to use a calculated index on one table and then do a HASH JOIN to a second, instead devolving into some really hairy execution plan I can't even remember at this point. Turns out, I had done everything right in my index design and query - but due to the sheer volume of data the query planner didn't use the "correct" plan because work_mem was set too low. Always be mindful of how your database is tuned, you could be doing everything right but the query planner will seem to act insane regardless.
- mamcx 9y agoThis have help me in discover extra powers of sql: http://modern-sql.com/ http://modern-sql.com/ And http://use-the-index-luke.com/ http://use-the-index-luke.com/
- skizm 9y agoSort of random/oddly specific usecase, but this article helped me understand a bit more of what happens under the hood with both PostgeSQL and MySQL: https://eng.uber.com/mysql-migration/ https://eng.uber.com/mysql-migration/ It is a fairly easy read, even for someone (like myself) who has very little knowledge of what's actually going on under the hood of most DBs.
- cookiecaper 9y agoFurther reference material: - PgSQL mailing list thread discussing Uber's post: https://www.postgresql.org/message-id/579795DF.10502%40commandprompt.com https://www.postgresql.org/message-id/579795DF.10502%40comma... - Slides from "A PostgreSQL Response to Uber", a talk that provides the PgSQL-perspective counterarguments to the Uber post: http://thebuild.com/presentations/uber-perconalive-2017.pdf http://thebuild.com/presentations/uber-perconalive-2017.pdf [PDF] - Previous HN discussion on the above: https://news.ycombinator.com/item?id=14222721 https://news.ycombinator.com/item?id=14222721 - Slides from "Migrating Uber from MySQL to Postgres" (2013), in which Uber's prior migration _to_ PgSQL is discussed: https://www.yumpu.com/en/document/view/53683323/migrating-uber-from-mysql-to-postgresql https://www.yumpu.com/en/document/view/53683323/migrating-ub...
- skizm 9y agoHa! I had no idea this article was so hotly contested. I'll definitely be reading through the links. Thanks.
- why-el 9y agoI would suggest the database courses from CMU. Really good stuff and free online.
- rbjorklin 9y agoWhat’s CMU? Do you have a link?
- deleted 9y ago[deleted]
- jalcazar 9y agoCarnegie Mellon University. Private research university in Pittsburgh, Pennsylvania with a strong CS department. https://www.youtube.com/watch?v=MyQzjba1beA&list=PLSE8ODhjZXjbisIGOepfnlbfxeH7TW-8O https://www.youtube.com/watch?v=MyQzjba1beA&list=PLSE8ODhjZX...
- polskibus 9y agoAndy Pavlo and Peloton db are the best!
- why-el 9y agoAs the others have mentioned. Sorry for the laziness, I wrote while on the go.
- tofflos 9y agoI fully support learning for learning’ sake. But you could also view the new features as solutions to problems. If you don’t feel you’re having problems then you’re probably not missing out. There is no inherent value in using the new functionality. If you do have a specific problem then you could ask the community about that and they will help you determine whether there is new functionality that addresses it. Then go read about it in the manual, try it out, and see if it works for you. I find learning from solving my own problems easier than reading a manual cover to cover.
- pletnes 9y agoI’ve seen devs thinking like that for decades. Since they already know Fortran 77, which is a Turing complete language, they can solve any computing problem. Still, I’d argue that it’s valuable to explore new things, at least at the level where you get an overview of which tool to use for which job.
- qaq 9y agoHow deep do you want to go Bruce Momjian has a ton of talks on internals and other advanced topics so if you want to dig deep would highly recommend them : https://momjian.us/ https://momjian.us/
- welder 9y agoUse a cloud database: https://www.graph.cool/ https://www.graph.cool/