ants_a

8 ms·

31.
by ants_a 3y ago
For well scaling workloads optimizing for efficiency is optimizing for performance. For serial workloads even one P-core is enough. There aren't too many workloads in the middle that scale but only to a few cores.
32.
by ants_a 3y ago
Networking doesn't have to have high latency. You can buy network hardware that is able to provide sub-microsecond latency. Physical distance still matters, but 10% of typical NVMe latency gets you through a kilometer of fiber.
33.
by ants_a 3y ago
Nice, I hacked together something similar many moons ago, it looks like some fine folks have kept on maintaining and improving it: https://github.com/fschulze/sqlalchemy_schemadisplay Useful to have in a CICD pipeline
34.
by ants_a 3y ago
Is there a reason why this is implemented in Rust instead of plpgsql? At first glance I didn't see it using any features that would need a loadable extension. Plain SQL based solution would make using it on managed database services mu
35.
by ants_a 3y ago
The unexpected part for me was not the lack of temporal locality, but which cache it thrashed. The whole dataset fits into buffer cache so one might think that the lack of locality is not that important...
36.
by ants_a 3y ago
B-trees index random UUIDs perfectly fine, it's just that range scans over the resulting indexes cause random access patterns that interact really poorly with caches when data size exceeds cache size. The blog was about an interesting
37.
by ants_a 3y ago
I agree, though it's not the uniqueness, but not null constraint that matters here. PostgreSQL could, but doesn't right now, use the not null constraint to optimize the former to the latter. The actual case came to my attention be
38.
by ants_a 3y ago
Those global variables would be converted to thread locals and most of the code would be oblivious of the change. This is not the hard part of the change.
39.
by ants_a 3y ago
As a counterpoint: https://brandur.org/text
40.
by ants_a 3y ago
Why is revoking permissions to run deletes/updates not an option?
41.
by ants_a 3y ago
There is the pg_hint_plan extension that gives most of what you would want in a hinting system. I think a better fix lies in the direction of making queries more of a first class object with options to nail down plans, add custom logic to p
42.
by ants_a 4y ago
All of the cheap tabletop cooktop I have seen have terrible cycling at lower powers, there seems to be two power levels and when you need something below the lower one, it cycles power at ~10s frequency. In contrast a Bosch integrated cookt
43.
by ants_a 4y ago
With most cookware it's pretty obvious where the coils are when trying to simmer. With thinner stuff like carbon steel the hot spots can be pretty nasty: https://www.youtube.com/watch?v=pifD__DIxGU
44.
by ants_a 4y ago
Setup credentials for an S3-compatible bucket and you will have backups + point-in-time-recovery capability. For restores there are a few different options. If you just flat out delete the persistent volumes you will get an automatic restor
45.
by ants_a 4y ago
Simpler fix is to upgrade to fixed version and reindex concurrently any indexes that could have been affected.
46.
by ants_a 4y ago
That's the availability part. If a system is unable to make progress it is not available.
47.
by ants_a 5y ago
My experience is that the problem with producing business software is not the lack of programming knowledge. Rather it's a lack of people who understand the business and are capable of abstract thought and formalizing processes. I don&
48.
by ants_a 5y ago
A normal vacuum will also defragment page contents, see PageRepairFragmentation()[1], which is called during normal vacuum from lazy_vacuum_page(). [1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f...
49.
by ants_a 5y ago
In PostgreSQL you would group by date_trunc('month', transaction_date)
50.
by ants_a 5y ago
Or alternatively, toss in a network interface and have drives PXE boot an application specific firmware and spin up a ceph-osd or similar server.
51.
by ants_a 5y ago
EU is already trading CO2 at 60€/t.
52.
by ants_a 5y ago
They were behind for a few years in the beginning of 2000's in the P3 - Core 2 era.
53.
by ants_a 5y ago
Something does not compute. $1000 should be getting them ballpark 10'000 kWh of power. That is 14 kW of constant power use. Typical largest residential GSHP over here is 15-18 kW of heating at 4 kW compressor power. (usually COP in ran
54.
by ants_a 5y ago
The optimization engine is of course great (despite occasionally missing hard), but I am not referring to it. I am referring to the way that PostgreSQL executes query plans, the way rows are pulled up the execution tree, is very similar to
55.
by ants_a 5y ago
From my experience of benchmarking these databases on scientific data (highly regular timeseries) and looking at the internals of both, these kinds types of number happen when answering the query needs crunching through many rows, but the o
56.
by ants_a 5y ago
There is a specification for updating charging cable firmware.
57.
by ants_a 5y ago
There are plenty of thin laptops with USB-A ports. Thinkpad X1 is both thinner than a macbook and has two USB-A ports. And there are laptops just 2mm thicker than a Macbook Air that have ethernet via some clever mechanical engineering.
58.
by ants_a 5y ago
Postgres has much more featureful query language, and at tens of thousands of rows the performance difference is irrelevant. The story becomes different when answering a query has to touch millions of records and the answer is needed in mil
59.
by ants_a 5y ago
The comparison to a turbo got me thinking if some of the compression energy could be recovered in the expansion stage. Turns out the answer is yes, but the energy recovery is limited to 7% at best: https://www.sciencedirect.com&#
60.
by ants_a 5y ago
Small kids generate tons of such fleeting moments and also need good autofocus and fast shutter speeds.

More ›