sixfortwo.com
Six For Two: Just A Quick One (While He's Away)
http://www.sixfortwo.com/2015/09/just-quick-one-while-hes-away.html
They say six of one and half a dozen of the other. Not here. It's Six for Two, and Two for nothing! And Six for free for all, for free-for-all! Saturday, September 12, 2015. Just A Quick One (While He's Away). Today's post will be about relational databases. Are you familiar with the PostgreSQL history file? Have you ever wondered about its contents? I have a few goals in mind for this weekend (wait, it's Saturday afternoon already? Well, you know, the rest of this weekend):. For my upcoming talk. More s...
momjian.us
Bruce Momjian: Postgres Events
http://momjian.us/main/events/2015.html
December 15, 2015. Philly PostgreSQL User Group. December 10, 2015. St Louis, Missouri. St Louis Postgres User Group. November 19, 2015. November 17-18, 2015. San Francisco, California. November 16, 2015. Seattle Postgres User Group. November 3, 2015. November 2-3, 2015. October 31, 2015. PG-EU 2015 Cluster Summit. October 27-30, 2015. PostgreSQL Conference Europe 2015. Christine and Peter attended. October 23, 2015. Christine and Peter attended, video. October 14, 2015. Philly PostgreSQL User Group.
sixfortwo.com
Six For Two: Where We Came In
http://www.sixfortwo.com/2015/08/where-we-came-in.html
They say six of one and half a dozen of the other. Not here. It's Six for Two, and Two for nothing! And Six for free for all, for free-for-all! Saturday, August 22, 2015. Where We Came In. 9775; To begin is everything. Without beginning, without ever hitting "Publish", this blog is just unfinished drafts staring at me and only me. Taunting me :- I love my words, but I cringe at my writing, so things just sit. Still, I can be cromulent, so I will write briefly (yeah right! Before I further digress, let me...
keithf4.com
pg_partman at Keith's Ramblings…
https://www.keithf4.com/tag/pg_partman
Keith's Ramblings…. WARNING: If accidentally read, induce vomiting. Archive for the ‘pg partman’ tag. PG Partition Manager v2.0.0 – Background Worker, Better Triggers & Extension Versioning Woes. PostgreSQL 9.3 introduced the ability for user created, programmable background workers. Pg partman bgw.dbname. Required. The database(s) that `run maintenance()` will run on. If more than one, use a comma separated list. If not set, BGW will do nothing. Pg partman bgw.interval. Pg partman bgw.role. The BGW is c...
keithf4.com
extensions at Keith's Ramblings…
https://www.keithf4.com/tag/extensions
Keith's Ramblings…. WARNING: If accidentally read, induce vomiting. Archive for the ‘extensions’ tag. Document Storage in PostgreSQL & Open Source Benefits. Since this blog post, I’ve recently gone back and updated pg doc store to take advantage of the new INSERT ON CONFLICT (upsert) feature in 9.5. So the extension is much more ready for possible production use if anyone finds it useful. Possible episode 7 spoiler alert) . So I forked the repo and did the work. I submitted it back as a push request,...
keithf4.com
PG Partition Manager v2.0.0 – Background Worker, Better Triggers & Extension Versioning Woes at Keith's Ramblings…
https://www.keithf4.com/pg-partition-manager-v2-0-0
Keith's Ramblings…. WARNING: If accidentally read, induce vomiting. PG Partition Manager v2.0.0 – Background Worker, Better Triggers & Extension Versioning Woes. Has been the most popular project I’ve ever done a significant amount of work on and I really appreciate everyone’s feedback for the roughly 2 years it’s been out there. I’ve got plenty more ideas for development and features and look forward to being able to move forward on them with this new major version released. Pg partman bgw.dbname. The B...
keithf4.com
partitioning at Keith's Ramblings…
https://www.keithf4.com/tag/partitioning
Keith's Ramblings…. WARNING: If accidentally read, induce vomiting. Archive for the ‘partitioning’ tag. Document Storage in PostgreSQL & Open Source Benefits. Since this blog post, I’ve recently gone back and updated pg doc store to take advantage of the new INSERT ON CONFLICT (upsert) feature in 9.5. So the extension is much more ready for possible production use if anyone finds it useful. Possible episode 7 spoiler alert) . So I forked the repo and did the work. I submitted it back as a push reques...
keithf4.com
PostgreSQL at Keith's Ramblings…
https://www.keithf4.com/category/postgresql-stuff
Keith's Ramblings…. WARNING: If accidentally read, induce vomiting. Archive for the ‘PostgreSQL’ Category. Cleaning Up PostgreSQL Bloat. As a followup to my previous post on checking for bloat. I figured I’d share some methods for actually cleaning up bloat once you find it. I’ll also be providing some updates on the script I wrote due to issues I encountered and thanks to user feedback from people that have used it already. The easiest, but most intrusive, bloat removal method is to just run a VACUUM.
databasesoup.com
Database Soup: Texas Trip: DjangoCon and Postgres Open
http://www.databasesoup.com/2015/07/texas-trip-djangocon-and-postgres-open.html
Thursday, July 30, 2015. Texas Trip: DjangoCon and Postgres Open. This September, I will be having a great Texas adventure, and you're invited along. September 8-10, Austin:. I will be presenting " PostgreSQL Performance in 15 Minutes. September 9th or 10th, Austin. I will speak at AustinPUG. Date, location and exact topic still TBA. Follow the AustinPUG Meetup. Or check back here in a week for an update. September 16-18, Dallas. I will be doing my Replication 101. Tutorial, and then Explaining Explain.
databasesoup.com
Database Soup: July 2015
http://www.databasesoup.com/2015_07_01_archive.html
Thursday, July 30, 2015. Texas Trip: DjangoCon and Postgres Open. This September, I will be having a great Texas adventure, and you're invited along. September 8-10, Austin:. I will be presenting " PostgreSQL Performance in 15 Minutes. September 9th or 10th, Austin. I will speak at AustinPUG. Date, location and exact topic still TBA. Follow the AustinPUG Meetup. Or check back here in a week for an update. September 16-18, Dallas. I will be doing my Replication 101. Tutorial, and then Explaining Explain.
SOCIAL ENGAGEMENT