lfittl

8 ms·

31.
by lfittl 3y ago
(OP here, happy to see this on HN!) If you're interested in this topic, Robert Haas (the author/committer of the feature) also wrote two posts after I published this, which talk more about incremental backup: http://rha
32.
by lfittl 3y ago
For additional context, here is a copy of the email we (as a current Sentry customer) received earlier today: --- As you may have heard, we are beginning to make investments in machine learning ([0]) to improve our product experience along
33.
by lfittl 3y ago
Other related projects: * PGXN ( https://pgxn.org/ - the original Postgres community extension repository, though more "old school") * Trunk by Tembo ( https://github.com/tembo-io/trunk - very
34.
by lfittl 3y ago
Thanks, thats good feedback! And agreed, two servers is a bit of a gap in our pricing right now. If you're open to paying annual instead of monthly, we have a bit more flexibility since we can set them up as custom contracts (feel free
35.
by lfittl 3y ago
You can find our pricing on the website [0] - generally $100/month per instance (though note our smallest plan is $150/mo). pganalyze Index Advisor, which is the subject of the post is available with all plans. Generally I (Founde
36.
by lfittl 3y ago
Author here - what we call "pg_plan" internally, is essentially very similar in spirit to what we do with pg_query [0], but the difference is that we pull in a lot more code from Postgres, and have more overrides in places that ar
37.
by lfittl 3y ago
OP here (happy to see this on HN!) - if you're interested in our work in this area, I hosted a webinar earlier this week where we walked through a new constraint programming based system (utilizing CP-SAT) for Postgres index selection
38.
by lfittl 3y ago
pganalyze | Head of Sales | REMOTE (US/CA time zones) | Full-time | base $120-150k + commission/bonus + equity | https://pganalyze.com At pganalyze, we build observability and automation tools for optimizing the perfor
39.
by lfittl 3y ago
Here is the email they sent for this, with some extra context: "Earlier this year, we shared our view on AI at Figma [0] and the importance of being open with our community about our AI journey moving forward. Since then, we've be
40.
by lfittl 3y ago
https://www.openwall.com/lists/oss-security/2023/10/03/2 is probably a better link (without ads and unnecessary images), which is essentially what the article is citing 1:1.
41.
by lfittl 3y ago
You can see a break-down of the core team and major contributors here, as well as their current company affiliation: https://www.postgresql.org/community/contributors/ (and as noted in the other comment, whilst ED
42.
by lfittl 3y ago
In the above described scenario (US-based retiree moving to Germany), its likely the social security totalization treaty applies, giving them access to the health system: https://www.ssa.gov/international/Agreement_Pamp
43.
by lfittl 3y ago
Generally I agree that this would be great to have, and Postgres does have a set of libraries it already maintains as part of the main source tree (i.e. libpq, etc), and there is a shared set of code between the backend and the "fronte
44.
by lfittl 3y ago
Excited to see this - and excellent use case for libpg_query (I'm the original author and still help maintain it together with the rest of the team) and appreciate the shout out to pganalyze! If anyone else has a use case for using the
45.
by lfittl 3y ago
We at pganalyze would definitely welcome help here - and if anyone would like to give this a try - feel free to email me, happy to talk this through, email is in my profile. Postgres itself supports Windows, the main challenge is identifyin
46.
by lfittl 3y ago
Thanks Yuri - and appreciate your contributions to libpg_query! We at pganalyze have plans to add Postgres 16 support to libpg_query sometime between the RC1 and the final release - mostly to watch out for the rare case where a feature gets
47.
by lfittl 3y ago
I think Supabase generally does good work, but I don't think they can be given credit for pgvector, if that's what you're indicating (I might have misread). As I understand, Andrew Kane is the principal author of pgvector, an
48.
by lfittl 3y ago
Neat project! Just in case its helpful to you, I maintain pg_query together with my colleagues at pganalyze, which packages the Postgres parser as a library: https://github.com/pganalyze/libpg_query Might be useful to
49.
by lfittl 4y ago
It does not, except if you're COPYing into an unlogged table - for regular tables data that gets COPYed in gets WAL logged and is crash safe. In my understanding, as compared to a multi-row insert, a COPY statement is (1) a lot more ef
50.
by lfittl 4y ago
Good catch. Thats actually intentional at the moment - we don't put the weekly "5mins of Postgres" episodes in our RSS feed. Primarily since we syndicate the feed to Planet Postgres, and video would go against the rules. I&#x
51.
by lfittl 4y ago
OP here - thanks for noting! We've recently invested effort to make the homepage better (added the animation, revised the messaging, etc), so that makes me happy to hear & will forward to the team as well.
52.
Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io(pganalyze.com)
168 points by lfittl 4y ago|29 comments
53.
by lfittl 4y ago
Fair point, I read this more under the light of paying for an ongoing therapist relationship to deal with a challenging situation (which as noted in another comment, $300 as a one time payment doesn't do much if you have weekly session
54.
by lfittl 4y ago
To clarify why it bothers me: It tries to tell a story of "we as a company care about you", but at least in my experience, health care plans cover less than $100 per session, and in the SF Bay Area you easily pay $200+ per session
55.
by lfittl 4y ago
The "$300 mental health" seems odd - for any kind of counseling/therapy/etc sessions this is a drop in the bucket in terms of cost. It will easily cost 10x to work with a mental health professional (and insurance compani
56.
by lfittl 4y ago
Agreed - I think MERGE is great, but this post is missing the "Why not" part of the analysis. In the Postgres community, MERGE has been talked about for a long time, but in my understanding, part of the reason why the Postgres tea
57.
by lfittl 4y ago
Autovacuum essentially runs a regular VACUUM, which helps you prevent new table bloat. However, to avoid locking issues, it does not fully rewrite the table, so it does not remove existing table bloat. If you want to remove existing table
58.
by lfittl 4y ago
Agreed. It's clear that PostgresPro is profiting from this, and they have not taken a stance on Russia's war in Ukraine (I imagine they couldn't, given how much money they are to make in the now isolated Russian market). And
59.
by lfittl 4y ago
pganalyze | Backend Software Engineer | REMOTE (US/CA time zones) | Full-time | Salary: $150-190k | https://pganalyze.com At pganalyze, we build observability and automation tools for optimizing the performance of Postgres
60.
Soft deletion probably isn't worth it(brandur.org)
654 points by lfittl 4y ago|494 comments

More ›