lfittl

11 ms·

61.
by lfittl 4y ago
Doing this well for a production system is a hard problem. The sibling comment pointed out HypoPG and Dexter, but I'm not familiar with folks using a simple approach like the one Dexter implements on a production system. The human elem
62.
by lfittl 4y ago
As one of the authors of the tool that was critiqued in depesz' blog post from last year, I fully agree that looking at this on a per-query basis is too simple. Since we wrote our initial index suggestion tool for Postgres, we actually
63.
by lfittl 4y ago
pganalyze | Backend Software Engineer | REMOTE (US/CA time zones) | Full-time | Salary: $150-190k | https://pganalyze.com At pganalyze, we redefine the user experience for optimizing the performance of Postgres databases. O
64.
PostgreSQL 15 Beta 1 Released(postgresql.org)
13 points by lfittl 4y ago|0 comments
65.
by lfittl 4y ago
> There's another, similar, story around creating draft invoices to give people quotes before checking out. The dashboard API has a function to modify the line items of a draft invoice, but it's not a public-facing API and ther
66.
Fighting PostgreSQL write amplification with HOT updates(adyen.com)
3 points by lfittl 4y ago|0 comments
67.
SQL: One of the Most Valuable Skills(craigkerstiens.com)
12 points by lfittl 4y ago|9 comments
68.
How Postgres Chooses Which Index to Use for a Query(pganalyze.com)
5 points by lfittl 4y ago|0 comments
69.
A detailed guide to colors in data vis style guides(blog.datawrapper.de)
1 points by lfittl 5y ago|0 comments
70.
What Makes Postgres Great(twitter.com)
9 points by lfittl 5y ago|0 comments
71.
by lfittl 5y ago
And for fun, I ended up doing the same in parallel for the 2021 data: https://gist.github.com/lfittl/2f112698f908d38f43f4f2aeaaa94... Note that some of the folks on the list have changed jobs in the last 2 years, so it
72.
Understanding Postgres GIN Indexes: The Good and the Bad(pganalyze.com)
20 points by lfittl 5y ago|1 comments
73.
by lfittl 5y ago
(author here) Thanks for trying out the pganalyze app! Sorry to hear about the challenges with log monitoring setup - happy to restart the trial and do a screenshare to debug - you can email me directly at lukas AT pganalyze.com On the inde
74.
by lfittl 5y ago
(author here) Just realized that could use a more direct link (will add), here is the relevant section from our post on pg_query: https://pganalyze.com/blog/pg-query-2-0-postgres-query-parse... The quick summary: Call
75.
by lfittl 5y ago
(author here) Nice approach! The latter part of that workflow is where we are focused now, i.e. now that we can plan and recommend B-tree indexes for individual queries, how do we utilize this to recommend a set of indexes for a whole datab
76.
by lfittl 5y ago
OP and founder here - we've worked hard on this for 6 months, and are releasing it today! Based on the Postgres planner logic itself, we make index recommendations for your Postgres queries - directly in your browser. Supports B-tree i
77.
Show HN: pganalyze Index Advisor – A better way to index your Postgres database(pganalyze.com)
14 points by lfittl 5y ago|1 comments
78.
by lfittl 5y ago
pganalyze | Senior Backend Engineer | REMOTE (US/CA time zones) | Full-time | Salary: $140-180k | https://pganalyze.com At pganalyze, we redefine the user experience for optimizing the performance of Postgres databases. Our
79.
by lfittl 5y ago
pganalyze | Senior Backend Engineer & Senior Full Stack Engineer | REMOTE (US/CA time zones) | Full-time | Salary: $140-180k | https://pganalyze.com At pganalyze, we redefine the user experience for optimizing the perfo
80.
by lfittl 5y ago
pganalyze | Deep Insights into Postgres | REMOTE (US/CA time zones) | Full-time | Salary: $140-180k | https://pganalyze.com At pganalyze, we redefine the user experience for optimizing the performance of Postgres databases.
81.
An early look at Postgres 14: Performance and Monitoring Improvements(pganalyze.com)
7 points by lfittl 5y ago|0 comments
82.
Efficient Postgres Full Text Search in Django(pganalyze.com)
34 points by lfittl 6y ago|2 comments
83.
by lfittl 6y ago
When using pre-built Postgres packages on modern ARM platforms, like the author of this post is, double check that the Postgres binaries are actually using the ARMv8.2 assembly instructions. This can make a significant performance differenc
84.
Building a recommendation engine inside Postgres with Python and Pandas(info.crunchydata.com)
3 points by lfittl 6y ago|0 comments
85.
Using Postgres and pgRouting to explore the smooth waves of yacht rock (2020)(info.crunchydata.com)
5 points by lfittl 6y ago|0 comments
86.
Things we learned running Postgres 13(pganalyze.com)
377 points by lfittl 6y ago|49 comments
87.
Control Runaway Postgres Queries with Statement Timeout(info.crunchydata.com)
3 points by lfittl 6y ago|0 comments
88.
by lfittl 6y ago
I assume you know this, but just to mention it: For issuing cards, you can use Stripe nowadays. If you're doing this as part of your business (e.g. like Expensify is doing), its available to all US based businesses: https://
89.
by lfittl 6y ago
If you really want to, the pg_hint_plan extension can be used for this - though I would use it very sparingly, if at all: https://pghintplan.osdn.jp/pg_hint_plan.html (available on some cloud providers as well)
90.
by lfittl 6y ago
I agree re: your comment on hosted provider support. Extensibility is a major benefit of Postgres, and there is a lot more untapped potential (e.g. even just for custom data types), if only major providers supported it better. FWIW, from ha

More ›