ahachete

24 ms·

211.
63-Node EKS Cluster Running on a Single Instance with Firecracker(ongres.com)
1 points by ahachete 6y ago|0 comments
212.
by ahachete 6y ago
It appears the current CF stack is not valid JSON file: $ http https://vantage-public.s3.amazonaws.com/x-account-role-creat... | jq '.' parse error: Expected another key-value pair at line 420, column 17 (Haven&#x
213.
by ahachete 6y ago
Is any software ever finished? ZFS has been quite feature-full and production ready for more than a decade... why do you think it is not finished?
214.
Free 1GB Postgres Database on AWS CloudShell(ongres.com)
4 points by ahachete 6y ago|1 comments
215.
Amazon Managed Service for Grafana(aws.amazon.com)
204 points by ahachete 6y ago|66 comments
216.
Automation to run VMs based on vanilla Cloud Images on Firecracker(ongres.com)
1 points by ahachete 6y ago|0 comments
217.
by ahachete 6y ago
Doesn't AWS (and every big cloud/enterprise) follow best-practices for production operation like FIT-ACER? https://pythian.com/uncategorized/fit-acer-dba-checklist/ That's even more surprising to me
218.
by ahachete 6y ago
Cannot edit any longer, but yes, that's a typo, it's 300K QPS. Right now the cluster is only 8 instances, and the write-only traffic on the master spikes to 70K QPS. So I agree with you --pretty beefy hardware, and it'd proba
219.
by ahachete 6y ago
GitLab.com is serving around 300QPS at peak (see https://about.gitlab.com/blog/2020/09/11/gitlab-pg-upgrade/ ). While that's like 1/7th of Slack's traffic, it is served by a single Po
220.
by ahachete 6y ago
It's no longer maintained :(
221.
by ahachete 6y ago
Note that DynamoDB's PartiQL support is not an architectural pattern but rather a "simple" translation layer on top of the current three read operations. It doesn't say much to me tbh. I wouldn't say is impossible t
222.
by ahachete 6y ago
I enjoy trying to guess how cloud services like Amazon Timestream are internally built. I have already bet in the past that DocumentDB was built on top of (Aurora) PostgreSQL (this I also know was possible as I founded https://to
223.
AWS announces Babelfish: open-source Postgres with SQL Server compatibility(ongres.com)
1 points by ahachete 6y ago|0 comments
224.
by ahachete 6y ago
Hi. Blog author here. Ready to ask some questions and gather opinions :)
225.
Is It Time to Modernize the PostgreSQL Core Team?(postgresql.fund)
8 points by ahachete 6y ago|1 comments
226.
by ahachete 6y ago
But if you don't, it suggests you one. My point here is that some of the suggestions provided, if taken by a non expert user, may do more harm than good. And the reason is that there are many factors that need to be considered for most
227.
by ahachete 6y ago
Edit: url above is wrong, correct one is https://postgresqlco.nf my brain tricked me ;)
228.
by ahachete 6y ago
Thank you for the feedback, we take it seriously. There's an upcoming new version that will come with something similar to what you say: some "guide" on which parameters to tune, classified by categories, and with varying lev
229.
by ahachete 6y ago
Sorry for the confusion. As pointed downthread, the idea is to provide help and information about postgresql.conf parameters. This is important feedback for us. We will fix this landing page soon to include a search box, like search engines
230.
by ahachete 6y ago
One of the main reasons https://postgresql.conf exists is precisely to provide as much information as possible to understand how to tune PostgreSQL's configuration. If generating a config would be as simple as filling in
231.
Universal Relation Data Modelling Considered Harmful(ongres.com)
4 points by ahachete 6y ago|0 comments
232.
by ahachete 6y ago
The precise root cause was Postgres statistics on a given table were completely off. This caused, as you well pointed out, that a frequent query that normally takes 1-2ms started timing out (timeout is 15s). This caused an error spike and s
233.
by ahachete 6y ago
I agree. I normally recommend multiplying the number of cores by a 2-5x factor, and then dividing all that by a subjective "% utilization of the connection", which is obviously a value lower than 1 and results in an increased valu
234.
by ahachete 6y ago
That's correct. And OpenMetrics is a standardization effort on metrics (basically, standardize and improve Prometheus format).
235.
by ahachete 6y ago
I'm not affiliated with otel, but I'd say it is just otel is still moving forward quickly and there's no good (almost not) documentation on how to use it. I did some small setup with otel, Java and Quarkus, and I will publish
236.
Lupine: Linux in Unikernel Clothes(github.com)
3 points by ahachete 6y ago|0 comments
237.
Beyond jsonb: a generalized, unstructured data type for Postgres(ongres.com)
17 points by ahachete 6y ago|2 comments
238.
Postgres EXPLAIN ANALYZE may be lying to you(ongres.com)
1 points by ahachete 6y ago|0 comments
239.
by ahachete 7y ago
> the chance you can atomically update a system, whatever kind of database you're using, isn't something you necessarily get Postgres supports fully atomic DML and DDL operations. You can do transactions as big as you want (
240.
by ahachete 7y ago
A migration in this context may involve rewriting substantial parts of the database. Imagine you need to rewrite a several TB collection. How would you do it? Either you involve in significant downtime, or you face the risk of breaking data

More ›