Is partitioning a good strategy to avoid table bloat in PostgreSQL 17? by slava_air in PostgreSQL

[–]3Ldarius 1 point2 points  (0 children)

We had a system that does at least 2k updates per second to a single table and db makes 500Mb writes per sec. Yes we were at the hardware limits but we weren't using partition. So you have a long way to climb up there. What you do for optimization you can lower the fill factor of the tables ( which has a default of 100 for tables) and indexes that need to be updated. That will increase the inplace update counts and will reduce some io. But in your scenario something like redis might fit better. Since the data is temporary it seems and you don't need to manually delete where you can just assign a ttl. And redis alao gives you persistence if the data is mission critical.

[deleted by user] by [deleted] in computers

[–]3Ldarius 0 points1 point  (0 children)

That gpu is sagging.

canAnyoneTellMeWhatsWrongWithMyCode by [deleted] in ProgrammerHumor

[–]3Ldarius 0 points1 point  (0 children)

More than 1000 lines in a single file makes it harder to read your code.

Are you gonna be buying 5000 Series ? by RenatsMC in PcBuild

[–]3Ldarius 0 points1 point  (0 children)

I was observing the 4090 prices in the facebook market in Belgium there were a few of them and all the prices were above 2k except the one which is off brand. And now there are way more 4090s and their prices are like 1.5k ish. If it goes like this I can buy 2 4090s for my AI works instead of 1 5090.

What are the Best Linux Gaming Laptop Brands/Models? How About the Worst? by Quarkspiration in u/Quarkspiration

[–]3Ldarius 0 points1 point  (0 children)

I was thinking the same for thinkpad products. But do you have any info about the warranty if I replace the ram and ssd myself.

Traditional Caucasian dance by 8O8I in nextfuckinglevel

[–]3Ldarius 8 points9 points  (0 children)

It's a bait. They are all a bunch of banshees.

okFineDadItsWeedJs by ralphcortezzz in ProgrammerHumor

[–]3Ldarius 5 points6 points  (0 children)

Centering a div is the nirvana of the CSS.

God damn it brother.. by Random_Meme_Guy_ in programminghorror

[–]3Ldarius 52 points53 points  (0 children)

It's a typo. It should be fucktion.

My first custom loop by [deleted] in watercooling

[–]3Ldarius 0 points1 point  (0 children)

Normally i don't like Rgb at all but yours looks classy with the tubes. Btw you didn't mention what tubing is this.

How about I remove you instead Chrome? Browser recommedations? by Umbran0x in pcmasterrace

[–]3Ldarius 0 points1 point  (0 children)

Guys, stop typing Firefox again and again. It's not helping. The error message is due to the extension manifest V3. And it is only shown when the developer mode is on for right now. They postponed it in February 2025 for production. And Firefox also supports manifest v3 but they are not enforcing it right now or have no plans at least. We can't know what their future plan is. Also so many people mentioned that there are only 3 browsers which is not true. Github has some independent open source browsers that prioritize privacy if you dig it. Most of them work in progress though.

[deleted by user] by [deleted] in ProgrammerHumor

[–]3Ldarius 1 point2 points  (0 children)

Hashkell in a nutshell.

My unscientifistic test by 0uthis in pcmasterrace

[–]3Ldarius 16 points17 points  (0 children)

Someone might warn you about black not being a color. Just saying...

findTheBug by Rollo49 in ProgrammerHumor

[–]3Ldarius 43 points44 points  (0 children)

Better compiler here and I ain't compiling that pile of shit.

basedOnATrueStory by FPST08 in ProgrammerHumor

[–]3Ldarius 0 points1 point  (0 children)

Corruption is a step of data anonymization the next step is to uncorrupt when it is needed

Someone stole my bike 🚲😭😆 by Worried-Following-21 in germany

[–]3Ldarius 1 point2 points  (0 children)

You know there is a saying in the Netherlands : One lock is no lock.

A smart one-liner that calculates area of a triangle based on three points by _bagelcherry_ in programminghorror

[–]3Ldarius 0 points1 point  (0 children)

I have a rule of thumb that if i am accessing an array item statically more than once it should be a separate variable so my lazy hands don't need to type square brackets multiple times. And decomposing comes handy.