recentpopularlog in

mcherm : postgresql   14

tax deductable donations to software projects
Some open source projects (like LibreOffice or PostgreSQL) can be donated to in a tax-deductible fashion through this non-profit.
libreoffice  opensource  taxes  postgresql 
february 2018 by mcherm
Robert Haas: The State of VACUUM
About VACUUM in PostgreSQL. How it has come a long way and a few ways in which it can still be improved.
database  postgresql  programming  via:HackerNews 
january 2018 by mcherm
What it means to be a Postgres extension
They had a fork of PostgreSQL, but because of really good internal hooks, they were able to make it into an extension instead. Far less work to maintain, and easier for users to utilize.
postgresql  programming  via:HackerNews 
november 2017 by mcherm
RethinkDB versus PostgreSQL: my personal experience › SageMathCloud Blog
He used RethinkDB seriously for several years, then migrated his app over to PostgreSQL. He gives a detailed recounting of how it went, but the punchline is PostgreSQL is awesome.
database  postgresql  programming  via:HackerNews 
february 2017 by mcherm
How Twitch Uses PostgreSQL
Some PostgreSQL architecture and performance choices made by Twitch.
postgresql  database  performance  architecture  via:HackerNews 
october 2016 by mcherm
Debugging PostgreSQL performance, the hard way · JustWatch Tech Blog
A really well-written article describing how this person went about debugging a PostreSQL performance issue. I'd also like to note that this may be the best article I have EVER read on how to actually manage a production database.
database  postgresql  performance  debugging  via:HackerNews 
september 2016 by mcherm
PostgreSQL: Documentation: 9.5: Comparison of Different Solutions
A table of different ways to provide replication, listing pros and cons of each. Not specific to PostgreSQL, but does comment on how to achieve each in that DB.
database  postgresql 
september 2016 by mcherm
When To Avoid JSONB In A PostgreSQL Schema | Heap Blog
Some reasons why a native JSON datatype does NOT optimize for database performance: it can't track the statistics that the smart database uses to optimize query plans, and the flexibility causes it to use more space for storage.
postgresql  database  performance  via:HackerNews 
september 2016 by mcherm
Re: Why we lost Uber as a user
The attitude here is admirable: they admit the problem.
database  postgresql  via:HackerNews 
august 2016 by mcherm
Creating user with encrypted password in PostgreSQL - Stack Overflow
How to create a user without putting their password into the files.
research  postgresql 
may 2016 by mcherm
Robert Haas: No More Full-Table Vacuums
For many sorts of databases (including ones we often use) PostgreSQL just got better. No need to touch every single page in the DB occasionally for vacuuming.
PostgreSQL  database  via:HackerNews 
march 2016 by mcherm
How Postgres and Open Source Are Disrupting The Market for Database Management Systems - Forbes
Even Forbes recognizes that PostgreSQL is now an "enterprise-ready" database as well as being open source.
postgresql  opensource  via:reddit 
march 2016 by mcherm
Postgres for the win! » Enfranchised Mind
A user who is very impressed with PostgreSQL's performance, particularly for extremely large tables.
database  performance  postgresql 
june 2008 by mcherm

Copy this bookmark:

to read