Podcasts about nikolay

Nikolay and Michael are joined by Gwen Shapira to discuss multi-tenant architectures — the high level options, the pros and cons of each, and how they're trying to help with Nile. Here are some links to things they mentioned:Gwen Shapira https://postgres.fm/people/gwen-shapiraNile https://www.thenile.devSaaS Tenant Isolation Strategies (AWS whitepaper) https://docs.aws.amazon.com/whitepapers/latest/saas-tenant-isolation-strategies/saas-tenant-isolation-strategies.html Row Level Security https://www.postgresql.org/docs/current/ddl-rowsecurity.htmlCitus https://github.com/citusdata/citusPostgres.AI Bot https://postgres.ai/blog/20240127-postgres-ai-bot RLS Performance and Best Practices https://supabase.com/docs/guides/troubleshooting/rls-performance-and-best-practices-Z5JjwvCase Gwen mentioned about the planner thinking an optimisation was unsafe Re-engineering Postgres for Millions of Tenants (Gwen's recent talk at PGConf.dev) https://www.youtube.com/watch?v=EfAStGb4s88 Multi-tenant database the good, the bad, the ugly (talk by Pierre Ducroquet at PgDay Paris) https://www.youtube.com/watch?v=4uxuPfSvTGU ~~~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 looking at queries by mean time — when it makes sense, why ordering by a percentile (like p99) might be better, and the merits of approximating percentiles in pg_stat_statements using the standard deviation column. Here are some links to things they mentioned:Approximate the p99 of a query with pg_stat_statements (blog post by Michael) https://www.pgmustard.com/blog/approximate-the-p99-of-a-query-with-pgstatstatementspg_stat_statements https://www.postgresql.org/docs/current/pgstatstatements.html Our episode about track_planning https://postgres.fm/episodes/pg-stat-statements-track-planning pg_stat_monitor https://github.com/percona/pg_stat_monitorstatement_timeout https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-STATEMENT-TIMEOUT~~~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-354 #ProgressiveHouse #MelodicTechno При прослушивании любимой музыки, человек может испытывать чувство радости, умиротворения и вдохновения. Музыка способна переносить нас в другие миры, пробуждать в нас самые разные эмоции и чувства. *Apple Podcast: apple.co/2KZwKY8 *vk.com/nikolaymachaon *Deezer: deezer.page.link/cJWg5nwHXzhbs… Track List: DePo Podcast-#2025-#354 1 Around Us - Best Kept (Original Mix) [ARRVL Records] 2 Benja Molina, N-TCHBL - Endless Night (Feat. N-TCHBL Extended Mix) [Univack] 3 Alain Pauwels, Valen Gonzalez - Albuquerque (Erich LH Remix) [onedotsixtwo] 4 Stani Stern - Sternenhimmel (Ariel Stamile Remix) [AH Digital] 5 COQUEIT - Dock (Original Mix) [Sun explosion] 6 Seyah - Horizon (Luca Abayan & Tato Seco Remix) [Mango Alley] 7 Alain Pauwels, Valen Gonzalez - Sinaloa (Neuralis Remix) [onedotsixtwo] 8 Bondarev - Remote Control (HAFT Remix) [WARPP] 9 Rikken - Dreamscape Drift (Original Mix) [Balkan Connection] 10 ALPHA21 & Venao - Tour of the Human Mind (Original Mix)

Nikolay Danev - Tech This - June 25 by Vibes Radio Station

