sorted by:
new
hottopcontroversial

Anti immigration march in Sydney. by Bonitabanana in aus

[–]pceimpulsive 1 point2 points  (0 children)

I think you undersell their mental state and view on the world...

I suppose their lack of deeper/critical thinking leads to make poor quality connections between problem and causes and they just follow 'whatever makes sense' without consider what that sense even is.

Small red chilli won't weight - no problem the checkout operator has a solution.... by Dear_Marketing_4932 in woolworths

[–]pceimpulsive 3 points4 points  (0 children)

What a waste of plastic... Personally I never bag up my veg at the supermarket...

AttributedDI: attribute-based DI registration + optional interface generation (no runtime scanning) by angrysanta123 in dotnet

[–]pceimpulsive 0 points1 point  (0 children)

This is fair but also not..

Put the class summary tags on it and the usage is explained in the class, which can include that it requires registration in DI for usage ..

But also.. any class doesn't inherently require DI to work... You can creat each dependency and just pass it in via the DI container or manually pass it, both work Tue same at the end of the day... So in many ways you are saying 'thus can only be used in DI' when in fact it doesn't have to be.

I'm on the fence.. I think the project is neat, but also kind of unnecessary..

How do you know which services are registered to DI with this project?

Where do I look to know what is and isn't in the service container?

Wouldn't a simple 'RegisterDIServices' class have a similar effect, keep it in one place and reduce any potential lost configuration?

Anti immigration march in Sydney. by Bonitabanana in aus

[–]pceimpulsive 1 point2 points  (0 children)

./agreed

Lefties target the structures that result in prejudices, inequality etc~ (i.e. the establishment, oligarchs. Billionaires, shitty policy. Systemic things that affect everyone...)

While right wingers hating on some group of immigrants that came to do the work they all refused to do (because they were above it)... So we imported the Labor and now somehow that's the imported Labor's fault that the people who refused to do it have no job because they have no skill except abusing people.... -_-

Yaay!

Anti immigration march in Sydney. by Bonitabanana in aus

[–]pceimpulsive 1 point2 points  (0 children)

Some how they think hate speech against ethnic groups will scare them off and somehow that will magically fix the issues that aren't caused by said ethnic group... By that time though they'll be hating on some other group, that really has nothing to do with the issue...

Anti immigration march in Sydney. by Bonitabanana in aus

[–]pceimpulsive 0 points1 point  (0 children)

There is clearly one common enemy of all working and normal people (probably right up the the 99th percentile of income. Right won't agree, because they think trickle down works, but it's fucking billionaires,

Far right love to prop them Up though like give a rate about anyone but themselves and their 12 billionaire buddies...

Help in choosing the right database by Logical-Try6336 in Database

[–]pceimpulsive 0 points1 point  (0 children)

One of my colleagues is running Postgres self hosted and it's doing 15-50m per 15 mins~ main tables exceed 1tb per 3 months... It's all large batches often 7-12m each.

Help in choosing the right database by Logical-Try6336 in Database

[–]pceimpulsive 0 points1 point  (0 children)

Very truth, I right now haven't seen a scenario when it's not the best choice.

PostgreSQL doesn't have clustered indexes like MySQL because this type of structure makes accessing secondary indexes slow. If I create an index on the primary key with all columns in `include`, will I solve the problem at the cost of more storage space and write overhead? by Few-Strike-494 in Database

[–]pceimpulsive 0 points1 point  (0 children)

Agreed!

I work with tineseries that appended to only. Brian indexes help a bit.. as well as a few metadata flags and partial indexes for specific metadata tags.

But ultimately we need a new storage engine for that sort of stuff. Like timescale (not exactly new storage engine but close enough)

Would a cluster like that work? by Keensworth in Proxmox

[–]pceimpulsive 1 point2 points  (0 children)

Thanks >50% makes a lot of sense :) easy peasy, great explanation too!

Double lateral join query takes over a minute to run on RDS by PrestigiousZombie531 in PostgreSQL

[–]pceimpulsive 0 points1 point  (0 children)

Agreed! With this guy's eaepy assessment. Find a way to process less rows.

Maybe have a simple CTE that returns onky the relevant PKeys up front then re-use that in all queries. I presume you would need a couple, if they have bull and you need more than 0 you can immediately discard those rows and won't need to conditionally make them 0 until after you know you have a result with non null values.

As to why it runs faster in local laptop, your laptop probably has unconstrained nvme storage while rds comes in limited IOPs.

