kroolik

7 ms·

31.
by kroolik 2y ago
Make sure to create indices AFTER the data is in. Its way faster to create indices from data than create them empty and insert data. Also make sure to set maintenance_work_mem high as it helps with index creation
32.
by kroolik 2y ago
If im not mistake, you can do this with no downtime by creating a regular index CONCURRENTLY and creating a not checked unique constraint. The constraint applies to new insert/updates only. After that, you run VALIDATE on the constrain
33.
by kroolik 2y ago
It also makes all new readers/writers to wait for that lock, essentially leading to downtime until the lock is eventually acquired and released. This is the classic readers/writers library example, and you want to avoid starving t
34.
by kroolik 2y ago
For me the best way is testing it locally, side-by-side, with two transactions. You dont need any data for this. After some experience, you start to see the reasons for locks and how they will impact you. Or read the docs.
35.
by kroolik 2y ago
'statement_timeout' includes lock timeout and lets you better estimate the impact on hot tables. When you set the timeout to 5s, you know the downtime will be max 5s total, and transactions will continue afterwards. With lock time
36.
by kroolik 3y ago
Oh thanks! Always thought it was what EFS was for. They are still limited to the same AZ, so no multi AZ redundancy.
37.
by kroolik 3y ago
I could be missing something, but I can't really wrap my head around "unlimited paralelism". What they say is that the logic is embedded into their server binary and they write to a local EBS. But what happens when they have
38.
by kroolik 3y ago
Although its great the library helps with multicore Python, the existence of such package shouldnt be an excuse not to improve the state of things in std python
39.
by kroolik 3y ago
Managing processes is more annoying than threads, though. Incl. data passing and so forth.
40.
by kroolik 3y ago
You are right. Awareness doesn't imply immunity. I still believe a lot of people are simply unaware of the deceit, making the problem bigger (or more saddening)
41.
by kroolik 3y ago
> we're all fully aware of that deceit I wouldnt go as far to make this claim, as I believe more people than not fall victim of this deceit daily. See social medias.
42.
by kroolik 3y ago
When thinking about solving a problem one of questions to be asked is whether you want a challenge or a solution. Engineers, on average, want to be challenge, which impacts options chosen. There may also have been other factors, not mention
43.
by kroolik 3y ago
What if the meeting is between people in EU and USA, where DST transitions occur at different moments?
44.
by kroolik 3y ago
Age has to be updated annually, whilst date of birth only when the user changes it.
45.
by kroolik 3y ago
The article describes fake trees thus Fake in the title, yes. The article also asks the question you quote, true. But it also goes on with multiple examples that support their approach whilst neglecting storing data as real tree ("That
46.
by kroolik 3y ago
Agree. The article is imho clickbaity and very shallow in the reasoning presented.
47.
by kroolik 3y ago
The idea behind the article is simple - use the structures fit for the problem. The narrative, though, is imho faulty. You dont need CTE to retrieve the tree from the db - you can fetch a flat list and construct the tree locally, as you wou
48.
by kroolik 3y ago
Its only in the conclusion, though.
49.
by kroolik 3y ago
Trolling, as it may make children not trust your words if what you say is consistently a lie/joke. The children may be also laughed at by their colleagues if they repeat your words at kindergarden/early school.
50.
by kroolik 3y ago
I find the explanation of logical and physical replication to be weird. Seems like only logical replication transfers changes. I have always thought physical replication is replicating using WAL logs, which is a stream of changes. The logic
51.
by kroolik 3y ago
True, generic test-and-set ops can be used. But what about if there is already a request in-flight? Do you wait or fail? What is the experience working with either? What is the experience invalidation the cache key? And similar other questi
52.
by kroolik 3y ago
Come here to learn more details and maybe find answers to my questions. Unfortunately, the article is very modest explaining how to work with idempotency. Missing key answers like what about two requests in flight, how to store and query re
53.
by kroolik 3y ago
One annoying part with multiprocessing in Python is that you could abuse the COW mechanism to save on loading time when forking. But Python stores ref counters together with objects so every single read will bust your COW cache. Now, you wa
54.
by kroolik 3y ago
Troubleshooting inside the container or simple scripting.
55.
by kroolik 3y ago
Apparently, not. Side note, kubectl also has this feature with similar convention wrt binary name pattern.
56.
by kroolik 3y ago
Git will translate any call in the likes of `git foo bar baz` to a call to a binary `git-foo bar baz`. See https://stackoverflow.com/questions/10978257/extending-git-f... .
57.
by kroolik 4y ago
Its indeed interesting future ahead of us, curious what will come out of it.
58.
by kroolik 4y ago
I guess time will really tell. We might as well hit the problem Google Translate hit, where the training set started to contain more and more data created from GT itself. Similar thing may happen with your NN. At some point there may be so
59.
by kroolik 4y ago
> NOW they will have to learn that if something is out of the ordinary I once shared this approach, but learned that the majority of people don't really want to leave their echo chambers and gladly accept anything that amplifies it.
60.
by kroolik 4y ago
I thought about this a bit, and am wondering about the results of LLM-fueled arms-race when it comes to figuring out whether an AI has created some piece of text. I'm worried we may reach a point AI will get so good faking people that

More ›