Nikolay and Michael discuss logging in Postgres — mostly what to log, and why changing quite a few settings can pay off big time in the long term. Here are some links to things they mentioned:What to log https://www.postgresql.org/docs/current/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHATOur episode about Auditing https://postgres.fm/episodes/auditing Our episode on auto_explain https://postgres.fm/episodes/auto_explain Here are the parameters they mentioned changing:log_checkpointslog_autovacuum_min_duration log_statementlog_connections and log_disconnectionslog_lock_waitslog_temp_fileslog_min_duration_statement log_min_duration_sample and log_statement_sample_rate And finally, some very useful tools they meant to mention but forgot to!   https://pgpedia.infohttps://postgresqlco.nfhttps://why-upgrade.depesz.com/show?from=16.9&to=17.5 ~~~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-353 #ProgressiveHouse #MelodicTechno При прослушивании любимой музыки, человек может испытывать чувство радости, умиротворения и вдохновения. Музыка способна переносить нас в другие миры, пробуждать в нас самые разные эмоции и чувства. *Apple Podcast: apple.co/2KZwKY8 *vk.com/nikolaymachaon *Deezer: deezer.page.link/cJWg5nwHXzhbs… Track List: DePo Podcast-#2025-#353 1Beat Tonic - Dear Samira (Mariano Giacinti Remix) Massive [Harmony Records] 2Braian Perello - Deepmind (Original Mix) [The Soundgarden] 3Mind Echoes - Unsafe Numbers (Tonaco & Tomas Garcia Remix) [onedotsixtwo] 4Chicato - Agatsuma (Original Mix) [Sounds and Frequencies Recordings] 5Bruno Alonso - Each Other (Tirso Enriquez AR Night Remix) [3rd Avenue] 6Nicolas Benedetti - Magari (Original Mix) [Movement Recordings] 7Moodfreak, Campaner (BR) - Borderline (Original Mix)[YOMO Records] 8Nikola Jovanovic - Marynia (Original Mix) [Symmetric Records] 9Bondarev & Anton Borin (RU) - Samadhi (Hobin Rude Remix) [WARPP] 10Praise (BR) - Riser (Original Mix) [Routine Espresso Recordings] 11Himbrecht - Stolen Youth (Original Mix) [3rd Avenue]

Nikolay and Michael discuss moving off managed services — when and why you might want to, and some tips on how for very large databases. Here are some links to things they mentioned:Patroni https://github.com/patroni/patronipgBackRest https://github.com/pgbackrest/pgbackrestWAL-G https://github.com/wal-g/wal-gHetzner Cloud https://www.hetzner.com/cloudPostgres Extensions Day https://pgext.daypg_wait_sampling https://github.com/postgrespro/pg_wait_samplingpg_stat_kcache https://github.com/powa-team/pg_stat_kcacheauto_explain https://www.postgresql.org/docs/current/auto-explain.htmlFivetran https://www.fivetran.compgcopydb https://github.com/dimitri/pgcopydbKafka https://kafka.apache.orgDebezium https://debezium.iomax_slot_wal_keep_size https://www.postgresql.org/docs/current/runtime-config-replication.html#GUC-MAX-SLOT-WAL-KEEP-SIZElog_statement DDL https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-LOG-STATEMENTPgBouncer pause/resume https://www.pgbouncer.org/usage.html#pause-db~~~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-352 #ProgressiveHouse #MelodicTechno При прослушивании любимой музыки, человек может испытывать чувство радости, умиротворения и вдохновения. Музыка способна переносить нас в другие миры, пробуждать в нас самые разные эмоции и чувства. *Apple Podcast: apple.co/2KZwKY8 *vk.com/nikolaymachaon *Deezer: deezer.page.link/cJWg5nwHXzhbs… Track List: DePo Podcast-#2025-#352 1ÜSHMÜEL - Bees Make Honey (Original Mix) [Luum Records] 2Luca Be - Eternal Flow (Original Mix) [South America Avenue] 3Ilias Katelanos, ECHO DAFT, Plecta - Infinity Rhythm (Extended Mix)[Univack] 4Gorkiz, Andre Moret - Cheery Instinct (Original Mix) [CONCATENATE] 5Sinan Arsan - Beginnings (Ramuco Rmx) [Superordinate Music] 6Rodrigo Pochelu, Chär Spinelli - Destiny (Original Mix)[Balkan Connection] 7Marco Boarelli - The Moon (Martin Di Sciascio Remix)[AH Digital] 8Kamilo Sanclemente, Andre Moret - Mirage (Original Mix) [Warung Recordings] 9Juan Deminicis - Under Control (Original Mix) [UV Noir] 10Javier Misa, SANTIABLO - Enigmatic Resonance (Extended Mix) [Freegrant Music]

