Top all-time · #2187
Loading...
Personal blog · michael.otacoo.comdataprogramming
Loading... is a personal blog at michael.otacoo.com about data and programming. Since 2012, 34 different Hacker News readers have linked it 44 times, most often “Postgres 9.3 feature highlight: JSON operators”. No feed was found, so read it on the site itself.
Too few sampled comments (13) to say how often HN recommends it.?
Why HN links it
HN readers link Michael Paquier's blog for its PostgreSQL release feature posts, such as 9.3, 9.5 and 9.6 walkthroughs. Commenters cite these posts as references for specific features like JSON, row-level security and parallel query.
- Recommended for · 2 comments
- Blog called 'a great source'; one commenter recommends reading the row-level security post.
Summarised by Claude from a sample of 13 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Most-linked posts?
- Postgres 9.3 feature highlight: JSON operators4 people · 4 mentions · first linked 2013-04-14
- Postgres 9.6 feature highlight: Multiple synchronous standbys3 people · 3 mentions · first linked 2016-04-14
- Postgres 9.5 feature highlight: row-level security and policies2 people · 2 mentions · first linked 2014-10-03
- Postgres 9.5 feature: Foreign Tables now part of Inheritance Trees2 people · 2 mentions · first linked 2015-03-27
- Postgres 9.3 feature highlight: Materialized views2 people · 2 mentions · first linked 2013-04-08
What Hacker News says?
Love the way they are heading with the JSON stuff http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-...
Comment linking /postgresql-2/postgres-9-3-feature-highlight-json-operators/
on “Postgresql 9.3 Released”Submitted Postgres 9.4 feature highlight: Indexing JSON data with jsonb data type as a story · 200 points
HN discussionThis is how you do it in 9.2 using PLV8. http://people.planetpostgresql.org/andrew/index.php?/archive... For 9.3, see more info at http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-...
Comment linking /postgresql-2/postgres-9-3-feature-highlight-json-operators/
on “Hstore development for 9.4 release”Submitted Postgres 9.5 feature highlight: row-level security and policies as a story · 153 points
HN discussionOne can hope that this will get fixed over time. 9.4 introduced some flexibility over streaming out data changes from the Write Ahead Log, from [1]: > Add support for logical decoding of WAL data, to allow database changes to be streamed out in a customizable format. Also 9.5 added new metadata to it [2]: > Each WAL record now carries information about the modified relation and (s) in a standardized format. That mak…
Comment linking /postgresql-2/postgres-9-5-feature-highlight-new-wal-format/
on “No More Full Table Vacuums in PostgreSQL”Submitted Postgres 9.3 feature highlight: JSON operators as a story · 86 points
HN discussion> Index scans imply extra disk seeks to fetch the index. This is no longer true in this generality, because since PostgreSQL 9.2 there are also index-only scans. Those scans take the data directly from the index, without going through the original rows at all. Of course, this works only under certain conditions. See also: http://michael.otacoo.com/postgresql-2/postgresql-9-2-highli... http://www.postgresql.org/docs/…
Comment linking /postgresql-2/postgresql-9-2-highlight-index-only-scans/
on “PostgreSQL Indexes: First principles”Submitted Postgres 9.2 highlight: JSON data type as a story · 73 points
HN discussionGood news! It's slated for the next release. :) http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-...
Comment linking /postgresql-2/postgres-9-3-feature-highlight-materialized-views/
on “Top Reasons I like Postgres Over SQL Server”Submitted Postgres 9.5 feature highlight: Import Foreign Schema as a story · 64 points
HN discussionWell something not mentioned in this article is the that 9.5 should also introduce inheritance from/to Foreign Tables which is one step closer to nice and easy horizontal scaling. Found this detailed example : http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-... Maybe thats not a No-SQL trendy way of doing things, but for I am more used to PostgreSQL this look pretty neat. I think as the old and reliable…
Comment linking /postgresql-2/postgres-9-5-feature-foreign-table-inheritance/
on ““Big data” features coming in PostgreSQL 9.5”Submitted Postgres 9.3 feature highlight: Materialized views as a story · 12 points
HN discussionHere's a blog post about it: http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-...
Comment linking /postgresql-2/postgres-9-3-feature-highlight-watch-in-psql/
on “PostgreSQL 9.3 Beta 1 Released”Submitted Postgres 9.5 feature highlight: BRIN indexes as a story · 8 points
HN discussionParallel query will probably win for sexiest new feature ( rightfully so! ) but remote apply is very useful in the real world. It will greatly simplify reading newly written data off replicas: http://michael.otacoo.com/postgresql-2/postgres-9-6-feature-...
Comment linking /postgresql-2/postgres-9-6-feature-highlight-remote-apply/
on “PostgreSQL 9.6 Beta 1 Released”Submitted Postgres 9.3 feature highlight: JSON data generation as a story · 7 points
HN discussionAgreed, despez is a great source as is Michael Paquier's blog ( http://michael.otacoo.com/ ). The goal here was to boil it up a bit more to the practical uses and benefits versus the technical details of it. Further there was a talk at FOSDEM just yesterday which highlighted much of whats committed in 9.4, though slides aren't online yet.
Comment linking /
on “Examining PostgreSQL 9.4 – A first look”Submitted Postgres 9.3 feature highlight: custom background workers as a story · 7 points
HN discussionINSERT ON CONFLICT and Row Level Security are awesome new additions. If you don't know about RLS I recommend you read up on them[1], as they would allow you to handle select/update/delete rights on rows directly on the data itself. [1] http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-...
Comment linking /postgresql-2/postgres-9-5-feature-highlight-row-level-security/
on “PostgreSQL 9.5 New Features with Examples [pdf]”Submitted Postgres 9.6 feature highlight: Multiple synchronous standbys as a story · 6 points
HN discussionBetter to wait for postgresql 9.6 which will have synchronous replication, write latency but not read. http://michael.otacoo.com/postgresql-2/postgres-9-6-feature-...
Comment linking /postgresql-2/postgres-9-6-feature-highlight-multi-sync-rep/
on “Master-Less Distributed Queue with PG Paxos”Submitted Postgres 9.2 highlight: range types as a story · 6 points
HN discussionApologies - I was thinking of ALTER SYSTEM [1]. That writes to postgresql.auto.conf. It sounds like that file has priority over postgresql.conf [2]. You might well be able to just prevent writes by the postgres user (or whatever user you're running postgres as). Regarding superusers overwriting files - COPY can write to anywhere on the filesystem. From the docs "COPY naming a file is only allowed to database superus…
Comment linking /postgresql-2/postgres-9-4-feature-highlight-alter-system-set-for-dynamic-configuration/
on “Show HN: Database Labs – Postgres as a Service”Submitted Postgres 9.5 feature highlight: New WAL format as a story · 4 points
HN discussionwhile there are a lot of different improvements, i'm really looking forward to the enhanced JSON functionalities (particularly the new operators [0]) and the LATERAL JOIN [1] [0] http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-... [1] http://www.postgresql.org/docs/9.3/static/queries-table-expr...
Comment linking /postgresql-2/postgres-9-3-feature-highlight-json-operators/
on “PostgreSQL 9.3 RC1 Available for Testing”Submitted Postgres 9.3 feature highlight: IF EXISTS and IF NOT EXISTS as a story · 4 points
HN discussionSubmitted Postgres 9.5: New JSONB functions and operators as a story · 3 points
HN discussionSubmitted Manipulating JSONB data in Postgres 9.4 by abusing key uniqueness as a story · 3 points
HN discussionSubmitted Postgres 9.3 feature highlight: Data Checksums as a story · 3 points
HN discussionSubmitted Postgres 9.3 feature highlight: JSON parsing functions as a story · 3 points
HN discussion
