Amit Langote

[Amit Langote @amitlan]

This is a such a good article.

https://t.co/mKniTy3uI9

[Amit Langote @amitlan]

Looking forward to watching this live (on tv).

[FUJI ROCK FESTIVAL @fujirock_jp]

━ 𝗡𝗘𝗪 ━
FOUR TET「Into Dust (Still Falling)」

Mazzy Starの代表曲の一つ「Into Dust」をサンプリングした #FourTet の最新トラックが解禁！
夜の苗場にぴったりな、美しく浮遊感のある1曲✨
🎧https://t.co/z3IKiNwiqf

@FourTet 7.26 (Sat) WHITE STAGE🎪
#フジロック

[PostgreSQL India @PGConfIndia]

Learn about Hacking Postgres Executor for Performance with @amitlan from @Microsoft at @PGConfIndia - the PostgreSQL conference. Reserve your seat now at https://t.co/bNJtWJ5FzH.
#PostgreSQL #PGConfIndia #OpenSource

[Amit Langote @amitlan]

ctrl-c
bash: history: write error: Success

[Amit Langote @amitlan]

@Sarthaklan Annual tradition. Like, to some degree, Diwali fireworks tradition in India.

https://t.co/gGcHQPn0d8

[Amit Langote @amitlan]

Watching Sumida River fireworks live broadcast on TV reminded me of this 8 year old tweet I posted while watching Edogawa River fireworks in person.

[Amit Langote @amitlan]

Watching 花火 is like listening to a classical music orchestra.

[Amit Langote @amitlan]

Thanks for organizing a great conference! Totally worth getting out of my shell. :-)

[PGConf.dev 🐘 @PGConfdev]

It’s a wrap. Melanie Plageman & Jonathan Katz just finished the closing remarks (with a big thank you 🙏 to all the sponsors organizers speakers volunteers & all the attendees) And now the last coffee break ☕️ is happening! What a great week 🔥

#postgresql #PGConfdev

[Claire Giordano ✨ @clairegiordano]

So much fun 🎉 talking to #PostgreSQL contributors & @AzureDBPostgres teammates to write this post ✍️ & share highlights of last 8 months of Postgres work at Microsoft!

🙏 Postgres friend who inspired me to write it = @robtreat2

I ❤️ all the work this infographic represents

[Amit Langote @amitlan]

Sakura 2024

[Amit Langote @amitlan]

@jer_s @fujii_masao Think you’ve answered this yourself elsewhere but a generic plan is created once and executed multiple times. Yes, the planner will lock all partitions when creating it. Ideally each subsequent execution should only lock partitions that are scanned, but that’s not the case today.

[Amit Langote @amitlan]

@jer_s @fritshoogland @samokhvalov @Adrien_nayrat @VKukharik That’s correct.

[Amit Langote @amitlan]

@jer_s @fujii_masao Generic plans *can* do partition elimination (thanks to the runtime pruning feature), but it’s not smart enough avoid locking eliminated partitions. Something we’re trying to address in the long running:

https://t.co/RmmFXJKoSo

You’re right about the plan_cache_mode override.

[David Rowley @davidrowley_pg]

If you're thinking of upgrading to PostgreSQL 16, I wrote this blog to help explain (with examples) what's changed since PG15 in the query planner/optimizer

[Amit Langote @amitlan]

@nuko_yokohama 去年行って来ました。

[Amit Langote @amitlan]

@gwenshap @robertmhaas Thanks. Though I'm hardly the only one to blame, :). As Robert said, committers tend to polish submissions before pushing into the tree and that's especially been true with partitioning code because of the need to integrate into query pipeline, a pretty readable codebase itself.

[Amit Langote @amitlan]

Go listen to Yo La Tengo. It works.

[Amit Langote @amitlan]

a bit more on performance of prepared statements with partitioning: https://t.co/oqaupOYlmF

[Amit Langote @amitlan]

on performance of prepared statements with partitioning: https://t.co/eeKU6caeuX

[Brandur @brandur]

We put our first partitioned table into prod, so did a small write up on what it's like to use partitioning in Postgres nowadays.

Progress on this feature over 5 years is downright incredible. Managing a partitioned table is 90% as easy as a normal one.

https://t.co/mVBQq9HxYw

[Amit Langote @amitlan]

@michaelpq Congrats!

[Amit Langote @amitlan]

@masahiko_sawada Congrats!