5 ms·

PostgreSQL 14 Internals Book

452 points by kelvich 4y ago

arez 4y ago
where can I buy it? Looks great
- scoopertrooper 4y ago
  > The translation is currently in progress. Right now, only Part I is available. Other parts will follow soon. Stay tuned!
  - davidcuddeback 4y ago
    That doesn't answer where it can be purchased, nor does it imply that it will be available for purchase when all translations are complete. At 167 pages, part 1 could conceivably be it's own book for purchase. I too would love a resource like this as a book and would be willing to pay for it. I would even purchase each part individually as they become available.
  - humanwhosits 4y ago
    As in it's available in another language already?
    - atleta 4y ago
      Yes, it seems to be Russian originally. See the first page of the book: PostgreSQL 14 Internals by Egor Rogov Translated from Russian by Liudmila Mantrova © Postgres Professional, 2022
    - quyse 4y ago
      It's available for free in Russian: https://edu.postgrespro.ru/postgresql_internals-14.pdf https://edu.postgrespro.ru/postgresql_internals-14.pdf linked from their own website: https://postgrespro.ru/education/books/internals https://postgrespro.ru/education/books/internals
- ComodoHacker 4y ago
  Nowhere any time soon, I guess, as the author is Russian.
  - x4m 4y ago
    I think the book is free because Egor and PostgresPro want to develop the community. If you want to pay back - you can just start contributing to Postgres. No need to wait :)
