Gwen Shapira
@gwenshap.bsky.social
Founder of SaaS Developer Community and Nile Database.
Reposted by Gwen Shapira
CFP for PGConf.dev 2026 is open until Jan 16 🐘
Tips for strong proposals:
• Share what you discovered. Not just what you built.
• Be specific
• Discuss bigger Postgres picture
• Failures welcome
Be specific, connect to Postgres internals, and don’t hide the messy bits.
Tips for strong proposals:
• Share what you discovered. Not just what you built.
• Be specific
• Discuss bigger Postgres picture
• Failures welcome
Be specific, connect to Postgres internals, and don’t hide the messy bits.
November 10, 2025 at 5:30 PM
CFP for PGConf.dev 2026 is open until Jan 16 🐘
Tips for strong proposals:
• Share what you discovered. Not just what you built.
• Be specific
• Discuss bigger Postgres picture
• Failures welcome
Be specific, connect to Postgres internals, and don’t hide the messy bits.
Tips for strong proposals:
• Share what you discovered. Not just what you built.
• Be specific
• Discuss bigger Postgres picture
• Failures welcome
Be specific, connect to Postgres internals, and don’t hide the messy bits.
Reposted by Gwen Shapira
At what point do we stop saying “worth its weight in gold” and start saying “worth its weight in high-end GPU”?
September 28, 2025 at 4:22 PM
At what point do we stop saying “worth its weight in gold” and start saying “worth its weight in high-end GPU”?
Reposted by Gwen Shapira
Reposted by Gwen Shapira
So.. Pierre Barre just built an NFS server implementation on SlateDB. ZeroFS is today days old, but it's going to get wild. Bottomless storage and checkpoints mean instant FS snapshots (zero overhead).
github.com/Barre/zerofs
github.com/Barre/zerofs
GitHub - Barre/zerofs: ZeroFS: The S3FS that does not suck.
ZeroFS: The S3FS that does not suck. Contribute to Barre/zerofs development by creating an account on GitHub.
github.com
July 14, 2025 at 10:32 PM
So.. Pierre Barre just built an NFS server implementation on SlateDB. ZeroFS is today days old, but it's going to get wild. Bottomless storage and checkpoints mean instant FS snapshots (zero overhead).
github.com/Barre/zerofs
github.com/Barre/zerofs
Reposted by Gwen Shapira
I use a spreadsheet to track all my documentation
It's important to keep all your docs in a row
It's important to keep all your docs in a row
June 16, 2025 at 5:26 PM
I use a spreadsheet to track all my documentation
It's important to keep all your docs in a row
It's important to keep all your docs in a row
Videos from PgConfDev are starting to show up on YouTube!
Great time to catch up on both the new content and the amazing talks from past events.
You can start with my talk: "Scaling Postgres to Million Tenants"
www.youtube.com/watch?v=EfAS...
Great time to catch up on both the new content and the amazing talks from past events.
You can start with my talk: "Scaling Postgres to Million Tenants"
www.youtube.com/watch?v=EfAS...
Re-engineering Postgres for Millions of Tenants (PGConf.dev 2025)
YouTube video by PostgreSQL Development Conference
www.youtube.com
June 10, 2025 at 3:33 AM
Videos from PgConfDev are starting to show up on YouTube!
Great time to catch up on both the new content and the amazing talks from past events.
You can start with my talk: "Scaling Postgres to Million Tenants"
www.youtube.com/watch?v=EfAS...
Great time to catch up on both the new content and the amazing talks from past events.
You can start with my talk: "Scaling Postgres to Million Tenants"
www.youtube.com/watch?v=EfAS...
So, Tensor (as in Pytorch) is just like a vector, except that it is somehow better for GPUs? Did I get that right?
May 30, 2025 at 9:35 PM
So, Tensor (as in Pytorch) is just like a vector, except that it is somehow better for GPUs? Did I get that right?
“Why is Postgres seq-scanning rather than use this index?” 🤯
Short answer: the planner thinks that index won’t help (or can’t use it).
Longer answer—5 usual suspects 👇
Short answer: the planner thinks that index won’t help (or can’t use it).
Longer answer—5 usual suspects 👇
May 29, 2025 at 8:06 PM
“Why is Postgres seq-scanning rather than use this index?” 🤯
Short answer: the planner thinks that index won’t help (or can’t use it).
Longer answer—5 usual suspects 👇
Short answer: the planner thinks that index won’t help (or can’t use it).
Longer answer—5 usual suspects 👇
Cats are great, actually.
May 29, 2025 at 4:00 PM
Cats are great, actually.
Reposted by Gwen Shapira
New blog: Using Postgres pg_test_fsync tool for testing low latency writes
An easy to use tool that comes with standard Postgres installation, for testing write latency of devices where you put your WAL/redo logs and any other files requiring low write latency.
(link in reply)
An easy to use tool that comes with standard Postgres installation, for testing write latency of devices where you put your WAL/redo logs and any other files requiring low write latency.
(link in reply)
May 28, 2025 at 2:14 AM
New blog: Using Postgres pg_test_fsync tool for testing low latency writes
An easy to use tool that comes with standard Postgres installation, for testing write latency of devices where you put your WAL/redo logs and any other files requiring low write latency.
(link in reply)
An easy to use tool that comes with standard Postgres installation, for testing write latency of devices where you put your WAL/redo logs and any other files requiring low write latency.
(link in reply)
Reposted by Gwen Shapira
I feel like I've found a new controlling meme for open source contribution and innovation.
May 25, 2025 at 5:36 PM
I feel like I've found a new controlling meme for open source contribution and innovation.
Reposted by Gwen Shapira
I've registered it with context7 so it's now available as up-to-date nile documentation via the context7 MCP context7.com/www.thenile....
Context7 - Up-to-date documentation for LLMs and AI code editors
Generate context with up-to-date documentation for LLMs and AI code editors
context7.com
May 22, 2025 at 10:20 PM
I've registered it with context7 so it's now available as up-to-date nile documentation via the context7 MCP context7.com/www.thenile....
🚨 New blog alert:
Postgres 18 beta 1 was released last week, and includes native support for UUIDv7.
Great opportunity to explain why UUIDv7 is a great fit for your database keys, and show you how to use them in PG18.
www.thenile.dev/blog/uuidv7
Postgres 18 beta 1 was released last week, and includes native support for UUIDv7.
Great opportunity to explain why UUIDv7 is a great fit for your database keys, and show you how to use them in PG18.
www.thenile.dev/blog/uuidv7
May 20, 2025 at 4:54 PM
🚨 New blog alert:
Postgres 18 beta 1 was released last week, and includes native support for UUIDv7.
Great opportunity to explain why UUIDv7 is a great fit for your database keys, and show you how to use them in PG18.
www.thenile.dev/blog/uuidv7
Postgres 18 beta 1 was released last week, and includes native support for UUIDv7.
Great opportunity to explain why UUIDv7 is a great fit for your database keys, and show you how to use them in PG18.
www.thenile.dev/blog/uuidv7
You know the advice to say "thank you" instead of "sorry"?
It looks like ChatGPT took it to heart.
Me: You just said something incorrect.
ChatGPT: Thank you for keeping it precise.
It looks like ChatGPT took it to heart.
Me: You just said something incorrect.
ChatGPT: Thank you for keeping it precise.
May 5, 2025 at 3:28 AM
You know the advice to say "thank you" instead of "sorry"?
It looks like ChatGPT took it to heart.
Me: You just said something incorrect.
ChatGPT: Thank you for keeping it precise.
It looks like ChatGPT took it to heart.
Me: You just said something incorrect.
ChatGPT: Thank you for keeping it precise.
Preparing a presentation (this is a draft from early in the year, so probably preparing for Monster Scale). Looks like a mess, but IIRC, the result was actually good.
May 4, 2025 at 2:59 AM
Preparing a presentation (this is a draft from early in the year, so probably preparing for Monster Scale). Looks like a mess, but IIRC, the result was actually good.
Reposted by Gwen Shapira
PGConf.dev 2025 starts in 13 days.
Conference swag is starting to arrive in Montreal.
Are your travel plans set?
You can still register. https://2025.pgconf....
#Postgresql #PGCon##Postgresql
Conference swag is starting to arrive in Montreal.
Are your travel plans set?
You can still register. https://2025.pgconf....
#Postgresql #PGCon##Postgresql
May 1, 2025 at 1:04 PM
PGConf.dev 2025 starts in 13 days.
Conference swag is starting to arrive in Montreal.
Are your travel plans set?
You can still register. https://2025.pgconf....
#Postgresql #PGCon##Postgresql
Conference swag is starting to arrive in Montreal.
Are your travel plans set?
You can still register. https://2025.pgconf....
#Postgresql #PGCon##Postgresql
Reposted by Gwen Shapira
We have a new venue for PGConf NYC 2025 and a new hotel to go with it! Check it out and book now:
PGConf NYC 2025 | PostgreSQL Conference
PGConf NYC 2025 will be held from on September 29th - October 1st in New York City, NY at Convene 117 West 46th Street.
2025.pgconf.nyc
May 1, 2025 at 12:17 PM
We have a new venue for PGConf NYC 2025 and a new hotel to go with it! Check it out and book now:
Reposted by Gwen Shapira
Folks at Google: there's no longer a button to get the PDF of your research papers directly from your website. Instead you have to do a hop through Google Scholar. Is that intentional? Seems worse than it used to be before.
April 30, 2025 at 3:36 PM
Folks at Google: there's no longer a button to get the PDF of your research papers directly from your website. Instead you have to do a hop through Google Scholar. Is that intentional? Seems worse than it used to be before.
Running TPC-C can be a bit challenging.
Running pgbench is easy (it ships with Postgres and uses simple Postgres configs), but its main built-in script is TPC-B.
Thankfully, Ryo Kanbayashi wrote a pgbench script that is TPC-C-like: github.com/ryogrid/tpcc...
Running pgbench is easy (it ships with Postgres and uses simple Postgres configs), but its main built-in script is TPC-B.
Thankfully, Ryo Kanbayashi wrote a pgbench script that is TPC-C-like: github.com/ryogrid/tpcc...
GitHub - ryogrid/tpcc_like_with_pgbench: Simplified version of the TPC-C benchmark using pgbench custom scripts
Simplified version of the TPC-C benchmark using pgbench custom scripts - ryogrid/tpcc_like_with_pgbench
github.com
April 29, 2025 at 9:28 PM
Running TPC-C can be a bit challenging.
Running pgbench is easy (it ships with Postgres and uses simple Postgres configs), but its main built-in script is TPC-B.
Thankfully, Ryo Kanbayashi wrote a pgbench script that is TPC-C-like: github.com/ryogrid/tpcc...
Running pgbench is easy (it ships with Postgres and uses simple Postgres configs), but its main built-in script is TPC-B.
Thankfully, Ryo Kanbayashi wrote a pgbench script that is TPC-C-like: github.com/ryogrid/tpcc...
Serious question:
Why do so many developers hate stored procedures?
Why do so many developers hate stored procedures?
April 28, 2025 at 5:01 PM
Serious question:
Why do so many developers hate stored procedures?
Why do so many developers hate stored procedures?
Reposted by Gwen Shapira
⚡️ LAST DAYS for DataEngBytes 2025 Percolating tickets! After April 30th, prices increase from $449 to $499. Don't miss Oceania's premier data engineering & ML conference this July in Sydney & Melbourne! dataengbytes.com
April 28, 2025 at 1:22 AM
⚡️ LAST DAYS for DataEngBytes 2025 Percolating tickets! After April 30th, prices increase from $449 to $499. Don't miss Oceania's premier data engineering & ML conference this July in Sydney & Melbourne! dataengbytes.com
Reposted by Gwen Shapira
What great engineering looks like: invisible at most times… except when it matters.
Had no idea an iPhone would measure water presence on a charging port and warn for it. But it does!
Was at a pool and a few hours later when plugging it in got this helpful message.
Had no idea an iPhone would measure water presence on a charging port and warn for it. But it does!
Was at a pool and a few hours later when plugging it in got this helpful message.
April 21, 2025 at 11:39 PM
What great engineering looks like: invisible at most times… except when it matters.
Had no idea an iPhone would measure water presence on a charging port and warn for it. But it does!
Was at a pool and a few hours later when plugging it in got this helpful message.
Had no idea an iPhone would measure water presence on a charging port and warn for it. But it does!
Was at a pool and a few hours later when plugging it in got this helpful message.
Movie you’ve watched more than six times using gifs.
(“Hard mode” no Star Wars, Star Trek, or LOTR)
(“Hard mode” no Star Wars, Star Trek, or LOTR)
April 26, 2025 at 2:25 AM
Movie you’ve watched more than six times using gifs.
(“Hard mode” no Star Wars, Star Trek, or LOTR)
(“Hard mode” no Star Wars, Star Trek, or LOTR)