3manuek

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.

3manuek

12 mesi fadiscuss

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!

3manuek

2 anni fadiscuss

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.

3manuek

10 anni fadiscuss

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.

3manuek

10 anni fadiscuss

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

3manuek

10 anni fadiscuss

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.

Submissions

Upgrading Postgres Major, and Django Model with Logical Replication

[untitled]

Earthly feature: disabling internal labels

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

Sampling considerations on Clickhouse distributed tables

Importing data from Redshift into Clickhouse

Analyzing postgres_fdw overhead

Postgres sharding using postgres_fdw Foreign Data Wrapper Extension

Basic Apache Kafka and Postgres integration using kafkacat

Highlighting Postgres 10 Upcoming Features:Logical Replication and Partitioning

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

comments