In this episode, we discuss how artificial intelligence can boost your online store sales through smart product recommendations. Nikolay Gushchin, a software engineer and founder of an AI-powered Shopify extension, shares insights from his eight years in tech working with major brands.He explains how AI analyzes customer behavior to suggest the right products at the right time and offers practical tips for balancing automated recommendations with human input in your e-commerce business. Topics discussed in this episode: Why basic “people also bought” tools fall short in eCommerce. How AI boosts conversions with smarter Shopify recommendations. Why most recommendation engines miss the mark. What a quick, plug-and-play AI setup looks like. Why smaller brands move faster with AI tools. How AI and manual tweaks make better product bundles. Why “below the fold” can kill your sales. What AI “Shop the Look” features mean for fashion stores. How AI knows what to recommend based on user behavior. Why personalization drives sales for any store size. Links & Resources Website: https://apps.shopify.com/aetherwave-recommendations Shopify App Store: https://apps.shopify.com/aetherwave-recommendations Get access to more free resources by visiting the show notes athttps://tinyurl.com/bdfzdatpSUPPORT OUR SPONSORThis episode is sponsored by Ahrefs — the all-in-one marketing intelligence platform trusted by SEO professionals, content creators, and digital marketers around the world. Whether you're doing keyword research, checking backlinks, or analyzing competitors, Ahrefs gives you the tools to make smarter marketing decisions.

Nikolay and Michael discuss heavyweight locks in Postgres — how to think about them, why you can't avoid them, and some tips for minimising issues. Here are some links to things they mentioned:Locking (docs) https://www.postgresql.org/docs/current/explicit-locking.htmlPostgres rocks, except when it blocks (blog post by Marco Slot) https://www.citusdata.com/blog/2018/02/15/when-postgresql-blocks/Lock Conflicts (tool by Hussein Nasser) https://pglocks.org/log_lock_waits (docs) https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-LOG-LOCK-WAITSHow to analyze heavyweight lock trees (guide by Nikolay) https://gitlab.com/postgres-ai/postgresql-consulting/postgres-howtos/-/blob/main/0042_how_to_analyze_heavyweight_locks_part_2.mdLock management (docs) https://www.postgresql.org/docs/current/runtime-config-locks.htmlOur episode on zero-downtime migrations https://postgres.fm/episodes/zero-downtime-migrations~~~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 Filichkin is the Co-Founder and Chief Business Officer of Compute Labs, a cutting-edge infrastructure company transforming access to compute by financializing GPU assets. With over a decade of experience in technology, M&A, and strategic partnerships, Nikolay plays a key role in creating the financial ecosystem for compute as an asset class.Prior to Compute Labs, Nikolay spent 6+ years at Xsolla, where he led strategic partnerships and helped scale the company from 200 to over 1,200 employees. He drove five acquisitions, launched three new product lines, and helped expand Xsolla's global presence across gaming and digital commerce.Nikolay is a builder and operator who understands how to take ideas from 0 to 1 and then scale them. At Compute Labs, he leads business development and investor relations, helping institutional allocators and partners gain access to the financial upside of AI infrastructure during this key period of growth.

Nikolay Filichkin is the Co-Founder and Chief Business Officer of Compute Labs, a cutting-edge infrastructure company transforming access to compute by financializing GPU assets. With over a decade of experience in technology, M&A, and strategic partnerships, Nikolay plays a key role in creating the financial ecosystem for compute as an asset class.Prior to Compute Labs, Nikolay spent 6+ years at Xsolla, where he led strategic partnerships and helped scale the company from 200 to over 1,200 employees. He drove five acquisitions, launched three new product lines, and helped expand Xsolla's global presence across gaming and digital commerce.Nikolay is a builder and operator who understands how to take ideas from 0 to 1 and then scale them. At Compute Labs, he leads business development and investor relations, helping institutional allocators and partners gain access to the financial upside of AI infrastructure during this key period of growth.

