ankitml
Re:The only scalable delete in Postgres is DROP TABLE
on Sunday June 14, 2026 @08:21PM (#48534791)
This is directionally correct approach. Deleting a large chunk of rows, in a large table does lead to unpredictable-bad behaviour for a while until those dead tuples are handled.
I have used a very similar strategy by forking repack client https://github.com/reorg/pg_repack/pull/326 This works out of the box with rds/cloudsql etc.
Re:New quantum state of matter found at interface of exotic materials
on Monday August 04, 2025 @08:38AM (#44784982)
So your claim is spin ice as a concept doesnt exist in particle physics and would not be discussed outside solid state?
Re:Try Deep Think in the Gemini App
on Friday August 01, 2025 @07:43PM (#44763637)
I have ultra. Will not be renewing it. Useless, at least have global limits and let people decide how they want to use it. If I have tokens left, why can't I use it for code assist?
Re:Photon transport through the entire adult human head
on Wednesday June 18, 2025 @08:47AM (#44309427)
Hypothetically my ancestors were cheetah and not hominoid apes. One needs to prove foundational hypothesis before larger claims that can be built on top of those.
Re:Photon transport through the entire adult human head
on Tuesday June 17, 2025 @07:25PM (#44305063)
Teleport is not a thing a photon can do. Leave alone across brain
Re:US Streetlights Are Turning Purple
on Tuesday June 17, 2025 @07:02PM (#44304949)
Design choices must include failure modes. IMHO, utterly stupid to only consider happy path.
Re:My new hobby: watching AI slowly drive Microsoft employees insane
on Wednesday May 21, 2025 @07:29AM (#44050304)
GitHub is not the place to write code. IDE is the place. Along with pre CI checks, some tests, coverage etc. they should get some PM before making decisions..
Re:Haskelling My Python
on Monday April 21, 2025 @06:15PM (#43757104)
It is possible to test the chaining though, if you know your data well. If not, those edge cases in the data quality can throw things off balance very easily.
Re:Dead trees keep surprisingly large amounts of carbon out of atmosphere
on Monday April 14, 2025 @11:24AM (#43682334)
Dead trees can exist as furniture, flooring and buildings too. Stored carbon with ancillary usage.
Re:Google is publishing the home addresses of developers without their...
on Friday March 28, 2025 @10:08AM (#43505613)
Amazon did that to a physical product my wife is selling. I was very annoyed. But it ended up being a configuration but default being `show address` state is definitely annoying.
Re:I tried making artificial sunlight at home
on Friday March 28, 2025 @10:05AM (#43505589)
you do you. NIR is the part of sunlight that makes you "feel" good or alive or whatever nice thing you are looking from being outside.. Ill stick with NIR is essential component for calling stream of photons as sun-like.. or not sun-like.
Re:I tried making artificial sunlight at home
on Thursday March 27, 2025 @06:07PM (#43498735)
Yep, that was my first assessment. Cant call it sun without NIR.
Re:Sharding Pgvector
on Wednesday March 26, 2025 @10:51PM (#43489943)
Well, I have a brute force strategy for pgvector working reasonably well. Individual, partial indexes. It works for all those queries with category_id=<> clauses. You only need an index for larger categories, for categories with rows below a threshold you dont need index a KNN/dot product would work.
Re:Sharding Pgvector
on Wednesday March 26, 2025 @10:44PM (#43489907)
Depends on the hardware, sharding layout, bulk/individual insert and table bloat. Looks like you are missing pg_repack..
Re:670nm red light exposure improved aged mitochondrial function, colo...
on Thursday February 20, 2025 @06:53PM (#43122168)
get a broad spectrum red light bulb, that is most well understood and is least risky. Cons is the targetted spectrum would be only a small portion of it but good thing is it is a 4$ cheap test. It worked for me for smaller issues, like minor burns, cuts etc.
Re:670nm red light exposure improved aged mitochondrial function, colo...
on Thursday February 20, 2025 @06:49PM (#43122122)
Vitamin D is not an outcome of standing by fire. It is from UV spectrum which is entirely absent from fires. It needs high temperature fire like fusion to be emitted. Totally doable by sun but not by your campfire.
Re:670nm red light exposure improved aged mitochondrial function, colo...
on Thursday February 20, 2025 @06:48PM (#43122110)
Morning and evening is entirely infrared (80-90 percent with rest of it visible). No UV.
Re:670nm red light exposure improved aged mitochondrial function, colo...
on Thursday February 20, 2025 @06:46PM (#43122086)
i dont know what you mean by science. There are literally 1000s of research papers showing mitochondrial "horsepower" with red light on every type of tissue. Cells heal themselves as first thing when they get extra energy. Do you want your neighborhood clinic to validate before trying some light samples out?
Re:670nm red light exposure improved aged mitochondrial function, colo...
on Thursday February 20, 2025 @06:45PM (#43122071)
skepticism without homework is stupidity. The above snark demonstrates effectively.
Re:670nm red light exposure improved aged mitochondrial function, colo...
on Thursday February 20, 2025 @06:43PM (#43122051)
infrared, yes. Although depends on skin colour wrapping the skull. Melanin absorbs everything under the sun. It has very high absorption of UV but somewhat absorbs infrared too in this range of frequencies. Darker the color of skin, higher the melanin and higher the absorption by skin.
Re:670nm red light exposure improved aged mitochondrial function, colo...
on Thursday February 20, 2025 @06:39PM (#43122022)
whats the pulse frequency you use?
Re:670nm red light exposure improved aged mitochondrial function, colo...
on Monday February 17, 2025 @10:26PM (#43085785)
There are more than 1000 similar papers on red and near infrared. All pointing to its impact on mitochondria. Near Infrared (NIR) penetrates few cm, leading to its mitochondrial impact in muscle cells too.
https://scholar.google.com/scholar?hl=en&as_sdt=0,5&q=near+i...
Re:Amazon terminates iRobot deal, vacuum maker to lay off 31% of staff
on Monday January 29, 2024 @03:34PM (#39182114)
My roomba was cleaning much better 4 years ago than last 2 years, their app was slick 4 years ago and clunky in last 2 years. Random Product innovations degraded the core product. They did get complacent.
Re:Ask HN: What is one thing that has improved your energy the most?
on Friday November 17, 2023 @10:00PM (#38314453)
I am eating lots of plants along with meat, but I would say my 75% calories now come from meat. I dont have stomach acidity (i used to have it since grade 4), frequent migraines, IBS. I have increased mental clarity, better focus, better sleep.
I would attribute most of these changes to grains/gluten reduction than meat adoption.
Re:Ask HN: What is one thing that has improved your energy the most?
on Tuesday November 14, 2023 @04:02PM (#38269694)
Worth trying and testing. After 32 years of eating vegetarian, this radical change was worth every penny.
Re:Ask HN: What is one thing that has improved your energy the most?
on Tuesday November 14, 2023 @02:39PM (#38268455)
Switching to a mainly meat based diet, increasing protein and reducing industrially produced foods.
Re:In a surprising finding, light can make water evaporate without heat
on Thursday November 02, 2023 @04:53PM (#38119994)
Quantum effects can change thermodynamic parameters. If something seems bizzare in thermodynamic models, next step is to understand quantum physics. This includes modification of energy needed for reaction to phase change energy needs.
Re:Pg_bm25: Rust-based full text search engine in Postgres
on Friday September 29, 2023 @03:11PM (#37708857)
Thanks, this is interesting. Are you considering WAND support too in this?
https://www.elastic.co/blog/faster-retrieval-of-top-hits-in-...
Re:Ask HN: What are interesting new developments in databases related ...
on Sunday June 05, 2022 @05:15PM (#31634930)
Doing more math in databases. eg. PostGIS, vector math, ML type workloads supported by declarative SQL.
Re:India’s largest bank SBI leaked account data on millions of customers
on Wednesday January 30, 2019 @03:01PM (#19038800)
Cant use password manager either for most of them. example ICICI (one of the biggest private bank) doesnt allow you to paste passwords either. Only way to use password manager is to meddle with view source to allow pasting.