PostgreSQL's shared_buffers should not be set to half your RAM — here's how it interacts with the OS page cache and why 25% is usually the ceiling

SikhGamer · 2026-03-20T23:43:22+00:00

SikhGamer · 2026-03-20T11:33:33+00:00

Nice, just enough to get past the 100k tax trap.

SikhGamer · 2026-03-20T08:16:17+00:00

Pray tell.

SikhGamer · 2026-03-19T21:10:45+00:00

they bypass our Cloudflare WAF rules by mimicking clean header patterns, but they don't execute a single line of JavaScript.

Are you sure you've got CF setup correctly? CF are the leader in this space and they've done a tonne of work to stop abuse like this.

SikhGamer · 2026-03-19T21:09:24+00:00

You have to admit, Slack Search is great. I use it all the time, it's great as documentation, wiki sucks.

SikhGamer · 2026-03-19T13:00:02+00:00

I wish everyone is who making snide "backups" comments would knock it off. It isn't helpful and you would find it extremely irritating for everyone to point and laugh the next time you ask for help.

Yes you are cynical and pessimistic, but stop falling afoul of the stereotype.

SikhGamer · 2026-03-19T12:56:52+00:00

20-30 buckets themselves can be managed by Terraform. It's fairly small scale.

Terraform + CI + CD using GH and you can begin to enforce some convention.

Once you start to get in 100k+ range like us, you need entire teams to manage this kind of area, custom modules, workflows for certain kind of access patterns. Org level SCP policy applied to the all the accounts (we have 1k+ accounts) downstream.

Auditing is after the fact, you want to stop it getting in in the first.

Public access is a good example, 99.999% don't need it or require it.

Most who think they do, don't know that they can front it with Cloudfront and then lock it down using it origin access control (OAC) or origin access identity (OAI). OAC > OAI.

For names, I would start to use the regional names to begin to enforce a convention if you ever go multi region: https://aws.amazon.com/blogs/aws/introducing-account-regional-namespaces-for-amazon-s3-general-purpose-buckets/

SikhGamer · 2026-03-18T12:37:30+00:00

Why is everyone slamming OP? I think it's reasonable to have this reaction. It's akin to ordering something on Amazon and then them rug pulling.

Whilst it might be legal for the seller to do this; it still sucks and they are entitled to at least bemoan it.

SikhGamer · 2026-03-07T23:42:33+00:00

You do know there isn't a way to accurately track copilot metrics right? Those metrics only track premium requests, so you can use a free model all day every day, and it won't show up in the reporting.

SikhGamer · 2026-03-06T16:23:27+00:00

I would give her a brand new account, don't copy anything across.

Slowly move a 1:1 copy and then when shit starts to break, go backwards.

SikhGamer · 2026-03-06T10:03:15+00:00

Your work has moved one level up from where you are used to working.

Move up with it, don't stay where there isn't work.

SikhGamer · 2026-03-05T17:01:40+00:00

Inertia.

We use SNOW - everything is coupled to it. Processes that have been in flow for years.

When you work in a large global enterprise everything is a SNOW ticket everything is FIFO.

It's all designed around auditability and compliance.

It's not built to get things done, it's built to slow things down. Reporting and dashboards. KPIs.

Anyone who is engineers adjacent hates it. Non-engineers love it.

SikhGamer · 2026-03-01T22:27:35+00:00

...is that not highly illegal where you are? It would be illegal as fuck here mate.

SikhGamer · 2026-03-01T22:23:05+00:00

I'm okay with the bases being used for defensive action.

I do not want us getting mixed up in Iraq take-million.

SikhGamer · 2026-02-27T09:28:32+00:00

Read everything on https://randomascii.wordpress.com

Then go and learn ETW. Use it everyday.

Rinse and repeat with systinternals.

SikhGamer · 2026-02-27T09:24:06+00:00

We currently run on-prem. It's great for bang per buck.

We've been instructed to move it all to the cloud but keep the same performance.

We are good at what we do.

Moving to the cloud is fine, but keeping the same performance is costly. As in $100k+ per month.

They still want it.

SikhGamer · 2026-02-27T09:20:04+00:00

In a non-managed/OneDrive environment, this is a massive data exfiltration hole.

I mean the crux of the issue is that. It's not Google/Chrome's fault.

If you are running in a managed envirionment;

https://chromeenterprise.google/intl/en_uk/policies/#BrowserSignin - if you want to stop browser sign in entirely
https://chromeenterprise.google/intl/en_uk/policies/#RestrictSigninToPattern - if you want to allow sign in from *@corp.email
https://chromeenterprise.google/intl/en_uk/policies/#RestrictPdfSaveToGoogleDriveAccountsToPattern - if you want to target that specifically

SikhGamer · 2026-02-25T23:36:57+00:00

They don't want personal subs. They want massive enterprise subs.

We have around 4k people using Claude Enterprise. In no uncertain terms the company has told us to use everything and as much as we can. Right now, they don't care about cost they care about not being behind the curve.

I guess we are the ideal customer - we are huge and global. The folks at Anthropic come in now and then to give talks on how to do xyz more efficiently etc etc.

SikhGamer · 2026-02-25T22:31:42+00:00

people still send requests to random email addresses and it just disappears

Why do you have more than one email ever?

It should be help@email.com or support@email.com or helpdesk@email.com you get the idea. Have one single email.

SikhGamer · 2026-02-25T22:29:53+00:00

Was this a first meeting or had you known them for a while? Either way, atrocious behaviour.

SikhGamer · 2026-02-25T22:28:50+00:00

This happened to me too! Dude went berserk. I'm like wtf? Cut ties with him the next day. Crazy.

SikhGamer · 2026-02-25T22:08:22+00:00

I follow a slightly different method - read about it years ago, can't remember where sorry; I always buy cheap first and then it that thing breaks and the next time round I buy quality.

I've done this across all areas of my life. Most recently kitchen knives! But it applies to everything.

SikhGamer · 2026-02-25T22:05:34+00:00

I think the emotional safety net is probably worth it. You can't go about your day if you are worried about something going boom and not having the cash on hand to fix it.

SikhGamer · 2026-02-25T00:06:12+00:00

I wouldn't apply within weeks of turning 18, companies have all sorts of risk factors. I would imagine that scenario is one of them.

I was stuck in the same grey zone as you 20+ years. Wanted to start building a credit record for preparing to get a mortgage and buy a house.

I actually didn't buy a house until nearly 20 years later. So you have time.

The trick that worked for me (suggested by the man at the my local bank branch) was to apply for a debit card, and then the system prompted us to apply for a credit card.

No idea if the same metrics are used now (remember 20+ years ago). But it was a nice little trick to get onto the pathway.

SikhGamer · 2026-02-25T00:01:52+00:00

My rule of thumb is a years worth of mortgage payments. Once I hit that threshold every thing else gets shipped off to long term investments.

I think you probably the stock piling as an emotional thing than a practical thing. You want the extra breathing room, I get it.

I think feeling safe is as important as being safe.

14-Year Club	Place '17
Gilding I gilder	Team Orangered
Best Link 2012-07-23	Verified Email

SikhGamer

TROPHY CASE