Deep Poisson PDCT-351 #ProgressiveHouse #MelodicTechno При прослушивании любимой музыки, человек может испытывать чувство радости, умиротворения и вдохновения. Музыка способна переносить нас в другие миры, пробуждать в нас самые разные эмоции и чувства. *Apple Podcast: apple.co/2KZwKY8 *vk.com/nikolaymachaon *Deezer: deezer.page.link/cJWg5nwHXzhbs… Track List: DePo Podcast-#2025-#351 01 Weird Sounding Dude - Metal Heart [The Soundgarden] 02 Fran Martinez - Boragine's [Future Avenue] 03 Mauro Augugliaro - Ripples [Suza Records] 04 Rokazer - Magnetic [Mango Alley] 05 Dmitry Molosh - Butterfly (Analog Jungs Remix) [WARPP] 06 Bondarev & Dowden - Tranquility (Hot TuneiK Remix) [One Of A Kind] 07 Rauschhaus - Mindworm (The Wash Remix) [Mango Alley] 08 Goraieb & Luciano Scheffer - Endless Symphony (NOIYSE PROJECT Remix) [La Cura de la Semana] 09 Tantum - Havel (Original Mix) [Lost & Found] 10 Ananta - Verdad (Nicolas Bertoldi Remix) [Future Avenue]

Nikolay and Michael discuss ten dangerous Postgres related issues — ones that might be painful enough to get onto the CTO and even CEOs desk, and then what you can do proactively. The ten issues discussed are:Heavy lock contentionBloat control and index maintenance  Lightweight lock contentionTransaction ID wraparound4-byte integer PKs hitting the limitReplication limitsHard limitsData lossPoor HA choice (split brain)Corruption of various kindsSome previous episodes they mentioned that cover the issues in more detail: PgDog https://postgres.fm/episodes/pgdogPerformance cliffs https://postgres.fm/episodes/performance-cliffsZero-downtime migrations https://postgres.fm/episodes/zero-downtime-migrations Queues in Postgres https://postgres.fm/episodes/queues-in-postgresBloat https://postgres.fm/episodes/bloatIndex maintenance https://postgres.fm/episodes/index-maintenanceSubtransactions https://postgres.fm/episodes/subtransactionsFour million TPS https://postgres.fm/episodes/four-million-tpsTransaction ID wraparound https://postgres.fm/episodes/transaction-id-wraparoundpg_squeeze https://postgres.fm/episodes/pg_squeeze synchronous_commit https://postgres.fm/episodes/synchronous_commitManaged service support https://postgres.fm/episodes/managed-service-support And finally, some other things they mentioned: A great recent SQL Server-related podcast episode on tuning techniques https://kendralittle.com/2024/05/20/erik-darling-and-kendra-little-rate-sql-server-performance-tuning-techniques/Postgres Indexes, Partitioning and LWLock:LockManager Scalability (blog post by Jeremy Schneider) https://ardentperf.com/2024/03/03/postgres-indexes-partitioning-and-lwlocklockmanager-scalability/Do you vacuum everyday? (talk by Hannu Krosing) https://www.youtube.com/watch?v=JcRi8Z7rkPgpg_stat_wal https://pgpedia.info/p/pg_stat_wal.htmlThe benefit of lz4 and zstd for Postgres WAL compression (Small Datum blog, Mark Callaghan) https://smalldatum.blogspot.com/2022/05/the-benefit-of-lz4-and-zstd-for.htmlSplit-brain in case of network partition (CloudNativePG issue/discussion) https://github.com/cloudnative-pg/cloudnative-pg/discussions/7462 ~~~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-350 #ProgressiveHouse #MelodicTechno При прослушивании любимой музыки, человек может испытывать чувство радости, умиротворения и вдохновения. Музыка способна переносить нас в другие миры, пробуждать в нас самые разные эмоции и чувства. *Apple Podcast: apple.co/2KZwKY8 *vk.com/nikolaymachaon *Deezer: deezer.page.link/cJWg5nwHXzhbs… Track List: DePo Podcast-#2025-#350 1 Peter Zherebtsov - Futurist (Original Mix) [Kanja Records] 2 Jose Vizcaino - Pro Penso (Original Mix) [Natural Beat Recordings] 3 Mirel - 432 (Original Mix) [Jelly Beast Recordings] 4 E.T.H (Italy) - Gun Insecte (Original Mix) [Natural Beat Recordings] 5 AG - A1 Metamorphosis part 1 VINYL ONLY [OsloGround] 6 BRYZ - Inosit Metada (Original Mix) [Quanticman Records] 7 Javier Ferreira - Blackout (Original Mix) [Ninefont Music] 8 Jet Hammer - Last Night [Running Back] 9 Juan Mejia - Atlas (Costela Remix) [Personal Belongings] 10 Happyghost - Ishy Really Bad [Aathee]