mdaniel 4y ago
that is awesome, thank you for posting it I would love to know where to send bugs (a convenient place may be a repo in their GH org (https://github.com/postgrespro https://github.com/postgrespro), to potentially avoid duplicate reports)
- lmantrov 4y ago
  As this book's translator, I'm really excited to see the interest it triggers. Thank you for willing to help! I'll nudge our team about an open mirror, but meanwhile you can contact us at edu@postgrespro.ru. Bug reports on what's already out there will be very helpful to further improve both this part and what is yet to come.
Jamie9912 4y ago
ERR_CONNECTION_TIMED_OUT
- mdaniel 4y ago
  Wayback knows all: https://web.archive.org/web/20220711110133/https://edu.postgrespro.com/postgresql_internals-14_part1_en.pdf https://web.archive.org/web/20220711110133/https://edu.postg...
- Jamie9912 4y ago
  Am I the only one who can't connect to this host? It resolves to a Russian IP address. Home ISP
  - ryapric 4y ago
    A comment above points out that it's a book originally written in Russian, so.
  - sammy2244 4y ago
dlojudice 4y ago
There seems to be a demand for developers who know the internals of Postgres to evolve and customize it given that it is being used, at different levels of abstraction/layers, by basically all cloud providers (AWS, MS, Google, etc) and by some DB SaaS. BTW, that would be a cool job to have...
- johnthescott 4y ago
  more like ice cold.
- kiwicopple 4y ago
  We’re hiring for this role at supabase (if you’re looking): https://boards.greenhouse.io/supabase/jobs/4307456004 https://boards.greenhouse.io/supabase/jobs/4307456004
- httgp 4y ago
  A ton of companies are building on top of PostgreSQL — Yugabyte, Supabase, EdgeDB and Neon.
  - yashap 4y ago
    Another recent one, AlloyDB from Google Cloud. Looks pretty interesting/promising. Sort of like their competitor to AWS Aurora, built on top of Postgres, with the added ability to handle OLAP workloads well (along with apparently great OLTP performance). TimescaleDB and Citus are notable too. But yeah, if you’re building a DB product, starting with Postgres and customizing from there seems like an excellent approach.
  - thejosh 4y ago
    Hopefully pushing back upstream. I don't really care what they do, as long as they push back their usually awesome changes upstream. Great to see these sorts of things, Postgres has been amazing and glad people realise it.
    - sudhirj 4y ago
Erwin 4y ago
If you want more, here's another site with similar focus: http://www.interdb.jp/pg/index.html http://www.interdb.jp/pg/index.html
bfelbo 4y ago
Looks amazing. Would love to be able to buy part 1 as it's own book! Perhaps worth making it a series of books instead of parts?
pjungwir 4y ago
Oh I will surely buy this! This series of deep articles about Postgres index types looks like it's by the same authors, and is one of the few sources I've found that really goes into the data structures used: https://habr.com/en/company/postgrespro/blog/441962/ https://habr.com/en/company/postgrespro/blog/441962/ I expect those articles will turn into chapters in this book.
bacheaul 4y ago
> If you want to use any part of this document and/or any figure, please contact me. If you work at Amazon, you cannot use and refer to this document because of the copyright violation issues. This is an interesting inclusion, would they be referring to copies of this book being sold on Amazon? Or usage in their documentation? I'm genuinely curious what the issue is with them...
- jamesfinlayson 4y ago
  Not sure but I assume it's Amazon offering Postgres as a service through AWS Aurora.
  - 323 4y ago
    Unlikely, Postgres license is as liberal as they get: > Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies. https://www.postgresql.org/about/licence/ https://www.postgresql.org/about/licence/
  - robertlagrant 4y ago
    Many providers offer postgres as a service.
- bzzzt 4y ago
  Maybe related to https://news.ycombinator.com/item?id=32026663 https://news.ycombinator.com/item?id=32026663 ?
rrampage 4y ago
Postgrespro's blog ( https://habr.com/en/company/postgrespro/blog/ https://habr.com/en/company/postgrespro/blog/ ) and http://www.interdb.jp/pg/index.html http://www.interdb.jp/pg/index.html are incredible resources to learn about Postgres internals in depth. Are there resources of similar quality available for MySQL / MariaDB internals ?
j16sdiz 4y ago
PostgresPro is a Russia company. I wonder if the on going war would affect postgres accept contribution from them.
- hunterb123 4y ago
  What's the point of saying this?

452 points by kelvich 4y ago

arez 4y ago

where can I buy it? Looks great

scoopertrooper 4y ago
> The translation is currently in progress. Right now, only Part I is available. Other parts will follow soon. Stay tuned!
- davidcuddeback 4y ago
  That doesn't answer where it can be purchased, nor does it imply that it will be available for purchase when all translations are complete. At 167 pages, part 1 could conceivably be it's own book for purchase. I too would love a resource like this as a book and would be willing to pay for it. I would even purchase each part individually as they become available.
- humanwhosits 4y ago
  As in it's available in another language already?
  - atleta 4y ago
    Yes, it seems to be Russian originally. See the first page of the book: PostgreSQL 14 Internals by Egor Rogov Translated from Russian by Liudmila Mantrova © Postgres Professional, 2022
  - quyse 4y ago
    It's available for free in Russian: https://edu.postgrespro.ru/postgresql_internals-14.pdf https://edu.postgrespro.ru/postgresql_internals-14.pdf linked from their own website: https://postgrespro.ru/education/books/internals https://postgrespro.ru/education/books/internals
ComodoHacker 4y ago
Nowhere any time soon, I guess, as the author is Russian.
- x4m 4y ago
  I think the book is free because Egor and PostgresPro want to develop the community. If you want to pay back - you can just start contributing to Postgres. No need to wait :)

mdaniel 4y ago

that is awesome, thank you for posting it I would love to know where to send bugs (a convenient place may be a repo in their GH org (https://github.com/postgrespro https://github.com/postgrespro), to potentially avoid duplicate reports)

lmantrov 4y ago
As this book's translator, I'm really excited to see the interest it triggers. Thank you for willing to help! I'll nudge our team about an open mirror, but meanwhile you can contact us at edu@postgrespro.ru. Bug reports on what's already out there will be very helpful to further improve both this part and what is yet to come.

Jamie9912 4y ago

ERR_CONNECTION_TIMED_OUT

mdaniel 4y ago
Wayback knows all: https://web.archive.org/web/20220711110133/https://edu.postgrespro.com/postgresql_internals-14_part1_en.pdf https://web.archive.org/web/20220711110133/https://edu.postg...
Jamie9912 4y ago
Am I the only one who can't connect to this host? It resolves to a Russian IP address. Home ISP
- ryapric 4y ago
  A comment above points out that it's a book originally written in Russian, so.
- sammy2244 4y ago

dlojudice 4y ago

There seems to be a demand for developers who know the internals of Postgres to evolve and customize it given that it is being used, at different levels of abstraction/layers, by basically all cloud providers (AWS, MS, Google, etc) and by some DB SaaS. BTW, that would be a cool job to have...

johnthescott 4y ago
more like ice cold.
kiwicopple 4y ago
We’re hiring for this role at supabase (if you’re looking): https://boards.greenhouse.io/supabase/jobs/4307456004 https://boards.greenhouse.io/supabase/jobs/4307456004
httgp 4y ago
A ton of companies are building on top of PostgreSQL — Yugabyte, Supabase, EdgeDB and Neon.
- yashap 4y ago
  Another recent one, AlloyDB from Google Cloud. Looks pretty interesting/promising. Sort of like their competitor to AWS Aurora, built on top of Postgres, with the added ability to handle OLAP workloads well (along with apparently great OLTP performance). TimescaleDB and Citus are notable too. But yeah, if you’re building a DB product, starting with Postgres and customizing from there seems like an excellent approach.
- thejosh 4y ago
  Hopefully pushing back upstream. I don't really care what they do, as long as they push back their usually awesome changes upstream. Great to see these sorts of things, Postgres has been amazing and glad people realise it.
  - sudhirj 4y ago

Erwin 4y ago

If you want more, here's another site with similar focus: http://www.interdb.jp/pg/index.html http://www.interdb.jp/pg/index.html

bfelbo 4y ago

Looks amazing. Would love to be able to buy part 1 as it's own book! Perhaps worth making it a series of books instead of parts?

pjungwir 4y ago

Oh I will surely buy this! This series of deep articles about Postgres index types looks like it's by the same authors, and is one of the few sources I've found that really goes into the data structures used: https://habr.com/en/company/postgrespro/blog/441962/ https://habr.com/en/company/postgrespro/blog/441962/ I expect those articles will turn into chapters in this book.

bacheaul 4y ago

> If you want to use any part of this document and/or any figure, please contact me. If you work at Amazon, you cannot use and refer to this document because of the copyright violation issues. This is an interesting inclusion, would they be referring to copies of this book being sold on Amazon? Or usage in their documentation? I'm genuinely curious what the issue is with them...

jamesfinlayson 4y ago
Not sure but I assume it's Amazon offering Postgres as a service through AWS Aurora.
- 323 4y ago
  Unlikely, Postgres license is as liberal as they get: > Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies. https://www.postgresql.org/about/licence/ https://www.postgresql.org/about/licence/
- robertlagrant 4y ago
  Many providers offer postgres as a service.
bzzzt 4y ago
Maybe related to https://news.ycombinator.com/item?id=32026663 https://news.ycombinator.com/item?id=32026663 ?

rrampage 4y ago

Postgrespro's blog ( https://habr.com/en/company/postgrespro/blog/ https://habr.com/en/company/postgrespro/blog/ ) and http://www.interdb.jp/pg/index.html http://www.interdb.jp/pg/index.html are incredible resources to learn about Postgres internals in depth. Are there resources of similar quality available for MySQL / MariaDB internals ?

j16sdiz 4y ago

PostgresPro is a Russia company. I wonder if the on going war would affect postgres accept contribution from them.

hunterb123 4y ago
What's the point of saying this?