Hacker News: 3manuek

New comment by 3manuek in "Pgbackrest is no longer being maintained"

3manuek — Mon, 27 Apr 2026 16:46:33 +0000

The "closest" would be using Barman with hook scripts (https://docs.pgbarman.org/release/3.18.0/user_guide/hook_scr...) if you rely on cloud storage for storing backups.

https://github.com/aiven-open/pghoard seems like a good option too, but I haven’t tested it yet to have a solid opinion.

Upgrading Postgres Major, and Django Model with Logical Replication

3manuek — Sat, 15 Nov 2025 19:22:58 +0000

Article URL: https://tr3s.ma/posts/2025-11/pgmajorupgradedjango/

Comments URL: https://news.ycombinator.com/item?id=45939891

Points: 2

# Comments: 0

New comment by 3manuek in "AI Is Forcing the Return of the In-Person Job Interview"

3manuek — Thu, 14 Aug 2025 09:10:34 +0000

I'm more into remote positions, built a very decent setup at home. However, I like the idea about traveling for offsites or office work, it is great for touching grass time to time, make good connections and know your team faces.

BTW, good luck on the interviews!

New comment by 3manuek in "Panic at the Job Market"

3manuek — Thu, 18 Jul 2024 11:32:36 +0000

I'm on this that technical interviews aren't broken (at least the ones I did during the past 2 years or so), what is broken are the job specs. They may have turned _picky_, but okish.

Earthly feature: disabling internal labels

3manuek — Fri, 05 Jul 2024 11:14:17 +0000

Article URL: https://tr3s.ma/posts/2024-07/nolabelsearthlyfeature/

Comments URL: https://news.ycombinator.com/item?id=40881772

Points: 1

# Comments: 0

GCP's iLB/TCP with HTTP Health Checks in Terraform for Stateful Services

3manuek — Thu, 31 Jan 2019 01:20:56 +0000

Article URL: http://www.3manuek.com/terraformgcpilb

Comments URL: https://news.ycombinator.com/item?id=19041378

Points: 1

# Comments: 0

Sampling considerations on Clickhouse distributed tables

3manuek — Wed, 05 Jul 2017 18:27:26 +0000

Article URL: http://www.3manuek.com/clickhousesample

Comments URL: https://news.ycombinator.com/item?id=14704954

Points: 1

# Comments: 0

Importing data from Redshift into Clickhouse

3manuek — Wed, 05 Jul 2017 15:16:05 +0000

Article URL: http://www.3manuek.com/redshiftclickhouse

Comments URL: https://news.ycombinator.com/item?id=14703044

Points: 1

# Comments: 0

Analyzing postgres_fdw overhead

3manuek — Tue, 07 Mar 2017 00:57:38 +0000

Article URL: http://www.3manuek.com/fdwoverhead

Comments URL: https://news.ycombinator.com/item?id=13807506

Points: 1

# Comments: 0

Postgres sharding using postgres_fdw Foreign Data Wrapper Extension

3manuek — Mon, 06 Mar 2017 00:41:57 +0000

Article URL: http://www.3manuek.com/postgresmanualsharding

Comments URL: https://news.ycombinator.com/item?id=13799891

Points: 2

# Comments: 0

Basic Apache Kafka and Postgres integration using kafkacat

3manuek — Wed, 01 Mar 2017 13:45:39 +0000

Article URL: http://www.3manuek.com/kafkacatandcopypg

Comments URL: https://news.ycombinator.com/item?id=13763565

Points: 1

# Comments: 0

Highlighting Postgres 10 Upcoming Features:Logical Replication and Partitioning

3manuek — Fri, 24 Feb 2017 18:26:11 +0000

Article URL: http://www.3manuek.com/postgres10logrepypart

Comments URL: https://news.ycombinator.com/item?id=13726211

Points: 2

# Comments: 0

New comment by 3manuek in "Unsecured MongoDBs taken hostage"

3manuek — Wed, 04 Jan 2017 13:40:25 +0000

Worst thing is that the data loss impact in money is not limited to the blackmail rates. What I'm saying is that even if everyone pays and 4kBTC (4.3M USD today) is collected by the perpetrator, there are other impacts in terms of legal issues and insurance. I don't know how to calculate this, but it could be an interesting number tho.

New comment by 3manuek in "Show HN: ToroDB Stampede: Automagical MongoDB to PostgreSQL, 100x Faster Queries"

3manuek — Wed, 30 Nov 2016 17:36:05 +0000

Impressive performance, even compared against a Mongo shard with 3 nodes!

PostgreSQL RDS pg-stat-ramdisk-size new feature and its calculations

3manuek — Mon, 26 Sep 2016 01:16:02 +0000

Article URL: http://www.3manuek.com/pgstatramdisksize

Comments URL: https://news.ycombinator.com/item?id=12578514

Points: 2

# Comments: 0

New comment by 3manuek in "Thoughts on Uber’s List of Postgres Limitations"

3manuek — Wed, 03 Aug 2016 12:54:07 +0000

I do think that you need to learn how to use in the best way the technologies you have chosen or that are present in your current setup. No matter if it is a MySQL, Postgres or any other DB, it requires as a part of a job, learn how to use at it's best. The points on the article are good, however it's true that Postgres had problems with scalability not so long ago. That's changing, however I think that other data stores have addressed the problem of availability and scalability earlier and gained maturity during the last years.

Also, there is something that caused some noise to me:

    This point is correct; PostgreSQL indexes currently use a
    direct pointer between the index entry and the heap tuple 
    version. InnoDB secondary indexes are “indirect indexes” 
    in that they do not refer to the heap tuple version 
    directly, they contain the value of the Primary Key (PK) 
    of the tuple.

That's true, but the article doesn't make explicit that the PK on InnoDB is a clustered index and, that there are other optimizations like adaptive hashing to make read queries faster.