POPULARITY
90 episodes with nikolay
278 episodes with nikolay
24 episodes with nikolay
14 episodes with nikolay
15 episodes with nikolay
12 episodes with nikolay
6 episodes with nikolay
3 episodes with nikolay
6 episodes with nikolay
3 episodes with nikolay
6 episodes with nikolay
5 episodes with nikolay
2 episodes with nikolay
2 episodes with nikolay
2 episodes with nikolay
2 episodes with nikolay
2 episodes with nikolay
31 episodes with nikolay
3 episodes with nikolay
2 episodes with nikolay
2 episodes with nikolay
29 episodes with nikolay
2 episodes with nikolay
2 episodes with nikolay
2 episodes with nikolay
2 episodes with nikolay
2 episodes with nikolay
2 episodes with nikolay
2 episodes with nikolay
2 episodes with nikolay
2 episodes with nikolay
2 episodes with nikolay
2 episodes with nikolay
10 episodes with nikolay
10 episodes with nikolay
2 episodes with nikolay
Nikolay and Michael discuss time-series considerations for Postgres — including when it matters, some tips for avoiding issues, performance considerations, and more. Here are some links to things they mentioned:Time series data https://en.wikipedia.org/wiki/Time_seriesTimescaleDB https://github.com/timescale/timescaledb13 Tips to Improve PostgreSQL Insert Performance https://www.timescale.com/blog/13-tips-to-improve-postgresql-insert-performanceWhy we're leaving the cloud (37 Signals / Basecamp / David Heinemeier Hansson) https://world.hey.com/dhh/why-we-re-leaving-the-cloud-654b47e0UUID v7 and partitioning (“how to” by Nikolay) https://gitlab.com/postgres-ai/postgresql-consulting/postgres-howtos/-/blob/main/0065_uuid_v7_and_partitioning_timescaledb.mdpg_cron https://github.com/citusdata/pg_cronpg_partman https://github.com/pgpartman/pg_partmanOur episode on BRIN indexes https://postgres.fm/episodes/brin-indexesTutorial from Citus (Andres Freund and Marco Slot) including rollups https://www.youtube.com/watch?v=0ybz6zuXCPoIoT with PostgreSQL (talk by Chris Ellis) https://youtube.com/watch?v=KnUoDBGv4aw&t=58pg_timeseries https://github.com/tembo-io/pg_timeseriesDuckDB https://duckdb.org~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork
Nikolay Danev - Tech This - April 25 by Vibes Radio Station
Nikolay and Michael are joined by Tomas Vondra to discuss single query performance cliffs — what they are, why they happen, some things we can do to make them less likely or less severe, and some potential improvements to Postgres that could help. Here are some links to things they mentioned:Tomas Vondra https://postgres.fm/people/tomas-vondraWhere do performance cliffs come from? (Talk by Tomas) https://www.youtube.com/watch?v=UzdAelm-QSYWhere do performance cliffs come from? (Slides) https://vondra.me/pdf/performance-cliffs-posette-2024.pdfIncrease the number of fast-path lock slots (committed for Postgres 18) https://www.postgresql.org/message-id/flat/E1ss4gX-000IvX-63%40gemulon.postgresql.org San Francisco Bay Area Postgres meet-up with Tomas on 8th April (online) https://www.meetup.com/postgresql-1/events/306484787Our episode on Extended Statistics https://postgres.fm/episodes/extended-statisticsLogging plan of the currently running query (proposed patch by Rafael Thofehrn Castro and Atsushi Torikoshi) https://commitfest.postgresql.org/patch/5330Our episode with Peter Geoghegan on Skip Scan https://postgres.fm/episodes/skip-scanIndex Prefetching patch that Tomas is collaborating with Peter Geoghegan on https://commitfest.postgresql.org/patch/4351A generalized join algorithm, G-Join (paper by Goetz Graefe) https://dl.gi.de/server/api/core/bitstreams/ce8e3fab-0bac-45fc-a6d4-66edaa52d574/content Smooth Scan: Robust Access Path Selection without Cardinality Estimation (paper by R. Borovica, S. Idreos, A. Ailamaki, M. Zukowski, C. Fraser) https://stratos.seas.harvard.edu/sites/g/files/omnuum4611/files/stratos/files/smoothscan.pdfJust-in-Time Compilation (JIT) https://www.postgresql.org/docs/current/jit.htmlNotes from a pgconf.dev unconference session in 2024 about JIT (discusses issues) https://wiki.postgresql.org/wiki/PGConf.dev_2024_Developer_Unconference#JIT_compilationImplementing an alternative JIT provider for PostgreSQL (by Xing Guo) https://higuoxing.com/archives/implementing-jit-provider-for-pgsqlTomas' Office Hours https://vondra.me/posts/office-hours-experiment ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Pointe shoe fittings can feel like a mystery—but Riley Weber, a well-known pointe shoe fitter for Nikolay, is here to break it all down! In this episode, we talk about what to expect at a fitting, how to tell if a fitter knows what they're doing, and why dancers shouldn't just settle for “fine.” Riley addresses common fitting issues (like sinking!), the truth about toe pads, and why some shoes are impossible to get in stock. Plus, we get into listener questions on hypermobility, online fittings, crazy pointe shoe hacks, and more. If you're a dancer, parent, or just pointe shoe curious, this episode is packed with insights (and some wild fitting stories). Tune in! Learn more about Riley: Instagram: @rileythomasweber TikTok: rileythomasweber More Links: Support Ballet Help Desk Buy Corrections Journals Instagram: @BalletHelpDesk Facebook: BalletHelpDesk Ballet Help Desk Music from #Uppbeat: https://uppbeat.io/t/ian-aisling/new-future License code: MGAW5PAHYEYDQZCI
Deep Poisson PDCT-345 #ProgressiveHouse #MelodicTechno При прослушивании любимой музыки, человек может испытывать чувство радости, умиротворения и вдохновения. Музыка способна переносить нас в другие миры, пробуждать в нас самые разные эмоции и чувства. Track List: DePo Podcast-#2025-#345 1Michael Bennett - Move to the Hills (Original Mix) 2ARTN - Cycles (Original Mix) 3Analog Jungs - Magellan Orbitation (Original Mix) 4Chris Sterio, Matt Black - Acoustic Pleasure (Michael A Remix) 5Cristian Hidalgo - Deep Shanti (Jozar Remix) 6K Loveski - Amuja (Gorkiz, Luca Abayan Remix) 7Marsias, Ali Bakgor - Night After Night (Extended Mix) (Extended Mix) 8NOIYSE PROJECT - Tacenda (Original Mix) 9Redspace, Shell Robinson - Reflections (Original Mix) 10Nathan Rudder - Lenticular (Original Mix)
Nikolay and Michael are joined by Lev Kokotov to discuss PgDog — including whether or when sharding is needed, the origin story (via PgCat), what's already supported, and what's coming next. Here are some links to things they mentioned:Lev Kokotov https://postgres.fm/people/lev-kokotovPgDog https://github.com/pgdogdev/pgdogPgCat https://github.com/postgresml/pgcatAdopting PgCat (Instacart blog post) https://www.instacart.com/company/how-its-made/adopting-pgcat-a-nextgen-postgres-proxyPgDog discussion on Hacker News https://news.ycombinator.com/item?id=43364668Citus https://github.com/citusdata/citusSharding & IDs at Instagram (blog post) https://instagram-engineering.com/sharding-ids-at-instagram-1cf5a71e5a5cSharding pgvector (blog post by Lev) https://pgdog.dev/blog/sharding-pgvector~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Track List: DePo Podcast-#2025-#344 1Cristian Hidalgo - Black Mirror (Guille Campo Remix) 2Dmitry Molosh, Michael A - Integral (Original Mix) 3Exesti - Magic Tunnel (Nikko Mavridis Remix) 4Gaston Sosa - Soul Vibes (Original Mix) 5HAFT - Momentum (Original Mix) 6Joe Fisher - Reality Exchange (Subandrio Remix) 7Jon Towell - 49 Miles (Original Mix) 8Markus Homm, Nici Faerber - Basement Room (Feature Complete Remix) 9Leo Perez, Dhany G - Agata (Da Luka Remix)
Nikolay talks Michael through using cloud snapshots — how they can be used to reduce RTO for huge Postgres setups, also to improve provisioning time, and some major catches to be aware of. Here are some links to things they mentioned:Snapshots on RDS https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.htmlpgBackRest https://pgbackrest.orgWAL-G https://github.com/wal-g/wal-gpg_backup_start and pg_backup_stop (docs) https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-BACKUP How to troubleshoot long Postgres startup (by Nikolay) https://gitlab.com/postgres-ai/postgresql-consulting/postgres-howtos/-/blob/main/0003_how_to_troubleshoot_long_startup.mdRestoring to a DB instance (RDS docs mentioning lazy loading) https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RestoreFromSnapshot.html Amazon EBS fast snapshot restore https://docs.aws.amazon.com/ebs/latest/userguide/ebs-fast-snapshot-restore.htmlOur 100th episode “To 100TB, and beyond!” https://postgres.fm/episodes/to-100tb-and-beyond ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork
Nikolay and Michael discuss GIN indexes in Postgres — what they are, what they're used for, and some limitations to be aware of. Here are some links to things they mentioned:GIN Indexes https://www.postgresql.org/docs/current/gin.htmlGeneralized Search Trees for Database Systems (Hellerstein, Naughton, Pfeffer) https://dsf.berkeley.edu/papers/vldb95-gist.pdf RUM extension https://pgxn.org/dist/rum/1.1.0/Understanding Postgres GIN Indexes: The Good and the Bad (Lukas Fittl) https://pganalyze.com/blog/gin-index~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork
What does it take to transform an entire city through real estate investing? In this episode, I sit down with Nikolay Ray, a visionary investor and the founder of Collège MREX and Fierbrooke, to explore how he's reshaping Sherbrooke through impact investing. Nikolay shares his journey from investment banking to real estate, detailing his approach to acquiring and revitalizing properties to create lasting change. We discuss the philosophy behind sustainable development, affordable housing, and urban renewal. Nikolay explains why he focuses on community reinvestment and how his unique “monopoly strategy” allows him to influence entire neighborhoods. He also dives into the challenges of working with cities, the importance of public consultations, and how developers can balance profit with purpose. If you're interested in real estate as a tool for transformation, this episode is for you. Nikolay's insights on leadership, vision, and financial engineering will shift how you think about investing. Tune in to learn how to build a portfolio that goes beyond returns and contributes to the bigger picture. What you will learn if you listen to the episode: - How Real Estate Investors Can Transform a City Through Impact Investing - Building Wealth and Affordable Housing in Real Estate Investing - Urban Development Strategies for Real Estate Investors - Sustainable Real Estate Investing for Long-Term Growth - Overcoming Challenges in Property Development and City Regulations - Vision and Leadership in Real Estate Investment Success - Community Reinvestment and Financial Strategies for Property Investors SUPPORT US ON PATREON! patreon.com/realestateeffect and become a part of our real estate family! You'll get access to exclusive content, monthly virtual meetings [Ask me anything!], special events, and more! And please subscribe to the show, share it with a friend and send us feedback. Visit www.realestateeffect.ca and follow me on IG @monsaxel Connect with Axel Monsaingeon: Linkedin - https://www.linkedin.com/in/axel-monsaingeon-42577b28/ Website - https://www.realestateeffect.ca/ Facebook - https://www.facebook.com/realestateeffect/ Instagram - https://www.instagram.com/veryrealestateeffect/ Youtube - https://www.youtube.com/channel/UCc8EYrmO1aVvVIgwT7AfNFw Connect with Nikolay Ray: Website: https://www.linkedin.com/company/mrex/people/ LinkedIn: https://www.linkedin.com/in/nikolairay/ Do you have any questions about your real estate journey? Whether you're curious about navigating the complexities of development projects, dealing with financial challenges, or anything in between, I'm here to delve into the topics that matter most to you. I invite you to submit your questions by visiting our website at https://www.realestateeffect.ca/ and clicking on the 'Send Voicemail' widget on the right side. Your inquiries will help shape our upcoming episodes, ensuring we cover the real estate issues you're most interested in.
Deep Poisson PDCT-343 #ProgressiveHouse #MelodicTechno При прослушивании любимой музыки, человек может испытывать чувство радости, умиротворения и вдохновения. Музыка способна переносить нас в другие миры, пробуждать в нас самые разные эмоции и чувства. *Apple Podcast: apple.co/2KZwKY8 *vk.com/nikolaymachaon *www.instagram.com/c.a.y.record… *YouTube: www.youtube.com/channel/UCO5c8… *Deezer: deezer.page.link/cJWg5nwHXzhbs… Track List: DePo Podcast-#2025-#343 1Doriaan, Diego Hernan, Milton Bo - Enjoy (Tirso Enriquez AR Remix) 2Alley SA - Inside My Soul (Original Mix) 3Chicato - Chuntaro (Original Mix) 4Doriaan, Diego Hernan, Milton Bo - Enjoy (Manu Pavez Remix) 5Dr Parnassus - Riddler (Original Mix) 6Dylan Deck, LEM (IT) - The Other Side (Redspace Remix) 7Murguía - Look For The Signals (Kris Dur Remix) 8Sebastian Sellares, Greta Meier - Benevolence (Extended Mix) 9Cendryma - Evasive (Extended Mix) 10Ewan Rill - Cast a Spell (Original Mix) 11IAELL - South Island (URANNIA Extended Mix)
Nikolay Danev - Tech This - March 25 by Vibes Radio Station
Nikolay and Michael use a recent "best practices" article as a prompt — giving a few tips each on the topics mentioned, like schema design, performance, backups, and more. Here are some links to things they mentioned:7 Crucial PostgreSQL Best Practices (recent blog post) https://speakdatascience.com/postgresql-best-practices“Don't do this” episode https://postgres.fm/episodes/dont-do-thisArticle discussion on Hacker News https://news.ycombinator.com/item?id=42992913Mozilla's SQL Style Guide https://docs.telemetry.mozilla.org/concepts/sql_style“SQL vs NoSQL” episode with Franck Pachot https://postgres.fm/episodes/sql-vs-nosqlHA episode https://postgres.fm/episodes/high-availability ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork
#KöşedekiKitapçı'da
Deep Poisson PDCT-342 #ProgressiveHouse #MelodicTechno *Apple Podcast: apple.co/2KZwKY8 *vk.com/nikolaymachaon *www.instagram.com/c.a.y.record… *YouTube: www.youtube.com/channel/UCO5c8… *Deezer: deezer.page.link/cJWg5nwHXzhbs… Track List: DePo Podcast-#2025-#342 1Alex O'Rion, Matter - Moksha (Extended Mix) 2Benja Molina - Mauna Loa (Extended Mix) 3Mazayr - Limandra (Noise Generation Remix) 4Bondarev & Anton Borin (RU) - Samadhi (Ilias Katelanos & Plecta Remix) 5HAFT - United Frequencies (Original Mix) 6Bondarev & Anton Borin (RU) - Multiverse (Redspace Remix) 7John Cosani - Only One (Original Mix) 8Peter Smyth Music - Spiral Tap (ELECGROUND Remix) 9Sam Sick - Night Attack (Original Mix) 10Pedro Sanmartin - Immersive Experience (Haen & Finding Mero Remix)
Nikolay and Michael discuss the CREATE STATISTICS feature in Postgres — what it's for, how often it's used, and how to spot cases where it would help. Here are some links to things they mentioned:CREATE STATISTICS https://www.postgresql.org/docs/current/sql-createstatistics.htmlcitext https://www.postgresql.org/docs/current/citext.htmlStatistics Used by the Planner https://www.postgresql.org/docs/current/planner-stats.htmldefault_statistics_target https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-DEFAULT-STATISTICS-TARGETTomáš Vondra on Postgres TV https://www.youtube.com/watch?v=8la-OWfD3VIRecent commit to Postgres 18 for pg_upgrade https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=1fd1bd871012732e3c6c482667d2f2c56f1a9395Multivariate Statistics Examples https://www.postgresql.org/docs/current/multivariate-statistics-examples.htmlExtended statistics (README) https://github.com/postgres/postgres/blob/master/src/backend/statistics/READMEHow we used Postgres extended statistics to achieve a 3000x speedup (blog post by Jared Rulison) https://build.affinity.co/how-we-used-postgres-extended-statistics-to-achieve-a-3000x-speedup-ea93d3dcdc61~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork
Deep Poisson PDCT-341 #ProgressiveHouse #MelodicTechno «Я очень сожалел бы, если бы моя музыка только развлекала моих слушателей: я стремился их сделать лучше». Г. Гендель: При прослушивании любимой музыки, человек может испытывать чувство радости, умиротворения и вдохновения. Музыка способна переносить нас в другие миры, пробуждать в нас самые разные эмоции и чувства. *Apple Podcast: apple.co/2KZwKY8 *vk.com/nikolaymachaon *www.instagram.com/c.a.y.record… *YouTube: www.youtube.com/channel/UCO5c8… *Deezer: deezer.page.link/cJWg5nwHXzhbs… Track List: DePo Podcast-#2025-#341 1Luan Pugliesi - Eternal Now [Future Avenue] 2Mayank - Dhyan Yog [Future Avenue] 3Jamie Stevens & Zankee Gulati - Utveckla [Sudbeat Music] 4Hobin Rude - The Only Thing That Matters [Mango Alley] 5Gorkiz & Gastón Sosa - Raise the Alarm (K Loveski Remix) [Transensations Records] 6Juan Bentkovsky - Tiempo De Volar [One Of A Kind] 7Seyah - Look Around (Extended Mix) [SkyTop] 8Kostya Outta, Redspace - Zero Gravity - Redspace Remix [inU] 9Luciano Scheffer, Andre Moret - Onix (Extended Mix) [Univack] 10Martin Serbali - Sapphire (Andrés Moris Remix) [Droid9]
In this episode, host James interviews Nikolay Ilyev, a trumpet player and entrepreneur from Vidin, Bulgaria, who operates Iliev Brass Music. Nikolay shares his musical journey beginning in the sixth grade, his advanced studies in Switzerland with Jean Francois Michel, and his time in the UK. He discusses the unique aspects of Bulgarian music culture, including the importance of folk music and the tradition of wind bands. Nikolay is launching a new line of trumpets and flugelhorns and has created 'Music Youth Prospects for Vidin' to support young, financially disadvantaged musicians in Bulgaria. The episode provides insights into Bulgarian musical traditions and Nikolay's innovative contributions to brass instrument production.Episode Highlights:01:42 Nikolay's Musical Journey02:53 The Music Scene in Bulgaria06:38 Innovative Trumpet and Flugelhorn Designs12:03 Supporting Young Musicians in Bulgaria13:48 Conclusion and Final ThoughtsResources Mentioned:Music Youth Prospects for VidinConnect With the Guest:Bulgarian trumpet player and brass educator (born July 18, 1975), Nikolay Iliev was born in Vidin, Bulgaria (in the North West of the country). He started playing trumpet at the age of 14 and studied for few years under local professional orchestral and band trumpeters. In 1999 he enrolled in the trumpet class of Jean-François Michel (a former principal trumpet with the Munich philharmonic)at the Fribourg Conservatoire (Switzerland) and continued his education at the Royal Northern College of Music in Manchester (UK) under the guidance of Murray Greig and John Miller.After returning to his home town of Vidin he took on a principal trumpet role with Vidin Philharmonic for 2 years then spent 5 years in Antalya, Turkey playing in show bands for local touristic resorts .He spent two more years as an orchestral trumpeter (mostly pit work) with Razgrad Philharmonic in Bulgaria before going back to Vidin, this time as a a music directo and music theory teacher for a local school profiled in music and playing for the Vidin Municipality wind band.In the beginning of 2025 he reopened his company Brass Universe Ltd (which was closed for more than 10 years) and build his first brass instrument (a flugelhorn). He has also started a fund to help local youth musicians with finances for participation in competitions, masterclasses and summer camps.You've been listening to Trumpet Dynamics, telling the story of the trumpet, in the words of those who play it. To learn more about the show, and to join the Trumpet Dynamics tribe, visit us on the web at trumpetdynamics.com.And be sure to tap the subscribe button on your phone so you're always up to date with new episodes as they release.Thank you for listening!
Nikolay and Michael are joined by Franck Pachot to discuss SQL vs NoSQL — did Franck change teams by joining MongoDB, normalisation vs denormalisation, developer experience, NULLs, and more! Here are some links to things they mentioned:Franck Pachot https://postgres.fm/people/franck-pachotFranck's workshop at PGConf India https://pgconf.in/conferences/pgconfin2025/program/proposals/958 PostgreSQL Conference Germany https://2025.pgconf.de"Schema Later" Considered Harmful by Michael Stonebraker and Álvaro Hernández https://www.enterprisedb.com/blog/schema-later-considered-harmfulComparison of JOINS by Michael Stonebraker and Álvaro Hernández https://www.enterprisedb.com/blog/comparison-joins-mongodb-vs-postgresql Franck's post about why he joined MongoDB https://www.linkedin.com/pulse/2025-im-joining-mongodb-franck-pachot-e4shfEdgeDB https://www.edgedb.comNikolay's tweet about a recent issue with NULLs https://x.com/samokhvalov/status/1889078097124999272PartiQL https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ql-reference.htmlFerretDB https://www.ferretdb.comDocumentDB https://github.com/microsoft/documentdb~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Deep Poisson PDCT-340 #ProgressiveHouse #MelodicTechno «Я очень сожалел бы, если бы моя музыка только развлекала моих слушателей: я стремился их сделать лучше». Г. Гендель: При прослушивании любимой музыки, человек может испытывать чувство радости, умиротворения и вдохновения. Музыка способна переносить нас в другие миры, пробуждать в нас самые разные эмоции и чувства. *Apple Podcast: apple.co/2KZwKY8 *vk.com/nikolaymachaon *www.instagram.com/c.a.y.record… *YouTube: www.youtube.com/channel/UCO5c8… *Deezer: deezer.page.link/cJWg5nwHXzhbs… Track List: DePo Podcast-#2025-#340 1Guy J - Lost & Found (AM Mix) [Lost & Found] 2KAMADEV - Moment (Original Mix) [Manual Music] 3James Harcourt - Subdominant [Renaissance Records] 4Sinus, BONDI - Head Over feat. Sinus (Diode Eins & David Hasert Remix) [Stil Vor Talent] 5Gespona - FadeRRR (Original Mix) [Rummel] 6Nihil Young, Modeplex - Valium (Original Mix) [Einmusika Recordings] 7Far From Home, Retoric - The Arrival (Paul Anthonee Remix) [Astral Records] 8Carlita & Calussa - Fell In Luv (Black Circle Extended Remix) [Higher Ground] 9Amir Telem - Embrace the Pain [Inspired By Trees Records] 10Marsh - Hymn (Hernan Cattaneo & Simply City Extended Mix) [Anjunadeep] 11Sasha & Because of Art - Fused [Last Night On Earth]
Nikolay and Michael return to the topic of BUFFERS for the third (and final?) time! They discuss the news that it'll be on by default with EXPLAIN ANALYZE in Postgres 18, and what effect that might have. Here are some links to things they mentioned:Our first BUFFERS episode https://postgres.fm/episodes/buffers-by-defaultOur second BUFFERS episode https://postgres.fm/episodes/buffers-ii-the-sequelBUFFERS enabled for EXPLAIN ANALYZE by default (commit for Postgres 18) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c2a4078ebad71999dd451ae7d4358be3c9290b07https://explain.depesz.com/historyLatency Numbers Every Programmer Should Know https://gist.github.com/jboner/2841832Twitter conversation about flushing caches https://x.com/prochazkafilip/status/1881655337499205736pg_buffercache_evict https://www.postgresql.org/docs/current/pgbuffercache.html#PGBUFFERCACHE-PG-BUFFERCACHE-EVICTHow to compare the quality of SQL query plans (blog post by Andrei Lepikhov) https://danolivo.substack.com/p/whose-optimisation-is-betterWe were added as PostgreSQL Contributors! https://www.postgresql.org/about/news/new-postgresql-contributors-3006~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Nikolay and Michael discuss a couple of surprising ways read queries (selects) can cause writes (shared buffers dirtied) in Postgres. Here are some links to things they mentioned:Reads causing writes in Postgres (post by Alex Jesipow) https://jesipow.com/blog/postgres-reads-cause-writes/Exploring how SELECT queries can produce disk writes (post by Nikolay Sivko) https://blog.okmeter.io/postgresql-exploring-how-select-queries-can-produce-disk-writes-f36c8bee6b6f Hint Bits (wiki) https://wiki.postgresql.org/wiki/Hint_Bitspg_stat_statements https://www.postgresql.org/docs/current/pgstatstatements.html pg_stat_kcache https://github.com/powa-team/pg_stat_kcache pg_wait_sampling https://github.com/postgrespro/pg_wait_sampling BUFFERS by default (episode 4!) https://postgres.fm/episodes/buffers-by-default Page layout (docs) https://www.postgresql.org/docs/current/storage-page-layout.html From Reddit (user merlinm), PD_ALL_VISIBLE may be a third case https://www.reddit.com/r/PostgreSQL/comments/1hjuyfn/comment/m3e6e7v/ Coroot https://coroot.com/ ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
#KöşedekiKitapçı'da bugün
Pointe shoes are a bit like snowflakes - no two pairs are the same! In this episode, we're spilling the tea on how we each prepare our shoes and what we put inside them. As an amateur (Hannah) and a professional (Yelena), our feet are super different and so are the methods we use to prepare and comfortably wear our shoes. So if you're looking for suggestions (or you're just a pointe-shoe lover like us) this episode is for you! Let's get into it... And don't forget to show us how you prepare your shoes over on Instagram. ◡̈ Yelena's pointe shoes: Energetiks "Melody" modelHannah's pointe shoes: Nikolay "3007" model Toe spacersGel toe sleeveCozy Toes toe pads Follow Yelena @ballet_for_allFollow Hannah @thebusybunheadCheck out more resources here:youtube.com/@balletforallonlineballetclasses.comthebusybunhead.comPodcast produced by Mission Bridge Media.www.MissionBridgeMedia.comSee you next time after class! ♥
Nikolay and Michael discuss adding constraints in an online fashion, using NOT VALID and then VALIDATE CONSTRAINT. Here are some links to things they mentioned:ADD table_constraint NOT VALID https://www.postgresql.org/docs/current/sql-altertable.html#SQL-ALTERTABLE-DESC-ADD-TABLE-CONSTRAINTOur episode on zero-downtime migrations https://postgres.fm/episodes/zero-downtime-migrationsVALIDATE CONSTRAINT https://www.postgresql.org/docs/current/sql-altertable.html#SQL-ALTERTABLE-DESC-VALIDATE-CONSTRAINTALTER TABLE notes https://www.postgresql.org/docs/current/sql-altertable.html#SQL-ALTERTABLE-NOTESpgroll https://github.com/xataio/pgroll~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
And the Beat Goes On.Based on a post by FinalStand, in 13 parts. Listen to the ► Podcast at Explicit Novels. Tuesday night, in the asphalt-covered rear loading area of the Wal-Mart there was a Redneck throw down. Buck Tooney was wasting no time in cementing his leadership position over the White portion of our High School. His job was made more difficult by Darius' ruthless efficiency in allowing no other organizations, no matter how informal, to challenge his dominion. That translated over to Buck having to bust more heads to bring the 'rednecks' all in line.If that worked out, the city-Whites would be next. The problem for everyone else was the High School had been a succession of autocratic tyrannies for so long, it was difficult for the students to successfully even balkanize, much less unify. Everyone assumed another 'Darius' would eventually arise to restore a brutal school order; as long as 'he' was Black.That meant Buck needed a Black figurehead to parade in front of the 'establishment' to get things done. So far, no such person existed. Rashaan not only had the mistaken impression he could resist Buck, he was the Chief of Police's son; so not a prime candidate to be a figurehead for a criminal like Buck. Therefore he had to get Rashaan out of the way; figuratively speaking.Another problem for Buck was the school already had an existing Black criminal element. Darius had not been a part of it, but like so many other aspects of school society, when he told the leaders of the school subcultures to do something, or not to do something, he expected compliance. If not; pain would definitely follow. These characters weren't going to easily knuckle under to Buck Tooney though. After all, he'd been Darius' brother's 'boy', not the other way around.If anyone seriously thought Buck had returned to High School to be the Black Man's Bitch (again), they were clearly high, brain damaged, and/or delusional. I wouldn't have put money on who could have taken who in a Buck vs. Darius brawl; except Darius wouldn't have been lured into that kind of fight.Absent Darius, the school's Black community only had two confederates with sufficient intellect and charisma to lead the forces on that side of the racial divide. Sadly for the disciples of the Almighty BBC, both were women. Not only was Taliyah's mom the Mayor, she herself was co-Captain of one of the establishment's most recognized bodies; the Cheer Squad.The other was Jewel 'C. S.' Lafontanté. She was more infamous than famous, intelligent, un-aligned with any club, or activity, which awarded accolades, yet was overly endowed with a host of natural abilities as well as learned skills and talents. And, unlike Taliyah,; absent Darius; she felt the top spot was hers for the taking from the get go.Step one had been to sit at the feet of her mother and father, taking their counsel on the principles of asymmetric warfare, transforming weaknesses into strengths and how to locate, isolate and exploit the weaknesses of her enemies. Step two was accomplished Tuesday night when she and the rest of the Zulu Princess Posse jettisoned their boyfriends. From here on out, the ladies would be taking whatever cock they wanted. The times; they were a-changing.I had two more imminent problems with my life. The first was Riley Pasternak, Mayor Malik's aide and a woman I'd put my cock into; without my Mother's permission. By the way she kept licking absolutely everything off her fingertips at dinner Tuesday night while staring at me, I was sure she was expecting another performance.Before I could worry about how to finally put the brakes on my out of control sex drive, we had a caller at the gate; for me. It was Randi Leigh Upshaw. That was more than a tad unexpected. I'd stuck my cock in her, so I felt obliged to provide hospitality now that she came calling, but promised myself 'no sex'. We met on the porch.‘Hey, Vlad,' Randi Leigh appeared distracted and a bit distraught and couldn't meet my gaze.‘Hello, Randi Leigh. Care to sit down?' I motioned toward the porch swing.‘Sure,' she walked that way. It wasn't all that cold, she was in a team jacket, yet she still felt the need to wrap herself in her arms.‘What's going on?' I said once we'd taken our seats and swung back and forth twice.‘I; do you like Brandy?' she turned on me, putting a both her hands on my right forearm.‘Yes, I do,' I nodded. ‘Very much.'‘I can make you happier than she can,' bubbled forth from her lips.'What gives you that idea', seemed inappropriate so; ‘I thought you were happy with Rashaan,' was my second, and apparently equally bad, choice. Her look said it all: Rashaan wasn't getting the job done in a fundamental way.‘He's nothing like you,' she purred with the understated passion of an addict needing fix; me being the drug.‘Vlad, what is going on out here?' Mom called out. With Mom's propensity to sneak up on things like a Martian and listen in on conversations, this had to be a clue about something more. We both hopped out of the swing.‘This is Randi Leigh Upshaw. She's a; ah friend of Brandy and on the Cheer Squad. She's dating Rashaan Quinterre now.'‘Nice to meet you,' Mom was full with the feigned politeness, ‘Randi Leigh. I need a moment of Vlad's time, then I'll give him back.'She pulled me aside and back down the walk around porch until we were out of earshot then;‘Care to explain?'So I did; everything from the encounter in the Parking Lot to the Music Room banter, her going off in an epileptic seizure and ending with her here; now. Mom put her hand to her chin as she lowered her head slightly. Her far-off look dictated she wanted a few moments to think things through.‘With some girls; it goes straight to the brain like some allergic reaction,' she related. ‘In 1898, one of your ancestors was felled by a delirium and was cared for in a cat house in Dawson City. Three 'Ladies of the Evening' quickly fell to fighting over him and concluding with two fighting a duel with pistols in the middle of Front Street to decide who got 'their man'. Clearly some ladies can go a bit nuts over what your family has in your nut sack.'‘That's totally nu; crazy and unfair to poor Randi Leigh,' I frowned. I kicked at the planks on the porch for good measure.‘Didn't you just tell me she is gladly whoring herself out for Rashaan Quinterre? Do you think she's doing that for love?'‘What about Brandy? I don't want to cheat on her; any more than I've already cheated on her,' I muttered. Man, I sounded pathetic!‘Here's what you do,' my Mother stroked my cheek. ‘You tell Randi Leigh she had better become Brandy's #2 friend from here on out, or you won't have anything to do with her. You aren't going to cheat on Brandy, but Brandy might see a way to share you from time to time if she behaves. No more Big Black Cock for her though.'‘Okay,' I felt partially relieved. Now that I had a moment alone, I added, ‘What about Riley?'‘I got her.'‘You?'‘Yes. Me and your Da are going to take her to bed for some pulse-pounding, three-way action,' she grinned like an orca about to devour a baby seal.I had no idea Dad was so; kinky.‘Once I get your Da going, he's quite the animal,' Mom enlightened me. ‘I'll get me and Riley going in the bedroom. When he walks in, he'll protest; like he always does; then he'll come around and; ‘‘Enough, Mom,' I raised my hands. ‘Enough.'She laughed. I retreated to the semi-sanity of Randi Leigh who was waiting on me expectantly.‘Here are the rules,' I began ticking off my points, finger by finger.‘I'm Brandy's boyfriend. If you want to spend time with me you had better become Brandy's #2 best friend.'‘You don't sleep around with anyone else besides me and my brothers without clearing it with us first.'‘You don't pick fights with anyone unless you 'okay' it with myself, or my brothers first.'‘You break the rules three times and we never even talk with you; ever again.'That would have been the point I at which would have expected her to scoff at me at least, possibly slap me, or at least cry as a form of manipulation. Randi Leigh simply nodded. I walked her off the porch to her vehicle. We hugged, but didn't kiss. Afterwards I called Brandy and gave her the basics of what had gone down without explaining the toxic stew which lay behind it.I avoided my family the rest of the night; choosing to go to bed early instead. As I lay reclined on my back, staring out the tall window into the clear, highland night sky, I felt sick to my stomach. Slowly a revelation came to me. What my family had was definitely a curse, not a blessing because it was wed to a sense of conscience and responsibility.I had often thought about why Mom sought out Dad as the 'One' for her, but until that night, never really considered why he had chosen her to be his 'One'. Looking back, I realized it wouldn't have made sense until that point because I didn't have enough pieces of Mom's puzzle. I had the belief Dad sensed the intense pain within Mom's soul and nothing short of the grave, or what he had within him, could soothe her.By Mom's own admission, she was a Wild Child. She would have never settled down. Never had us kids. Never felt the love of a family if Dad hadn't decided to share his genetic curse with her. He'd loved her enough to become her lodestone; the center of her life and to take on all the pain such a position entailed.Everything I knew about my Dad suggested Mom was the Last type of woman he would have wanted to spend the rest of his life with. Dad liked his life calm, quiet and orderly. Mom was the polar opposite of those desires; impulsive, loud and chaotic. I didn't doubt his love for her in the slightest, yet my Father had sacrificed his dreams of tranquility to save my Mother.Why wasn't Mom furious with him over enslaving her to his cock; his magic sperm? She probably had been, once she figured out the family secret; for a short while. Then she realized the import his love had, saw the course her life was taking her down and what she obviously meant to him. But Mom being Mom; she still made him pay with her explosively eccentric behavior and her bizarre tutelage of his boys.And Dad had accepted it all as the price necessary to save my Mother's life; and that was that. Dad could have had any woman he wanted. Any Samsonov man could have. Why weren't we a clan of billionaires then? Why didn't we have oriental-style harems and dozens of mistresses on the side?Because we saw what we possessed as a curse; which we sometimes shared with truly crazy people to give them a real world focus for their lives so they wouldn't finally be consumed by their peculiar forms of madness. My hypothesis certainly fit what I knew about my kinfolk. I took that uneasy psychic compromise with me to my dreams.Wednesday.Wednesday morning, the storm clouds began to gather. The big news was Jewel Lafontanté had dumped Thomas 'Shaka' Sneed, Student Body President. Certain notorious Redneck troublemakers were either absent, or had shown up bruised and battered from last night's rumble with Buck's crew.That wasn't the only bruising going on. Rashaan had gone from one cheerleader to none, to two, to none once more; inside a week. The damage to both his ego and prestige was immense. Into the void stepped a rather brutal individual named Porter Walmsley, the Football Squad's Defensive Team Captain. While he was big, bad and Black, Taliyah and Brandy insisted his thick sausage was also very short; a definite deal-breaker when it came to BBC Mastery.Not to be outdone, Alonzo Hollingsworth, son of the richest (Black) man in Kingston made a play for Taliyah at lunch. He was long on talking solidarity while showing no solidarity with any of the other social 'front-runners'. Taliyah told him she'd 'think about it' in a blatant attempt to rile Mikhail. It didn't, which only soured her mood more.At practice, the Assistant Athletic Director (aka Coach Weasel, aka Coach George Wilcox), named Deon Manley Team Captain. He was (surprise, surprise) Black, in my position (Point Guard) and on record as performing sexual favors for the coach (letting the coach suck his cock).After practice, I got a message; via Brandy; that Jed Lee Earl wanted to talk with me and my brothers. She had to give me the 411. He was from one of Kingston's old White Rich families, led a clique of rich and 'almost rich' White kids and she thought he was gay. Most likely, with Buck on a rampage, he was looking for some 'muscle of his own,' she added with a giggle. I swatted her ass over that one.At least this time we avoided any name calling as we made our exit from school. Alexander was off to Ms. Blanchard's class. Mikhail took Kaja home on his KTM 690 Enduro R motorcycle without argument. I took Monique and Shaquille home (her house actually) with Vicky and Kaelyne tagging along. Brandy and Taliyah took Alondra and Noémie to their homes before the rendezvous at the Fonteneau mansion.The routine cycle resumed: homework, working out, showering, then a small amount of friend time before dinner. Unlike Tuesday, Mikhail was downright responsive to Taliyah; playful if not contrite. Taliyah countered by being friendly to Kaelyne and Vicky. I had my hands full with Brandy the entire time, so I was of no help.Vicky surprised us all by asking to learn a few wrestling and Sambo moves as we migrated to the backyard. I was 'nominated' to be her instructor. Things were complicated by her relative small size (5'2' / 157.5 cm) and mass (98 lbs. / 44.45 kg.). Figuring out all she really wanted to do was grab my cock, or nuts (both clothed) and pinch my nipples took all of thirty seconds.While tickling is not in your regularly accepted repertoire of wrestling moves, I had grown up with two brothers and plenty of young cousins. With my superior reach and strength, Vicky never stood a chance; so Kaelyne rushed in as well. When she proved unable to turn the tide (recall: I'm one of three; triplets), Brandy jumped me as well. This time I had the good sense to go down under their combined might, cry and beg for mercy.Thursday.With Brandy's acquiescence, if not outright permission, I gave Randi Leigh a blowjob opportunity before Home Room on Thursday. Mikhail was in the stall next to mine doing the exact same thing with Alondra. The difference was Alondra left with bounce in her stride and a smile on her face. Randi Leigh was fidgeting and uneasy.We missed Lunch Period, replacing it with a truncated orgy session which included Taliyah and Brandy plus Vantrice Kirby, Mia Ryker and Le 'Pearl' Yates. That left only Noémie Lucie Desdunes (in her case the middle name was a Creole thing) and Amber Lee Huffington, who were both in the B and T camp anyway. We could get them Saturday, or so the plotting went.The (Football) Coach and Principal decided since Friday was a 'home' game, we would have a 'memorial' service for Darius Pope; not that he had actually died, or anything; instead of the standard 'victory' party after the game. Apparently the Principal thought Brandy, as Darius' girlfriend, could help coordinate the function. Help as in work with the suddenly school-active Jewel Lafontanté.The other event was Hell Must Have Frozen Over and Satan had Klansmen shoveling coal like mad while he shivered in his igloo chateau; at least as far as the Kingston and Davis County social scene was concerned. The family of Gayle Fonteneau was invited to dinner at; the house of the Madam Mayor aka Dominique and Chinedu Malik.Her father had broken the hold the Fonteneau's had over the town which once bore their name; but now was Kingston, back in the late 1960's and early 70's, ushering an age of Black Supremacy into this burgh. It hadn't been an easy, or happy, transition either. Generations of Fonteneaus had treated the town as an extension of their own estate and hadn't welcomed the march of democratic progress.My Mom's rape, Uncle Theo's rampage of vengeance, and the resulting cover-up had severed the links between the Fonteneau Clan and the town of Kingston. That was the other, hidden, part of 'The Deal' which saw Uncle Theo going to a military school, not straight-out prison, for the punishment he'd visited on my mother's attackers.It could be argued Mom was now violating the 'corrupt' bargain between old Mayor Fox and Great Aunt Matilda. I also imagined neither ever thought their heirs would ever find 'common cause'. Both were now safely dead and if his daughter, Dominque, was bothered by this, she was doing the opposite of complaining.Had I realized how much Mom was sending Dominque's way, I would have been stunned. Had I realized how little of the Fonteneau fortune her support represented, I'd have cringed. The Fonteneau has been rife with eccentric, often wicked, geniuses for over two centuries.They'd invented and patented stuff, they swindled, robbed and stole from kinfolk, neighbors, towns, tribes, corporations and countries, and they invested that wealth with prescient ability. Unlike other famous American capitalists and industrialists, they hadn't felt obliged to build theater halls, university buildings, or jack-squat to remind the Rest Of The World how rich they'd become.No; they had miserly hoarded their wealth with one family member in each generation getting the lion's share along with the tacit understanding they took care of one another. That had equated to Great-Aunt Matilda being the inheritor in her generation, yet taking care of her sister's children as if they were her own.How much did 'we' have? Mom snorted and told me the Fonteneau never kept all their money in one place; in case something happened. Still, it wasn't like Uncle Cassius in that Indonesian prison didn't have his own 'resources' to keep him safe, or Uncle Theo kept evading prosecution based solely on his military training. Had either of those funds been traced back to our family, there could have been trouble; and those were just two examples of how Great-Aunt Matilda dispersed the family fortune.Anyway, I decided to bring Brandy along as my date/protective shielding. Mikhail laughingly suggested Alexander bring Ms. Blanchard. He suggested Vicky. I suggested Alondra. He scoffed. I suggested we'd need the distraction plus someone we could rely on to keep their mouth shut if something untoward happened (or, in Alondra's case, failed to understand the significance of).After 'dressing up', Mikhail and I had to double-back to school to pick up Brandy, Taliyah and Alondra for dinner. They, and about forty other students, had been shanghaied by Jewel into making the auditorium into a tribute to Darius Pope; odd since I imagined she despised the guy and rejoiced at his departure.‘Hey there,' Jewel greeted us as we entered the largely empty arena. ‘Vlad, is it? Mikhail?'Jewel was a tall (nearly 6 feet) woman with skin a soft shade of brown enhanced with coppery highlights. Currently her long, kinky black hair was worn braided with a mixture of beads and ribbons which 'clacked' when she moved. Her figure was dynamite, more a powerful Amazonian 'C' to Brandy's curvaceous 'D', but an ass just as scrumptious.Her lips were wide and her nose broad, but her most sensual quality, in my eyes, was her smoldering dark eyes; so dark they seemed totally devoid of an iris, yet keenly perceptive and subtly intelligent, surrounded by the longest, most natural-appearing eyelashes I'd ever witnessed.Today she was in a leather, electric blue mini-skirt, white knee socks and a long sleeved, skin-tight white shirt with the torso-sized images of a rampant phoenix and tiger facing one another on both front and back.‘Yes. Vladimir and Mikhail Samsonov, Ms. Lafontanté. A pleasure to meet you,' I stated since we'd never been formerly introduced. Likewise, I'd been raised a gentleman who waited for a lady to offer her hand to be shaken before a man shook it.She gave me an appraising, almost predatory, up-and-down gaze.‘Call me Jewel,' she extended me her hand.‘Vlad!' Brandy called out. Her someone must be trying to poach my Man sense must have gone off because I was definitely getting that sensation as her fingertips played across my fingers and palm before we shook hands. She had a confident, solid grip.‘Princess,' I was continuing to 'test drive' Brandy's pet name as I looked around Jewel.‘We are almost done,' Jewel shifted so as to interrupt my view (almost worked; but I was taller than she was).‘Let me help then,' I offered, even as I realized she hadn't let go of my hand yet.‘I'm planning on it,' she smirked, then released my hand and spun quickly around.‘Alright!' she addressed the room, the word accentuated with a sharp clap of her hands. ‘Let's finish getting those banners hung; Brandy?'Brandy was decidedly ignoring Jewel by throwing herself into my embrace and including an impressive, tongue-hungry lip-lock. 'Umm; tasty'. I kept her off the ground, so she decide to kick up both her legs until her heels almost touched her buttocks. When our mouths separated, she gave off a breathless giggle.‘Strawberry?' I questioned the flavor of her lip balm.‘Yes,' she grinned. With exaggerated slowness, Brandy turned to Jewel. ‘Almost done, Jefe?'‘So Jewel, I understand your regular cock wasn't getting the job done,' were the first words out of Mikhail's mouth; the Jackass! The assumption was he was referencing her dumping her last boyfriend; who was also here tonight.‘Mikhail!' Brandy gawked.‘Damn it, Mikhail,' I pivoted and glared at him.‘You auditioning for the job?' Jewel took a provocative pose. So much for the possibility of being offended. It was at times like this I didn't get women at all.‘I'm willing to put you in my rotation,' he bantered back courageously.‘What is mine, is mine. I don't share,' Jewel volleyed.‘You won't be the first Top Bitch I've had to deal with. Won't be the last,' he chuckled.‘Am I 'your type'?'‘Babe, you are hitting on all cylinders; you're smart, fierce, built like a true athlete; plus you think you are better than me,' he leered.‘I'm AM better than you, Samsonov.'‘By all means,' he took two steps her way. ‘Prove it.'‘Mikhail, we are here to retrieve our dates and go to dinner with our parents,' I reminded him. ‘Speaking of which; where are Taliyah and Alondra?'‘Which one of you is dating Alondra?' Jewel scoffed. With the way she said 'Alondra' she might as well have said 'The Chihuahua'. I put Brandy down.‘Alexander,' Brandy simmered. ‘They bonded over having a soul; unlike some people.' Gosh, that was awful feisty of Brandy. ‘Vlad, they went to get some colored light filters for the spotlights. They should be back soon.'‘Hey now,' I patted Brandy's ass. ‘Needless hostility isn't getting the work done.' I used that hand on the ass to press her against my hard-on to remind her of our primal connection.Her eyes flashed up, she gave me a salacious look, two hip wiggles, and then sauntered off to complete whatever project she was assigned. I tagged along because I both liked that ass and decided keeping close to her was my best bet to stay safe. Jewel directed Mikhail to help with something else. When Taliyah returned with Alondra and Misty Dawn in tow (along with several boxes of something), she immediately alerted to his distraction.She gave him no warning of her approach. Unfortunately for her, growing up triplets left us all a bit hyper-situationally aware and always ready for some rough and tumble, so Mikhail clued into the impending threat right before Taliyah repeated her Charlie Horse from Hell. Instead, he caught her blow, pulling her in and pinning one of her arms behind her back.‘Care to explain that?' Mikhail mused; 'that' being the incoming pain.‘I saw you scoping her out,' Taliyah sizzled.‘Well-duh,' he snorted, ‘but I wasn't touching, or anything.'‘You'd better not be.'‘Don't you have some work to do?' Jewel intervened.‘Yeah; if this Neanderthal would unhand me; ‘‘You going to take another swing at me?'‘You going to give me a reason to remind you to behave?' Taliyah snapped.‘Most likely,' my triplet shrugged then let her go.‘Come on Alondra,' Taliyah called over to the cheerleader. They went off to stack up the proper colored light filters by the various spot lights. The actual work would be done by the custodial staff sometime tomorrow.Soon enough we finished all our assignments. Jewel's No. 1 minion; a short, Sepia-complexioned, sharp-looking young lady named Dana Owens; checked off each completed item on her tablet as the group leaders reported to Jewel. She ran a very tight, almost scarily-so, regime. Notable absent were the student-athletes.Notably present was Jewel's ex-boyfriend, Shaka Sneed. He was handsome enough, chestnut-hued, slight acne-scarring along his cheeks with lighting-bolts cut on each side of his more-on-top, closer-cropped-on-the-side/back curly hair. He was right as 6' and broad enough in the chest and narrow enough in the hip to suggest he worked out once, or twice, a week, but his attempt to physically intimidate Mikhail was woefully ill-considered.His shiny, black tennis shoes, dark-grey slacks and black t-shirt were all top quality and tight enough to suggest he was 'aroused', but he was playing out of his league when comparing himself to any of us. Clearly not every BBC stud was packing a 10' Passion Piston inside his boxers and with all the hot chicks Jewel had assembled, it would have been pretty discernable it he'd had one.‘I don't like the way you were talking to Jewel,' he approached my brother as we were exiting the school.With so many polite replies to choose from and a proper dinner to get to; ‘What are you going to do about it?' we turned and regarded him.‘I; ah; ‘ Shaka stammered. Open, obvious defiance wasn't what he expected, despite some of the clear signs we Samsonovs weren't playing by the established rules.‘Listen up, Shaky,' Mikhail feigned annoyance, ‘I've got a dinner to go to. If all you are going to do is spit at me, I'm going to get to it. I'll catch up with you at lunch tomorrow and we'll settle Jewel's perceptions of your penile inadequacies then.'‘It is Shaka,' he insisted angrily.‘Whatever,' Mikhail shrugged.‘I'm going to inform Principal Jean-Georges of your threats,' Shaka pledged.‘What threats?' Mikhail gave a lopsided grin.‘You threatened to fight me at lunch tomorrow,' he looked left then right. We had quite a gathering. Since none of them looked ready to fight, it wasn't a problem.‘My exact words,' my triplet sounded bored, ‘we'll settle Jewel's perceptions of your penile inadequacies. Not once did I mention the words 'fight', punishment, or violence of any kind, Shaky.'‘It is Shaka!' he growled.‘It is Thomas,' Jewel announced in an amused tone. She'd been locking up.‘Shaky's real name is Thomas?' Mikhail's gaze settled on Jewel. ‘Why the fuck did he pick a shitty nickname like Shaky when he had a perfectly good name like Thomas to go by?'‘It Is Shaka; you pinhead!' Shaka shouted.‘Shaka? What kind of lame name is that?' Mikhail mocked him.‘It is Zulu, you dumbass cracker,' he glared.‘Why didn't you pick a more relevant name; like; Vlad, help me out here?' Mikhail's countenance lost all its humor.‘Like Agaja, Askia, Ewuare, or Samori?' I supplied some viable alternatives.‘Yeah; them. You know; West African war leaders you might have some relation to as opposed to a South African butcher who is as likely related to you as I am to Christopher Columbus, you dumbass nigger.'Silence.A White Boy had called a Black Man a 'nigger' and not just the 'n-word'.‘What did you call me?' Shaka puffed himself up.‘Whatever was the appropriate abusive racial insulting counter to 'cracker', pencil-dick,' Mikhail huffed.‘Say it.'‘Shaky.'‘You little bitch,' he said in a low voice.‘I promised we'd revisit your penile inadequacies at lunch tomorrow, Shaky, not now. If you are not going to 'jump', I've got a dinner to go to.'‘Chicken-shit.'‘I really don't have the time to go down the long list of all the things Jewel called you as she kicked you out of bed, Shaky; ‘ and then Shaka shoved him.‘That'll do, Pig. That'll do,' Mikhail chortled. He was getting ready to fight. We really didn't have the time to clean up this mess; I had no doubt Mikhail would destroy Shaka in ten seconds flat. The problem was we'd have to stick around and deal with the fallout which was time we didn't have.‘Enough,' Jewel intervened both verbally and vocally. She had two of her ladies backing her up. I had a firm hand on Mikhail's shoulder as a reminder we had to be elsewhere. ‘Shaka, I thought better of you,' she looked at her ex. ‘He's playing you.'‘You've been playing with him,' Shaka countered.‘Even if I was; which I was not (she wasn't?), I'm not your property, or your woman,' she sneered. ‘You are pathetic. I dumped you because I know I can do better.'Ouch! That was harsh.‘No; you can't,' Taliyah spoke up aka demarcating Mikhail. ‘Not while I'm standing.'‘Damn you, Jewel,' Shaka grabbed his former girl by the arm. ‘I; ‘And then she laid into him. I was pretty sure it was elbow to the solar plexus, a stomp on the instep and then an arm grab into judo flip, but head-over-heels Shaka went. I say 'pretty sure' because it was dusk and Jewel move freaky-fast. Shaka had been completely flipped over onto his back in that final, fluid move.Even though Jewel still had a painful hold of his wrist, it was clear Shaka was out of the fight. Any sane combatant would have stopped at that point. Not Jewel. Up came her foot and down came that heel on his crotch. Shaka hissed like a punctured Zeppelin. Every single guy who witnessed the blow recoiled instinctively in sympathetic agony as well. Not to be outdone though;‘I guess Shaka Zulu is now just another Bushman Brother,' Mikhail quipped jokingly.‘You are useless,' Taliyah began to drag him away.‘How is any of this my fault?' Mikhail laughed. ‘I didn't lay a hand on him.'‘You opened your fool-mouth,' she groused. She was dragging him off though.‘Alright everyone!' Jewel announced. ‘Time to go home.'Quickly enough there were only nine of us left standing there; Jewel, her six posse members, me and Brandy. Alondra had retreated with Taliyah and Mikhail. Shaka was still on the ground, hands cupping his tenderized privates.‘Yes?' Jewel tilted her head as she examined me.‘I'm hanging around to make sure Shaka makes it to his car okay.'‘I'll see to it.'‘I'll wait.'‘I said I'll see to it,' she reiterated as her eyes narrowed.‘Vlad, let's go,' Brandy tugged on my dress jacket.‘I heard you the first time, Ms. Lafontanté. You are also the one who put him in his current incapacitated condition, so I am going to stick around until I know he can take care of himself.'‘Do you think you can take me?' she shifted into a fighting stance; all subtle-like.‘I don't know. It isn't about me thinking I can beat you up. It is about not leaving any person at the mercy of those who would do them harm,' I explained coolly.‘Really?' she blinked.‘Really.'‘And if I tell you to get lost, or else?'I heard a car trunk shut rather gently; it was the 'click' of the lock engaging. Then came the crunch of the loose gravel on asphalt as my brother returned. Jewel's eyes shifted passed me, to him then back to me.‘You were stalling for time?'‘Pretty much,' I relaxed minutely.‘Here you go,' Mikhail handed me a padded, rattan practice broadsword. He had another broadsword plus a targe, a 20' diameter shield of Scottish origin).‘It is still seven on two odds.' from Jewel.‘We'll fight,' Brandy stated defensively.‘You and I ~' Taliyah directly addressed Jewel.‘Means nothing,' Jewel snorted. I could virtually see her work out the fight in her mind, going over and then discarding the various possibilities and resulting outcomes. Too many left her and hers with too many welts and bruises (rattan swords really sting) without a completely positive outcome.‘You don't even like him,' she motioned to the still moaning Shaka.‘That never matters,' Mikhail shrugged. ‘The moment you stomped on Shaky's peanuts, I knew Vlad wouldn't leave him here; at your mercy; so here we are.'‘Vlad?' Jewel searched my eyes for answers.‘Right is right and wrong is wrong,' I responded. ‘There is just and unjust punishment. You had every right to throw Mr. Sneed to the ground.'‘The heel to the groin was excessive,' I could hear myself channeling my Father. ‘At that point, he became a victim too. As my Brother said, I couldn't leave him at your mercy uncertain of your intentions.'‘So you do think you can take me,' she grinned like a Moray eel.‘I was really unsure until my Brother put this practice sword in my hand and returned to my side,' I related. ‘Even now, I'm not 100% positive. I've never witnessed your style of marital arts and you are certainly very good. Tha
Michael and Nikolay are joined by Antonín Houska to discuss pg_squeeze — what it is, how it started, some of its features, and hopes of getting the functionality into core. Here are some links to things they mentioned:Antonín Houska https://postgres.fm/people/antonin-houskapg_squeeze https://github.com/cybertec-postgresql/pg_squeezeCybertec https://www.cybertec-postgresql.compg_repack https://github.com/reorg/pg_repackIntroducing pg_squeeze (by Kaarel Moppel) https://www.cybertec-postgresql.com/en/introducing-pg_squeeze-a-postgresql-extension-to-auto-rebuild-bloated-tablespg_squeeze is included in the PostgreSQL APT packages https://wiki.postgresql.org/wiki/Aptpg_squeeze is included in the PostgreSQL Yum packages https://yum.postgresql.orgpg_rewrite https://github.com/cybertec-postgresql/pg_rewriteVACUUM FULL / CLUSTER CONCURRENTLY patch https://commitfest.postgresql.org/51/5117~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
For episode 475, CEO & Founder Nikolay Volf discusses Gear Tech and how they are supercharging Ethereum with Gear.exe. Gear is a technology company that contributes to the development of Gear Protocol and Vara Network. Gear Protocol offers exceptional technical capabilities and allows dApp developers to focus on their projects rather than building and operating an entirely new blockchain from scratch. ⏳ Timestamps: 0:00 | Introduction 1:03 | Who is Nikolay Volf? 3:25 | What is Gear Tech? 5:22 | What is Gear.exe? 8:22 | Use-cases for Gear.exe 9:38 | Gear.exe is bridgeless 10:40 | Parallel Execution 15:05 | No Fragmentation on Gear 16:00 | Reverse gas model 17:46 | Instant finalization 20:23 | Real-time updates on Ethereum 22:12 | Testnet & Mainnet 23:08 | 2025 roadmap 24:43 | Events in 2025 25:34 | Ethereum in 2025 30:02 | Documentation for Developers 31:14 | Whitepaper release 31:25 | Social Media & Communities
Michael and Nikolay are joined by Joe Sciarrino and Jelte Fennema-Nio to discuss pg_duckdb — what it is, how it started, what early users are using it for, and what they're working on next. Here are some links to things they mentioned:Joe Sciarrino https://postgres.fm/people/joe-sciarrinoJelte Fennema-Nio https://postgres.fm/people/jelte-fennema-niopg_duckdb https://github.com/duckdb/pg_duckdbHydra https://www.hydra.soMotherDuck https://motherduck.comThe problems and benefits of an elephant with a beak (lightning talk by Jelte) https://www.youtube.com/watch?v=ogvbKE4fw9A&list=PLF36ND7b_WU4QL6bA28NrzBOevqUYiPYq&t=1073spg_duckdb announcement post (by Jordan and Brett from MotherDuck) https://motherduck.com/blog/pg_duckdb-postgresql-extension-for-duckdb-motherduckpg_duckdb 0.2 release https://github.com/duckdb/pg_duckdb/releases/tag/v0.2.0~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Memories are a big part of celebrating the holidays, but is more than your brain involved in this process? Nikolay Kukushkin, clinical associate professor of life science at New York University, looks through the body to find out more. Nikolay Kukushkin is Clinical Associate Professor at NYU. He holds a D. Phil. in Biochemistry from […]
Nikolay and Michael discuss Row Level Security in Postgres, focussing on the performance side effects and some tips to avoid (or minimize) them. Here are some links to things they mentioned:Row Security Policies (docs) https://www.postgresql.org/docs/current/ddl-rowsecurity.html7+ million Postgres tables (recent talk by Kailash Nadh) https://www.youtube.com/watch?v=xhi5Q_wL9i0Row Level Security guide (Supabase docs) https://supabase.com/docs/guides/database/postgres/row-level-securitycurrent_setting function https://www.postgresql.org/docs/current/functions-admin.html#id-1.5.8.34.3.6.2.2.1.1.1.1Our slow count episode https://postgres.fm/episodes/slow-countRLS Performance and Best Practices (gist from Gary Austin) https://github.com/orgs/supabase/discussions/14576Everything you need to know about Postgres Row Level Security (talk by Paul Copplestone) https://www.youtube.com/watch?v=vZT1Qx2xUCoBUFFERS enabled for EXPLAIN ANALYZE by default (commit for Postgres 18) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c2a4078ebad71999dd451ae7d4358be3c9290b07Add UUID version 7 generation function (commit for Postgres 18) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=78c5e141e9c139fc2ff36a220334e4aa25e1b0ebPostgres hacking session with Andrey and Kirk (for UUIDv7): https://www.youtube.com/watch?v=YPq_hiOE-N8~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
On est à Turin pour les Nitto ATP Finals (le Masters qui regroupe les 8 meilleurs joueurs du monde) et j'en profite pour vous faire découvrir un club en Italie ainsi que les spécificités pour jouer dans ce coin du monde.Grand merci à Nikolay Tagantsev et Yannick Trojan de Tennis Theater qui nous ont emmené dans un country club découvrir de la bonne terre locale.
Michael and Nikolay are joined by Lukas Eder, the creator of jOOQ, to discuss what it is, some nice developer experience features it has, and some fun things he's come across from a Postgres perspective. Here are some links to things they mentioned:Lukas Eder https://postgres.fm/people/lukas-ederjOOQ https://www.jooq.org/ DSL https://en.wikipedia.org/wiki/Domain-specific_language SQL Dialects https://www.jooq.org/javadoc/latest/org.jooq/org/jooq/SQLDialect.htmlMERGE https://www.postgresql.org/docs/current/sql-merge.html match_recognize https://modern-sql.com/feature/match_recognize JOOQ, joy of SQL (talk by Kevin Davin) https://www.youtube.com/watch?v=8Ej47GZX9D8 BUFFERS enabled for EXPLAIN ANALYZE by default (commit for Postgres 18) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c2a4078ebad71999dd451ae7d4358be3c9290b07 PostGIS https://postgis.net/ 10 SQL Tricks That You Didn't Think Were Possible (blog post by Lukas) https://blog.jooq.org/10-sql-tricks-that-you-didnt-think-were-possible/ jOOQ questions on Stack Overflow https://stackoverflow.com/questions/tagged/jooq Our episode on NULLs https://postgres.fm/episodes/nulls-the-good-the-bad-the-ugly-and-the-unknown ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Nikolay and Michael discuss "Column Tetris" — what it is, why it matters, how to order columns for new tables, and how to re-organise existing ones. Here are some links to things they mentioned:“Column Tetris” by Erwin Brandstetter on Stack Overflow https://stackoverflow.com/questions/2966524/calculating-and-saving-space-in-postgresql/7431468#7431468Data Types https://www.postgresql.org/docs/current/datatype.htmlOrioleDB beta7 benchmarks https://www.orioledb.com/blog/orioledb-beta7-benchmarkspg_hexedit https://github.com/petergeoghegan/pg_hexeditSaving Space Basically for Free (blog post by James Coleman from Braintree) https://medium.com/paypal-tech/postgresql-at-scale-saving-space-basically-for-free-d94483d9ed9aOrdering Table Columns (GitLab https://docs.gitlab.com/ee/development/database/ordering_table_columns.htmlpostgres_dba alignment padding query https://github.com/NikolayS/postgres_dba/blob/master/sql/p1_alignment_padding.sqlGood explanation from Marco Slot of how alignment was used to fix a recent issue https://x.com/marcoslot/status/1858132850383421570pg_repack feature request discussion https://github.com/reorg/pg_repack/issues/101Our episode on bloat (with Chelsea Dole) https://postgres.fm/episodes/bloatOptimizing table layout for maximum efficiency (blog post by Renato Massaro) https://r.ena.to/blog/optimizing-postgres-table-layout-for-maximum-efficiency~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Nikolay and Michael discuss the track_planning parameter of pg_stat_statements — what it is, how it affects performance, and when or whether you should switch it on. Here are some links to things they mentioned:pg_stat_statements.track_planning https://www.postgresql.org/docs/current/pgstatstatements.html#id-1.11.7.40.9.2.4.1.3Our episode about pg_stat_statements https://postgres.fm/episodes/pg_stat_statementsPostgreSQL 13.0 release notes https://www.postgresql.org/docs/release/13.0/track_planning causing performance regression (thread on hackers during v13 beta) https://www.postgresql.org/message-id/flat/2895b53b033c47ccb22972b589050dd9%40EX13D05UWC001.ant.amazon.comOur episode on 4 million TPS https://postgres.fm/episodes/four-million-tpsObserver effect in pg_stat_statements and pg_stat_kcache (Postgres TV Hacking session with Andrey and Kirk) https://www.youtube.com/live/wHMNX-fHb2A?si=DPgmrPaSpPF6DxuS~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Michael and Nikolay are joined by Gülçin Yıldırım Jelínek and Robert Haas to discuss both the technical question of whether or not pg_dump is a backup tool, as well as the tone and intent behind the statement "pg_dump is not a backup tool". Here are some links to things they mentioned:Gülçin Yıldırım Jelínek https://postgres.fm/people/gulcin-yildirim-jelinekRobert Haas https://postgres.fm/people/robert-haasWhy you should upgrade PostgreSQL today (blog post by Gülçin) https://xata.io/blog/cve-2024-7348-postgres-upgradeIf pg_dump is not a backup tool, what is? (blog post by Gülçin) https://xata.io/blog/pgdump-is-not-a-backup-toolIs pg_dump a backup tool? (blog post by Robert) https://rhaas.blogspot.com/2024/10/is-pgdump-backup-tool.html?m=1Why pg_dump is amazing (blog post by Robert) https://rhaas.blogspot.com/2024/11/why-pgdump-is-amazing.htmlAvoid too prominent use of "backup" on pg_dump man page (commit by Peter Eisentraut) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=4f29394ea941f688fd4faf7260d2c198931ca797Is pg_dump a backup tool? (poll by Nikolay with options Yes / No / Define backup) https://x.com/samokhvalov/status/1847015453056786771What's the best way to make a backup (a recent example discussion on Reddit) https://www.reddit.com/r/PostgreSQL/comments/1gu4r05/whats_the_best_way_to_make_a_backup/Hackers mailing list https://www.postgresql.org/list/pgsql-hackers/ Praise, Criticism, and Dialogue (blog post by Robert) https://rhaas.blogspot.com/2023/12/praise-criticism-and-dialogue.html Out-of-cycle release scheduled for November 21, 2024 https://www.postgresql.org/about/news/out-of-cycle-release-scheduled-for-november-21-2024-2958/ pgBackRest https://github.com/pgbackrest/pgbackrest Barman https://github.com/EnterpriseDB/barman Our previous episode on backups https://postgres.fm/episodes/backups ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Nikolay and Michael discuss append-only tables in Postgres — what they are, some unique challenges they bring, and some options for compressing / removing / offloading the data eventually. Here are some links to things they mentioned:Append-only https://en.wikipedia.org/wiki/Append-onlyOur episode on BRIN indexes https://postgres.fm/episodes/brin-indexesTips to Improve Insert Performance https://www.timescale.com/blog/13-tips-to-improve-postgresql-insert-performance/ Our episode on WAL and checkpoint tuning https://postgres.fm/episodes/wal-and-checkpoint-tuningautovacuum_vacuum_insert_scale_factor https://www.postgresql.org/docs/current/runtime-config-autovacuum.html#GUC-AUTOVACUUM-VACUUM-INSERT-SCALE-FACTOR Our episode about compression https://postgres.fm/episodes/compressionNew project announced recently called BemiDB https://x.com/samokhvalov/status/1854726389603484145pg_tier https://github.com/tembo-io/pg_tier~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Nikolay and Michael discuss denormalization in Postgres — when and why to denormalize things, and a couple of specific cases Nikolay came across recently. Here are some links to things they mentioned:Denormalization https://en.wikipedia.org/wiki/DenormalizationOur episode on materialized views https://postgres.fm/episodes/materialized-viewsOur episode on data model trade-offs https://postgres.fm/episodes/data-model-trade-offsOur episode with Markus Winand https://postgres.fm/episodes/modern-sqlUniversal Relation Data Modelling Considered Harmful (blog post by Michael Stonebraker and Álvaro Hernández) https://www.enterprisedb.com/blog/universal-relation-data-modelling-considered-harmfulBoyce–Codd normal form https://en.wikipedia.org/wiki/Boyce%E2%80%93Codd_normal_formOur episode on slow count https://postgres.fm/episodes/slow-countpg_ivm https://github.com/sraoss/pg_ivmdenorm https://github.com/rivethealth/denormPostgres Materialized Views, The Timescale Way (blog post by David Kohn) https://www.timescale.com/blog/materialized-views-the-timescale-way/PgQ https://github.com/pgq/pgqDatabases, types, and the relational model (by C.J. Date and Hugh Darwen) https://www.dcs.warwick.ac.uk/~hugh/TTM/DTATRM.pdf~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Kerri covers a recommendation of familicide by Nikolay Soltys. Adults and children have lost their lives and we may never truly know the reason behind the murders. Donna's story this week is about The Coven House in South Carolina. A family had just made big changes to support Ken Fisher's dream to attend seminary when their world was turned upside down. This episode is sponsored by Hello Fresh. Get 10 FREE meals applied across seven boxes when you go to www.hellofresh.com/freecreep This episode is sponsored by Miracle Made. Upgrade your sleep today by going to www.trymiracle.com/creep to get 40% off and use promo code CREEP to get an additional 20% off and 3 free towels! If you have any local true crime, local urban legend/lore, ghost stories.. we want them all!! We want to hear from YOU. Especially if you have any funny Ambien stories!
Kerri covers a recommendation of familicide by Nikolay Soltys. Adults and children have lost their lives and we may never truly know the reason behind the murders. Donna's story this week is about The Coven House in South Carolina. A family had just made big changes to support Ken Fisher's dream to attend seminary when their world was turned upside down. This episode is sponsored by Hello Fresh. Get 10 FREE meals applied across seven boxes when you go to www.hellofresh.com/freecreep This episode is sponsored by Miracle Made. Upgrade your sleep today by going to www.trymiracle.com/creep to get 40% off and use promo code CREEP to get an additional 20% off and 3 free towels! If you have any local true crime, local urban legend/lore, ghost stories.. we want them all!! We want to hear from YOU. Especially if you have any funny Ambien stories!
Nikolay and Michael discuss online Postgres communities — the ones they prefer, the types of conversations in each, and some other places to ask questions or follow news. Here are some links to things they mentioned:https://www.postgresql.org/communityMailing lists https://www.postgresql.org/listIRC https://www.postgresql.org/community/ircSlack https://pgtreats.info/slack-inviteStack Overflow https://stackoverflow.com/questions/tagged/postgresDBA Stack Exchange https://dba.stackexchange.com/questions/tagged/postgresReddit https://www.reddit.com/r/PostgreSQLDiscord https://discord.gg/bW2hsax8WeHow to run ANALYZE (merge request discussion) https://gitlab.com/postgres-ai/postgresql-consulting/postgres-howtos/-/merge_requests/35This episode on YouTube https://postgresqlco.nfPlanet PostgreSQL https://planet.postgresql.orgPostgres Weekly https://postgresweekly.com~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Nikolay and Michael discuss some cool things you can do with psql, the official CLI that ships with Postgres. Here are some links to things they mentioned:psql docs https://www.postgresql.org/docs/current/app-psql.html Our episode on psql vs GUIs https://postgres.fm/episodes/psql-vs-guispostgres_dba https://github.com/NikolayS/postgres_dbaOur episode on massive deletes https://postgres.fm/episodes/massive-deletesPostgres hacking session on watch with limited number of loops https://www.youtube.com/watch?v=vTV8XhWf3mo pspg https://github.com/okbob/pspg Our episode on Postgres gotchas https://postgres.fm/episodes/postgres-gotchascurrent_setting() and set_config() docs https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SETpsql tips (site by Lætitia Avrot) https://psql-tips.org~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Nikolay and Michael discuss some Postgres Gotchas, things you might expect to work one way in fact working another way. Here are some links to things they mentioned:Out episode on NULLs https://postgres.fm/episodes/nulls-the-good-the-bad-the-ugly-and-the-unknownPostgres Gotchas (list by Ian Barwick) https://sql-info.de/postgresql/postgres-gotchas.htmlOur episode on slow count https://postgres.fm/episodes/slow-countDiscussion on X about major version upgrades and statistics https://x.com/samokhvalov/status/1844593601638260850Our episode on upgrades https://postgres.fm/episodes/upgradesStatistics Import and Export (commitfest entry which link to email thread) https://commitfest.postgresql.org/50/4538/vacuumdb https://www.postgresql.org/docs/current/app-vacuumdb.htmlvacuum_cost_delay https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-VACUUM-COST-DELAYZero-downtime Postgres schema migrations need lock_timeout and retries (blog post by Nikolay) https://postgres.ai/blog/20210923-zero-downtime-postgres-schema-migrations-lock-timeout-and-retriesPostgres Hacking 101: adding params, prevent_unqualified_deletes and prevent_unqualified_updates https://www.youtube.com/watch?v=samLkrC5xQA PostgREST suggestion to use pg-safeupdate https://docs.postgrest.org/en/v12/integrations/pg-safeupdate.html#pg-safeupdateDBOS (new company co-founded by Michael Stonebraker) https://www.dbos.dev~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Nikolay and Michael discuss some more advanced topics around EXPLAIN, including some tips for complex query plans, some recent improvements, and an idea or two that might make it even better. Here are some links to things they mentioned:Michael's solo episode on EXPLAIN basics https://postgres.fm/episodes/explainOur episode on auto_explain https://postgres.fm/episodes/auto_explainWhich cloud providers support auto_explain? (Blog post by Michael) https://www.pgmustard.com/blog/which-cloud-providers-support-auto-explainpsychopg https://www.psycopg.orgOur first episode on BUFFERS https://postgres.fm/episodes/buffers-by-defaultOur second episode on BUFFERS https://postgres.fm/episodes/buffers-ii-the-sequeltrack_io_timing https://www.postgresql.org/docs/current/runtime-config-statistics.html#GUC-TRACK-IO-TIMINGcompute_query_id https://www.postgresql.org/docs/current/runtime-config-statistics.html#GUC-COMPUTE-QUERY-ID EXPLAIN: beyond the basics (talk by Michael) https://www.youtube.com/watch?v=sGkSOvuaPs4~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Michael and Nikolay are joined by Alexander Kukushkin, PostgreSQL contributor and maintainer of Patroni, to discuss all things Patroni — what it is, how it works, recent improvements, and more.Here are some links to things they mentioned:Alexander Kukushkin https://postgres.fm/people/alexander-kukushkinPatroni https://github.com/patroni/patroniSpilo https://github.com/zalando/spilo Zalando Postgres Operator https://github.com/zalando/postgres-operatorCrunchy Data Postgres Operator https://github.com/CrunchyData/postgres-operatorSplit-brain https://en.wikipedia.org/wiki/Split-brain_(computing)repmgr https://github.com/EnterpriseDB/repmgrCloudNativePG https://github.com/cloudnative-pg/cloudnative-pgPatroni release notes https://patroni.readthedocs.io/en/latest/releases.htmlCitus & Patroni talk and demo by Alexander (at Citus Con 2023) https://www.youtube.com/watch?v=Mw8O9d0ez7E~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Hermoso capital humano, me complace presentarles este episodio especial de mi podcast, con Nikola Sofinskiy, quién es hoy, el embajador de Rusia en México. Hablamos sobre la relación histórica entre México y Rusia, BRICS, la posibilidad de México en BRICS, el conflicto entre Rusia y Ucrania y muchas cosas más. Espero que disfruten tanto como yo de esta colaboración y nos vemos pronto en otro episodio de ¿Por qué crees lo que crees?. Hosted on Acast. See acast.com/privacy for more information.
Nikolay and Michael discuss the fresh new Postgres 17 release! They cover several performance improvements, favourite new features, and some considerations for upgrading. Here are some links to things they mentioned:Postgres 17 release notes https://www.postgresql.org/docs/17/release-17.htmltransaction_timeout episode https://postgres.fm/episodes/transaction_timeoutVACUUM improvements discussed towards end of episode with Melanie Plageman https://postgres.fm/episodes/getting-started-with-benchmarkingB-tree improvements discussed in episdode with Peter Geoghegan https://postgres.fm/episodes/skip-scanAs Rails developers, why we are excited about PostgreSQL 17 (blog post by Benoit Tigeot) https://benoittgt.github.io/blog/postgres_17_rails/ Real World Performance Gains With Postgres 17 B-tree Bulk Scans (blog post by Brandur Leach) https://www.crunchydata.com/blog/real-world-performance-gains-with-postgres-17-btree-bulk-scansMERGE RETURNING came up towards end of episode with Haki Benita https://postgres.fm/episodes/get-or-createuuid_extract_timestamp and uuid_extract_version functions https://www.postgresql.org/docs/current/functions-uuid.htmlEpisode on UUID https://postgres.fm/episodes/uuidPartitioning by ULID https://postgres.fm/episodes/partitioning-by-ulidWhy Upgrade? (site by depesz) https://why-upgrade.depesz.comWhy we spent the last month eliminating PostgreSQL subtransactions (GitLab blog post) https://about.gitlab.com/blog/2021/09/29/why-we-spent-the-last-month-eliminating-postgresql-subtransactionsSynchronization of sequences to subscriber (patch that needs review!) https://commitfest.postgresql.org/49/5111~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Nikolay and Michael discuss planning time in Postgres — what it is, how to spot issues, its relationship to things like partitioning, and some tips for avoiding issues. Here are some links to things they mentioned:Query Planning (docs) https://www.postgresql.org/docs/current/runtime-config-query.htmlAre there limits to partition counts? (Blog post by depesz) https://www.depesz.com/2021/01/17/are-there-limits-to-partition-countsNikolays recent experiment https://postgres.ai/chats/01920004-a982-7896-b8cb-dfd2406359b0PgBouncer now supports prepared statements https://github.com/pgbouncer/pgbouncer/releases/tag/pgbouncer_1_21_0“The year of the lock manager's revenge” (from blog post by Jeremy Schneider) https://ardentperf.com/2024/03/03/postgres-indexes-partitioning-and-lwlocklockmanager-scalabilitypg_stat_statements.track_planning https://www.postgresql.org/docs/current/pgstatstatements.html#id-1.11.7.42.9.2.4.1.3pg_hint_plan https://github.com/ossc-db/pg_hint_plan~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Nikolay and Michael discuss why counting can be slow in Postgres, and what the options are for counting things quickly at scale. Here are some links to things they mentioned:Aggregate functions (docs) https://www.postgresql.org/docs/current/functions-aggregate.htmlPostgREST https://github.com/PostgREST/postgrest Get rid of count by default in PostgREST https://github.com/PostgREST/postgrest/issues/273 Faster PostgreSQL Counting (by Joe Nelson on the Citus blog) https://www.citusdata.com/blog/2016/10/12/count-performance Our episode on Index-Only Scans https://postgres.fm/episodes/index-only-scansPostgres HyperLogLog https://github.com/citusdata/postgresql-hllOur episode on Row estimates https://postgres.fm/episodes/row-estimates Our episode about dangers of NULLs https://postgres.fm/episodes/nulls-the-good-the-bad-the-ugly-and-the-unknown Aggregate expressions, including FILTER https://www.postgresql.org/docs/current/sql-expressions.html#SYNTAX-AGGREGATESSpread writes for counter cache (tip from Tobias Petry) https://x.com/tobias_petry/status/1475870220422107137pg_ivm extension (Incremental View Maintenance) https://github.com/sraoss/pg_ivm pg_duckdb announcement https://motherduck.com/blog/pg_duckdb-postgresql-extension-for-duckdb-motherduckOur episode on Queues in Postgres https://postgres.fm/episodes/queues-in-postgresOur episode on Real-time analytics https://postgres.fm/episodes/real-time-analyticsClickHouse acquired PeerDB https://clickhouse.com/blog/clickhouse-acquires-peerdb-to-boost-real-time-analytics-with-postgres-cdc-integrationTimescale Continuous Aggregates https://www.timescale.com/blog/materialized-views-the-timescale-wayTimescale editions https://docs.timescale.com/about/latest/timescaledb-editionsLoose indexscan https://wiki.postgresql.org/wiki/Loose_indexscan~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Michael and Nikolay are joined by Peter Geoghegan, major contributor and committer to Postgres, to discuss adding skip scan support to PostgreSQL over versions 17 and 18. Here are some links to things they mentioned:Peter Geoghegan https://postgres.fm/people/peter-geogheganPeter's previous (excellent) interview on Postgres TV https://www.youtube.com/watch?v=iAPawr1DxhMEfficient Search of Multidimensional B-Trees (1995 paper by Harry Leslie, Rohit Jain, Dave Birdsall, and Hedieh Yaghmai) https://vldb.org/conf/1995/P710.PDFIndex Skip Scanning in Oracle https://oracle-base.com/articles/9i/index-skip-scanningPeter's introductory email to the hackers mailing list about adding skip scan https://www.postgresql.org/message-id/CAH2-Wzmn1YsLzOGgjAQZdn1STSG_y8qP__vggTaPAYXJP+G4bw@mail.gmail.comLoose Indexscan versus Index Skip Scan (PostgreSQL wiki) https://wiki.postgresql.org/wiki/Loose_indexscanTom Lane will be on the Talking Postgres podcast on October 9th https://aka.ms/TalkingPostgres-Ep20-calBenoit Tigeot feedback and repro (originally reported via Slack) https://gist.github.com/benoittgt/ab72dc4cfedea2a0c6a5ee809d16e04d?permalink_comment_id=4597410#gistcomment-4597410Summary video and blog post about the v17 work by Lukas from pganalyze (not mentioned but great) https://pganalyze.com/blog/5mins-postgres-17-faster-btree-index-scansUnderstanding HNSW + filtering (pgvector repo discussion) https://github.com/pgvector/pgvector/issues/259btree_gin https://www.postgresql.org/docs/current/btree-gin.html~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
© 2020-2025 Ivy Podcast Discovery LLC
