zac23or

8 ms·

31.
Hold the French Fries Paris Olympics Chart a New Gastronomic Course(nytimes.com)
2 points by zac23or 2y ago|0 comments
32.
Postgres Planner Quirks: The impact of ORDER BY and LIMIT on index usage(pganalyze.com)
3 points by zac23or 2y ago|0 comments
33.
by zac23or 2y ago
Adapting a quote from Brian Cantrill ( https://youtu.be/-zRN7XLCRhc?t=33m1s ): Do not fall into the trap of anthropomorphising a CEO. You need to think of a CEO the way you think of a lawnmower. You don't anthropomorphi
34.
by zac23or 2y ago
> Someone made ... This example demonstrated to me that Apple is a religion, after many other examples. Try reading Apple's blogs, it's crazy. I recommend not trying to talk to extremists in any area. Your life will be much bet
35.
by zac23or 2y ago
Apple is like a religion. An Apple user told me “Apple never makes mistakes” during the Antennagate. I never forgot that, and I try not to have conversations with Apple fans after that.
36.
by zac23or 2y ago
I also had the same bad experience with Rust outside of Gamedev. Probably a lot of other people too, but people don't talk about it much, because the Rust community is the most religious programming language community I've ever se
37.
by zac23or 2y ago
Flagged again. Is HN like this now?
38.
by zac23or 2y ago
> but for rural areas I suspect is not feasible? Aedes aegypti is an urban mosquito. Degue is an urban disease. The big difference between Brazil and Singapore is sanitation: https://en.wikipedia.org/wiki/Water_suppl
39.
by zac23or 2y ago
0.16% of Singapore's population had Dengue in 2022. 1.4% of Brazil's population had Dengue in 2023.
40.
by zac23or 2y ago
Are you comparing 8k cases (Singapore) with 3 million cases per year (Brazil)?
41.
by zac23or 2y ago
Singapore had 8 thousand cases in 2022. Brazil has 3 million cases of dengue in 2024.Is not the same thing. The poor distribution of water and the lack of sewage are fundamental to dengue fever in Brazil.
42.
by zac23or 2y ago
> Dengue is just a difficult thing to fight Singapore had 8k cases in 2022. Brazil has 3 million cases of dengue in 2024. Is not the same thing.
43.
by zac23or 2y ago
Singapore had 8 thousand cases in 2022. Brazil has 3 million cases of dengue in 2024. Is not the same thing.
44.
by zac23or 2y ago
Dengue is not a tropical disease. That does not exist. Dengue is a disease of bad governments. In Brazil, the majority of the population does not have sewage. Tap water is not potable and is not distributed every day, in some areas twice a
45.
by zac23or 3y ago
Async and Thread are of different abstraction levels[1]. The easier to use, the higher the abstraction level. Rule of thumb: use the highest level of abstraction for your case. Of course, the Async implementation can be atrocious or in con
46.
by zac23or 3y ago
Counting lines of code as a production metric is very stupid. I remember solving an unsolvable 20 years old bug with a line of code, another 3 years old with a order by. How to measure the impact of a line of code? And in my experience, bad
47.
by zac23or 3y ago
> how organization_id is being generated The default value of the column: organization_id int default floor(random()*10) > Also, if each page contains data from all organizations then sounds very much like it's not cluste
48.
by zac23or 3y ago
In my old tests, with data clustered by organization_id, the SQLite and SQLServer run the query very fast. > is not to be so certain that there is "a correct query plan" Yes, data distribution, type, row size, machine power, SS
49.
by zac23or 3y ago
The sample data is distributed equally, each page contains data from all organizations. The actual data is much more grouped by organization, like this: insert into foo (id, created_at, updated_at) select generate_series(1, 4000000),
50.
by zac23or 3y ago
I agree with everything you said, but it's frustrating that the planner fails on a seemingly trivial query ("seemingly trivial", perhaps it's a very complex problem). > So it takes time to get new stuff in. It's
51.
by zac23or 3y ago
foo_organization_id_idx is the correct index, in my case using foo_organization_at_idx is 100x, 1000x faster. In all my queries, the correct index is in the where clause, not the order by clause: When I removed the use of the wrong index, (
52.
by zac23or 3y ago
See https://news.ycombinator.com/item?id=39730206
53.
by zac23or 3y ago
I changed random_page_cost to 1! The query continue to use the wrong index.
54.
by zac23or 3y ago
You reproduced it. See the index being used. foo_updated_at_idx, not foo_organization_id_idx. See a FILTER on Organization_id, not a Cond index. If you create an index using Organization_id and updated_at the plan changes to: Limit (c
55.
by zac23or 3y ago
> If you want to blame LE for the breakage then also blame ... Of course they are also guilty. LE isn't the most to blame in reality, it's just an example that old hardware isn't important to decision makers.
56.
by zac23or 3y ago
Product Owner
57.
by zac23or 3y ago
Nobody, nobody, nobody cares about old hardware, performance, users, etc. if anyone cared, React wouldn't be a success. The last time I tried to use the react website on an old phone, it was slow as hell. LetsEncrypt is stopping servin
58.
by zac23or 3y ago
> It's really hard to say why this is happening without EXPLAIN ANALYZE I can run EXPLAIN and paste it here, but it's just one of the problems with the planner (in a very basic query), I have many other problems with it. On the
59.
by zac23or 3y ago
seq_page_cost is 1; random_page_cost is 2; I have many other problems with the planner, this is the most absurd due to the simplicity of the query.
60.
by zac23or 3y ago
> Logic of optimizer is usually reasonable I agree. My problem is that SQLite, an embedded database, seems to have a better Planner/Optimizer than Postgres. Is the development of Planner/Optimizer abandoned? > my problem wit

More ›