Nikolay Danev - Tech This - May 25 by Vibes Radio Station

Nikolay and Michael discuss synchronous_commit — what it means on single node setups, for synchronous replication setups, and the pros and cons of the different options for each. Here are some links to things they mentioned:synchronous_commit https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-SYNCHRONOUS-COMMITsynchronous_commit history on pgPedia https://pgpedia.info/s/synchronous_commit.htmlPatroni's maximum_lag_on_failover setting https://patroni.readthedocs.io/en/master/replication_modes.html#asynchronous-mode-durabilitywal_writer_delay https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-WAL-WRITER-DELAYSelective asynchronous commits in PostgreSQL - balancing durability and performance (blog post by Shayon Mukherjee) https://www.shayon.dev/post/2025/75/selective-asynchronous-commits-in-postgresql-balancing-durability-and-performance/Asynchronous Commit https://www.postgresql.org/docs/current/wal-async-commit.htmlsynchronous_standby_names https://www.postgresql.org/docs/current/runtime-config-replication.html#GUC-SYNCHRONOUS-STANDBY-NAMESJepson article about Amazon RDS multi-AZ clusters (by Kyle Kingsbury, aka "Aphyr”) https://jepsen.io/analyses/amazon-rds-for-postgresql-17.4~~~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-349 #ProgressiveHouse #MelodicTechno При прослушивании любимой музыки, человек может испытывать чувство радости, умиротворения и вдохновения. Музыка способна переносить нас в другие миры, пробуждать в нас самые разные эмоции и чувства. *Apple Podcast: apple.co/2KZwKY8 *vk.com/nikolaymachaon *Deezer: deezer.page.link/cJWg5nwHXzhbs… Track List: DePo Podcast-#2025-#349 01 Jiminy Hop - Coruto (Original Mix) [Univack] 02 Smirre - Charisma (Emma Fraga Remix) [Future Avenue] 03 Roger Martinez, Alex O'Rion - De Machtige Trip - Alex O'Rion Remix [Higher States] 04 Dabeat & Kamilo Sanclemente - Elara [Proton Music] 05 Nick Muir - All One Word (GMJ & Matter Remix) [Proton Music] 06 Rockka & Randle - Rewire [One Of A Kind] 07 Kebin van Reeken - Hyphae (Agustin Pietrocola Remix) [MNL] 08 Rockka - Operator (Maze 28 Remix) [Mango Alley] 09 Analog Jungs - Connection (Integral Bread Remix) [Univack] 10 Martin Davila - Haumea (Fran Garay Remix) [Massive Harmony Records]

Nikolay and Michael discuss managed service support — some tips on how to handle cases that aren't going well, tips for requesting features, whether to factor in support when choosing service provider, and whether to use one at all. Here are some links to things they mentioned:YugabyteDB's new upgrade framework https://www.yugabyte.com/blog/postgresql-upgrade-frameworkEpisode on Blue-green deployments https://postgres.fm/episodes/blue-green-deploymentspg_createsubscriber https://www.postgresql.org/docs/current/app-pgcreatesubscriber.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 credit to:Jessie Draws for the elephant artwork

Deep Poisson PDCT-348 #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-#2024-#348 1Fede Archdale - Smoothy (Original Mix)[3rd Avenue] 2Danae (NL) - Cool Alpaca (Eichenbaum Remix) [MNL] 3David Podhel, Noise Generation - Namaya (Taylan Remix) [One Of A Kind] 4Redspace, Shell Robinson - Reflections (Julieta Kühnle Remix) [Juicebox Music] 5Fernan De Santis - Sea of Dreams (Facu Bausset Remix) [AH Digital] 6Juan Lagisquet - Pinecone (Gorkiz, Mind Echoes Remix) [onedotsixtwo] 7Rodrigo Pochelu, Fefo & Moli - Frida (Original Mix) [One Of A Kind] 8Deepfire - Smile (Original Mix) [AH Digital] 9Kamilo Sanclemente - Whale Voices (Original Mix) [Univack] 10Simply City - The Ripple Effect (Original Mix) [Sudbeat Music]

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

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 

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. 

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

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

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 

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 

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 

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 

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 

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!