Postgres в облаках

Possibly related…

  1. SE-Radio Episode 328: Bruce Momjian on the Postgres Query Planner : Software Engineering Radio

    SE-Radio Episode 328: Bruce Momjian on the Postgres Query Planner

    Filed in Episodes

    by SE-Radio

    on June 19, 2018

    • 0 Comments

    Bruce Momjian, a longtime Postgres developer, educator and consultant joins Robert Blumen for a discussion of the SQL query planner in the Postgres relational database. Topics covered include what is a query? How queries are evaluated by the server; the phases of query evaluation; SQL as a declarative language; why declarative query evaluation is simpler and more productive that it would be for a developer to write queries in an imperative language; what is a query plan? The elements of a query plan; the impact of table ordering on query performance; joins; indexes; how the query planner works; size of the query plan space; optimizing plans versus good enough; balancing the time spent query planning against the time spent executing; what is the cost function? And does the cost function correspond to real-world query performance?; challenges in planning sorts and aggregations; debugging query plans; testing and regression of the query planner; how to test and validate query plans in the software development process; can this model be used to other SQL back ends than a file-based database? (example Hadoop); research on query planning; the open source Postgres project.

    Related Links

    Episode 310: Kirk Pepperdine on Performance Optimization

    Episode 225: Brendan Gregg on Systems Performance

    Episode 125: Performance Engineering with Chris Grindstaff

    Postgres web site

    Bruce Momjian’s web site

    Bruce Momjian’s slide decks on Postgres performance

    Oracle Optimizer Blog

    Inside the SQL Server Query Optimizer by Brian Nevarez

    Book: SQL Server Execution Plans

    http://traffic.libsyn.com/seradio/SE-Radio-Episode-328-Bruce-Momjian-on-the-Postgres-Query-Planner.mp3Podcast: Play in new window | DownloadSubscribe: iTunes | Android | RSS

    http://www.se-radio.net/2018/06/se-radio-episode-328-bruce-momjian-on-the-postgres-query-planner/

    —Huffduffed by agileone

  2. A Beautiful Thing (Harold Giménez)

    This week on Giant Robots, Ben Orenstein speaks with Harold Giménez, Heroku postgres leader, about postgres, data management, and beer brewing.

    http://podcasts.thoughtbot.com/giantrobots/77

    —Huffduffed by friedjoff

  3. Herding Code 224: Jeremy Miller on Marten, Postgres and Alba

    The gang talks to Jeremy Miller about some of his open source projects.

    Download / Listen: Herding Code 224: Jeremy Miller on Marten, Postgres and Alba

    http://herdingcode.com/herding-code-224-jeremy-miller-on-marten-postgres-and-alba/

    —Huffduffed by robomark

  4. SE-Radio Episode 362: Simon Riggs on Advanced Features of PostgreSQL : Software Engineering Radio

    SE-Radio Episode 362: Simon Riggs on Advanced Features of PostgreSQL

    Filed in Episodes

    by SE-Radio

    on April 10, 2019

    • 0 Comments

    Simon Riggs, founder and CTO of 2nd Quadrant, discusses the advanced features of the Postgres database, that allow developers to focus on applications whilst the database does the heavy lifting of handling large and diverse quantities of data. Host Simon Crossley spoke with Riggs about advanced SQL, indexes, extensibility and scale; using window functions to calculate aggregates on subsets of data; common table expressions to write performant graph queries within Postgres; user defined data types and user defined functions to support GIS, full text and time series data; foreign Data Wrappers to access data from other datastores such as MySQL, Mongo; block range indexes, generalized indexes, nearest-neighbor indexes; replication and high availability, hot stand-by nodes; zero downtime upgrades using logical replication; ease of use: robustness, accuracy, trust; securing data with encryption and authentication; levels of transaction isolation

    Related Links

    https://www.postgresql.org/

    https://postgresconf.org/

    https://www.postgresql.org/about/featurematrix/

    https://www.2ndquadrant.com/en/postgresql/postgresql-story/

    http://www.craigkerstiens.com/2018/01/31/postgres-hidden-gems/

    http://www.se-radio.net/2012/04/episode-185-dwight-merriman-on-replication/

    http://www.se-radio.net/2018/06/se-radio-episode-328-bruce-momjian-on-the-postgres-query-planner/

    http://traffic.libsyn.com/seradio/SE-Radio-Episode-362-Simon-Riggs-on-Advanced-Features-of-PostgreSQL.mp3Podcast: Play in new window | DownloadSubscribe: iTunes | Android | RSS

    https://www.se-radio.net/2019/04/se-radio-episode-362-simon-riggs-on-advanced-features-of-postgresql/

    —Huffduffed by agileone

  5. Uber’s Postgres Problems with Evan Klitzke

    When a company switches the relational database it uses, you wouldn’t expect the news of the switch to go viral. Most engineers are not interested in the subtle differences between MySQL and Postgres, right?

    Uber recently switched from having Postgres as its main relational database to using MySQL. Evan Klitzke wrote a detailed blog post about the migration, and post got very popular for at least three reasons:

    Evan is a great writer and describes complicated distributed database concepts in simple terms Uber is an interesting company with high quality engineers. When Uber takes on a task that will require lots of work–like changing its default relational database–people pay attention MySQL vs. Postgres sounds like the type of divisive topic that is worth getting emotional about for the same reason that people get tribalistic about React vs. Angular, Kubernetes vs. Mesos, and so on If you are even slightly interested in distributed systems or databases, I recommend reading Evan’s blog post in detail.

    —Huffduffed by happygiraffe

  6. RailsConf 2017: ​Postgres at Any Scale​ by Will Leinweber

    ​Postgres at Any Scale​ by Will Leinweber

    This is a sponsored talk by Citus Data.

    Postgres has powerful datatypes and a general emphasis on correctness which makes it a great choice for apps small and medium. Growing to very large sizes has been challenging—until now!

    First you’ll learn how to take advantage of all PG has to offer for small scales, especially when it comes to keeping data consistent. Next you’ll learn techniques for keeping apps running well at medium scales. And finally you’ll learn how to take advantage of the open-source Citus extension that makes PG a distributed db, when your app joins the big leagues.

    ===
    Original video: https://www.youtube.com/watch?v=_wU2dglywAU&feature=youtu.be
    Downloaded by http://huffduff-video.snarfed.org/ on Tue, 18 Jul 2017 15:14:23 GMT Available for 30 days after download

    —Huffduffed by cmdln

  7. Good Architects Borrow, Great Architects Steal by Peter van Hardenberg at FutureStack13

    How many thousand servers per ops person does your organization have? Heroku Postgres has just the one for all our thousands of database servers, and that person is just an engineer on a one-week rotation.

    By architecting for simplicity and consistency, Heroku Postgres reduced servers to something more like transistors. By lifting old game development tricks, we turned complex operational problems into simple state machines. Relying on other cloud service providers for their specialities lets us focus on doing what we do best: serving up your data to you better than anyone else.

    In this talk, I’ll cover the architecture that powers the Heroku Postgres service, how it evolved from humble beginnings, and talk about the lucky breaks, the gnarly mistakes, and the unknowable choices we made along the way.

    ===
    Original video: https://www.youtube.com/watch?v=twTWnZb0Ib4&index=2&list=WL
    Downloaded by http://huffduff-video.snarfed.org/

    —Huffduffed by bigolewannabe

  8. Database Choices and Uber with Markus Winand | Software Engineering Daily

    http://traffic.libsyn.com/sedaily/uber_database_edited.mp3Podcast: Play in new window | Download

    When Uber’s engineering team published a blog post about moving to MySQL from Postgres, Markus Winand started receiving lots of email. Markus writes about databases on his blog “Use The Index, Luke,” a guide to database performance for developers. The people emailing Markus wanted to know–if Postgres doesn’t work well for Uber, is it safe to use for anyone?

    Markus wrote a detailed blog post that was a response to Uber’s discussion of Postgres, and in today’s episode Markus explains why Postgres is perfectly fine for most applications.

    Most developers are not experts in choosing between different databases. The average developer knows the difference between a NoSQL database like Mongo and a normalized SQL database like MySQL–but that developer might not know the more subtle differences between different SQL databases like MySQL and Postgres.

    That is why Markus’s site is so useful, and why it was a pleasure to have him on the show.

     

    Sponsors

    The Circonus monitoring & analytics platform is a leader in accurate monitoring and custom analytics, for any tech at any scale. If you want to learn more about how to better understand the behavior of your systems with a monitoring tool you can trust, go to circonus.com/sedaily for your free trial.

    Hired.com is the job marketplace for software engineers. Go to hired.com/softwareengineeringdaily to get a $2000 bonus upon landing a job through Hired.

     

    Share this:Click to share on Twitter (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to email this to a friend (Opens in new window)

    Related

    Comments

    https://softwareengineeringdaily.com/2016/10/24/database-choices-and-uber-with-markus-winand/

    —Huffduffed by danimad

  9. Cloud Database Workloads with Jon Daniel - Software Engineering Daily

    Relational databases such as Postgres are often used for critical workloads, such as user account data. To run a relational database service in the cloud requires a cloud provider to set up a highly durable, highly available system. Jon Daniel is an infrastructure engineer at Heroku. Jon joins the show to describe the engineering and operations required to build a managed relational database service. Full disclosure: Heroku is a sponsor of Software Engineering Daily. https://softwareengineeringdaily.com/2019/05/06/cloud-database-workloads-with-jon-daniel/

    —Huffduffed by bsscdt

  10. Postgres Professional — Episode 0075 « DevZen Podcast

    Темы выпуска: интервью с Олегом Бартуновым, Иваном Панченко и Федором Сигаевым о компании PostgresPro, курсе Hacking PostgreSQL, предстоящей конференции PgConf.Russia 2016, а также процессе разработки PostgreSQL, планах по дальнейшему развитию этой РСУБД, изменения, которые уже приняли в ветку 9.6, использовании типа ltree, а также множество других интереснейших тем и, конечно же, вопросы наших слушателей.

    Шоу нотес:

    Компания Postgres Professional

    Курс «Hacking PostgreSQL» — уже скоро / Блог компании Postgres Professional

    Гости выпуска в "Интернет плюс"

    Вакансии : Компания Postgres Professional

    Группа PostgreSQL в Facebook

    PgConf.Russia 2016 — Международная конференция по PostgreSQL

    Robert Haas: PostgreSQL Past, Present, and Future: Moving The Goalposts

    Waiting for 9.6 – Cube extension kNN support

    Waiting for 9.6 – Allow to omit boundaries in array subscript

    Using the Ltree Datatype in Postgres

    PostgreSQL: Documentation: 9.5: ltree

    Joe Celko’s Trees and Hierarchies in SQL for Smarties

    The resolution of the Bitcoin experiment — Medium

    Moscow Scala Meetup / События на TimePad.ru

    В феврале в Республике Беларусь состоится международная конференция LVEE Winter 2016

    Всех с бесплатным антивирусом! — Nota Bene

    Internet Explorer End of Support

    TRex: A Paxos Replication Engine (Part 1)

    Full Disclosure: Linux user namespaces overlayfs local root

    Important SSH patch coming soon

    Simple instructions for freezing a Skylake Processor

    [security] Go 1.5.3 is released

    Ansible 2.0 Has Arrived

    cgroup v2 has finally landed in mainline for Linux v4.5

    Поддержи DevZen Podcast на Patreon!

    Темы и вопросы слушателей для 0075 « DevZen Podcast

    Голоса выпуска: Валерий, Александр, а также гости — Олег, Иван и Федор.

    Фоновая музыка: Plastic3 — Corporate Rock Motivation Loop 4

    Подкаст: Скачать (73.8MB)

    ‘);

    //—>

    http://devzen.ru/episode-0075/

    —Huffduffed by averale