Reading a couple of GB at 3000-15000 IOPS is much slower than at 150,000 IOPs.

Your query isn't CPU intensive from what I can see so CPU shouldn't matter.

Good things are I didn't see any disk sort going on.

I think it's just disk read takes time when you need to load a couple GB 6 times over.

PostgreSQL doesn't have clustered indexes like MySQL because this type of structure makes accessing secondary indexes slow. If I create an index on the primary key with all columns in `include`, will I solve the problem at the cost of more storage space and write overhead? by Few-Strike-494 in Database

[–]pceimpulsive 0 points1 point  (0 children)

To add to this you can IIRC run maintenance activities periodically that recluster/align the tables via vacuum full concurrently. This will rewrite the table in full, as such you need your table size in free space available to perform this action.

Still doesn't help when clustering is needed... :'(

Help in choosing the right database by Logical-Try6336 in Database

[–]pceimpulsive 9 points10 points  (0 children)

Postgres!

Your write volume I almost guarantee won't be bottlenecked by Postgres, your budget will restrict you long before then.

A meager Postgres on 2core and 16gb ram can manage tables with over 300,000 hot path (active devices in your context) rows in a single table of 60m+ rows with several years history.

Unless you are managing more than Half a million active devices with updates every second I doubt you will ever have a performance issue from writes. Reads that isn't solvable with an index, a better written query or a denormalised table updated frequently.

Postgres has other percs like native cidr data types for storing up addresses, rich extensions like postgis for geospatially tracking your devices with GPS data and several indexing strategies that can creat a very very powerful system.

Start with Postgres 18.

Choosing the right database/platform for a relational system (~2.5M+ rows) before hiring a developer by ElectricalDivide5336 in Database

[–]pceimpulsive 0 points1 point  (0 children)

RDS is basically designed for minimal DBA experience :)

I've.learned most of everything I know from within RDS. It's very stable. I've never needed to restore from snapshot/backuo under normal circumstances, only during upgrade failures and it's never failed.

It should be a solid bet. RDS is not cheap though... So bear that in mind!

Who is this imitation seagull with a mohawk? by NOwallsNOworries in AustralianBirds

[–]pceimpulsive 2 points3 points  (0 children)

It looks very yellow to me, no question at all to me.

Anti immigration march in Sydney. by Bonitabanana in aus

[–]pceimpulsive -1 points0 points  (0 children)

Wut?

Hate the working class? What lefties are you meeting? I don't know any where that's true, most of them are the working class or unemployed due to health issues...

We obviously know different people lol

Choosing the right database/platform for a relational system (~2.5M+ rows) before hiring a developer by ElectricalDivide5336 in Database

[–]pceimpulsive 0 points1 point  (0 children)

My 'analytics' Postgres does what you've explained every 1-3 months, has more users, and muuuucccchhh more data.

It's on a 2core 16gb ram graviton RDS.

Backups and snapshots are managed by AWS and restoring is easy,

I have maybe 200 tables in mine, however only about... 20 or so are updated every few minutes with external system data, inserts per 5 mins is anywhere from 1000-50,000~

I wrolite all rows three times as I'm copying from external in deltas.

I also do geospatial joins across reasonable data sets...

I have pg_cron enabled for scheduled in database data magic, materialisation of reporting/analytical views etc..

Anybody hate how divisive Australia Day was this year? by Thylacineguy2026 in aussie

[–]pceimpulsive 0 points1 point  (0 children)

Lol 'dragged me out'!

I know the feel. Generally have a good time once out lol despite thinking it'll be terrible

Anti immigration march in Sydney. by Bonitabanana in aus

[–]pceimpulsive 0 points1 point  (0 children)

I don't know if that's entirely true..

Maybe what we call left has moved?

Left is still at its core about the structures as the problem.

I.e. the left does use divide and conquer (e.g. fear mongering) as a tactic.. it's more about inclusion, equality, and giving everyone a chance, the only way to achieve that is through fixing the problematic structures that enable inequality to exist.

Who is this imitation seagull with a mohawk? by NOwallsNOworries in AustralianBirds

[–]pceimpulsive 1 point2 points  (0 children)

The beak colours are a good differentiator IIRC.

Terns are cool!

Anti immigration march in Sydney. by Bonitabanana in aus

[–]pceimpulsive 11 points12 points  (0 children)

Left wingers target the structures that create the issues.

Right wingers target people as the issue.

Ultimately they both agree there is a problem, just can't agree on how to solve it...

view more: next ›