ahachete

11 ms·

91.
by ahachete 4y ago
Check DOMAINs. They are derived data types that take a base type and add, optionally, one or more CHECK constraints to them. They are not perfect, but probably something close to what you are looking for.
92.
by ahachete 4y ago
Sharding databases is not such a dark, magic art. Citus relies on Postgres for many key features; and Citus does the rest. It's already quite "feature complete". If Citus would become proprietary overnight, my main concerns o
93.
by ahachete 4y ago
Maybe... but there are many queries that don't use an index (whether fast or slow) and that's the right thing to do . As a DBA, I'd see too many "false positives" due to this reason.
94.
by ahachete 4y ago
Right, those are compulsory steps for every upgrade. Yet in the particular case of Citus, history (so far) has shown a) that they update the extension regularly and fast, so by the time you want to upgrade to a newer major version you alrea
95.
by ahachete 4y ago
Many of those queries may run sub-second (typical lower-end value for log_min_duration_statement), so they won't get logged. Yet, if called at high frequency, may represent a notable % of your CPU and I/O. The slow query log is no
96.
by ahachete 4y ago
> 2) Horizontal scalability without having to resort to an extension like Citus. Just curious, what would save you having the solution in-core? Installation, sure, but that's a one-off possibly in your deployment code. "CREATE
97.
by ahachete 4y ago
> Elastic license doesn't impose restrictions. It does. It explicitly forbids usage. FOSS doesn't impose any restrictions on usage. Fundamentally different things. I encourage you to review the four freedoms of Free Software [1
98.
by ahachete 4y ago
"quite permissive" and "open source" are terms quite far apart. Open Source software provides certain clear guarantees to the users of that software. Even small changes to these guarantees probably render the software no
99.
by ahachete 4y ago
I agree with your sentiment, but I'd like to clarify the following, IMO: > It's a different restriction. AGPL doesn't impose restrictions. It provides guarantees (that modified versions will remain AGPL and therefore open
100.
by ahachete 4y ago
Wait until the emulator can run a modern kernel with eBPF support. Then use eBPF to intercept the SSL calls pre encryption, push via a map the requests to userspace, and then translate them to HTTP as you wish. Simple! ;P
101.
by ahachete 4y ago
But something that is variable in time cannot be "consistent" by definition ;) Great to know this is known. My recommendation still holds: publish results with GP3: whatever others do (potentially, wrong) shouldn't prevent yo
102.
by ahachete 4y ago
That's an assumption. My #1 rule for a benchmark is that it should have reproducible results. Using variable-performance storage goes directly against reproducible results. On a related topic: an OLAP benchmark with a small dataset tha
103.
by ahachete 4y ago
I'm a deep Postgres person and I'm very interested in the project. Congratulations and welcome as a new open source project to the ecosystem. One important recommendation: please do not run benchmarks on variable-performance stora
104.
by ahachete 4y ago
> The legal advice to be skeptical of the AGPL is absolutely right. The legal risk involved by using AGPL software for a company is exactly zero. AGPL is an open source license which, by the very definition of open source, means that y
105.
by ahachete 4y ago
In case you are interested, I blogged about it last year: https://thenewstack.io/kubernetes-will-revolutionize-enterpr... TL;DR performance impact should be negligible, could be even slightly negative compared to a VM (when
106.
by ahachete 4y ago
Light travels much slower (~1.5x slower) on a fiber optic, due to the refractive index (~ 1.5) of the fiber.
107.
by ahachete 4y ago
This is a fantastic idea, truly innovating what you can do with Postgres. Kudos! Postgres, possibly surprising to many, is very "simple": it has essentially no dependencies other than a few OS system calls (open, read, write files
108.
Pg-agent: a Prometheus Postgres exporter focused on query performance statistics(coroot.com)
16 points by ahachete 4y ago|0 comments
109.
by ahachete 4y ago
Shameless plug (StackGres team member here) but StackGres possibly has the largest selection of ready-to-use Postgres extensions [1]. Give it a quick try on any Kubernetes cluster, like k3s on your laptop (one command install), and install
110.
by ahachete 4y ago
If building a list of alternatives, let me do a shameless plug for StackGres [1], the Postgres platform for Kubernetes with a fully featured Web Console, AMD64 and ARM64 support and more than a hundred available Postgres extensions [2]. Ful
111.
by ahachete 4y ago
I agree. If the extension availability is the main concern, I'd recommend the open source StackGres [1] operator, which has, possibly, the largest Postgres extension catalog [2] available. [1] https://stackgres.io [2] http
112.
by ahachete 4y ago
> I didn't say it was an 'announcement of an announcement' just that this But it appears you didn't consider the following part of my comment, where I explained that a) I didn't have any way to know there would
113.
by ahachete 4y ago
I don't see this an "announcement of an announcement", as there's concrete and detailed content about the announcement itself. You can read the commit message and even the source code. Moreover, I'm not affiliated w
114.
by ahachete 4y ago
I submitted the news, sorry if I spoiled the announcement! ;) But as soon as I received the news, and these are definitely good news, I wanted to share it with the HN crowd :) BTW, is item #8 (or any other, for that matter) an alternative t
115.
Make enterprise features open source(github.com)
431 points by ahachete 4y ago|69 comments
116.
JEP 419: Foreign Function and Memory API(openjdk.java.net)
95 points by ahachete 5y ago|62 comments
117.
by ahachete 5y ago
Does it support migrations that affect more than one table?
118.
Behind the scenes: How we built Rewind(planetscale.com)
1 points by ahachete 5y ago|0 comments
119.
I tested four NVMe SSDs from four vendors – half lose FLUSH’d data on power loss(twitter.com)
797 points by ahachete 5y ago|397 comments
120.
Explain (ANALYZE) needs BUFFERS to improve the Postgres query optimization(postgres.ai)
3 points by ahachete 5y ago|0 comments

More ›