Has network latency improved much since this article's date? Bandwidth definitely, but latency?
What was the salary range?
Most rankings / evaluations will be subjective with or without a rubric.
Are they even hiring at this time?
Interesting idea. Many years ago when I was learning French I seemed to speak it much better after a drink or two with a French speaking neighbor. Maybe it was less worry over grammar though I can't say I felt nervous…
I used a friend's xanax. Admittedly I should've trialed it beforehand, mistake on my part. I just remember feeling a really strong relaxation and nothing afterwards. I did get an offer but I still wonder today if I said…
This a good a solution that extends to other aspects of a job as well. It also doesn't lead to possible dependence like other solutions.
I would advise strong caution against this unless you have used any benzo before. I remember I tried one once before a long, 4 hour interview. I literally don't remember a thing I said or did the rest of the day…
I agree with this. Interviewing is a skill like any other that can get stale. It's good to keep it sharp and you never know, while practice interviewing you might find a place you end up really liking.
This should also be observed on HN. I have seen too many Show HN posts with no constructive criticism with the only comment deriding a technical choice / language.
Where did you find your job from?
That's unfortunate. I hate system design interviews where the interviewer has a "known" solution in mind and won't accept any other solutions even with good arguments, but you could have dodged a bullet if they are…
This has been my experience as well. These interviews should be open-ended with no right answer as long as you can reasonably support your design and discuss its tradeoffs. Unfortunately, many interviewers have a set…
All these differing opinions on this tells me interviews are a crapshoot subject to the interviewer's whims. If I got you for an interviewer I would need to be specific, for others who replied to this, I'd need to be…
Go to a derm/doc to see if there are any nutritional deficiencies (unlikely though). Once that's ruled out, get on Finasteride. 99% of people maintain their hair. Unless you're slick bald, this is a must if you're…
I think the wiki explains it well https://wiki.postgresql.org/wiki/Index-only_scans#Is_.22coun... It says that index only scans can be used with predicates and less often without predicates, though in my experience I've…
Apologies, I should've clarified. I just meant postgres doesn't necessarily have to scan the actual table to get the count in some cases if an index is available, not that it caches the actual count.
Not necessarily in postgres. If an index is available it may use that, though it will still have to refer to the visibility map to see if any row is available to the current transaction (cheap check), and if it can't…
Has network latency improved much since this article's date? Bandwidth definitely, but latency?
What was the salary range?
Most rankings / evaluations will be subjective with or without a rubric.
Are they even hiring at this time?
Interesting idea. Many years ago when I was learning French I seemed to speak it much better after a drink or two with a French speaking neighbor. Maybe it was less worry over grammar though I can't say I felt nervous…
I used a friend's xanax. Admittedly I should've trialed it beforehand, mistake on my part. I just remember feeling a really strong relaxation and nothing afterwards. I did get an offer but I still wonder today if I said…
This a good a solution that extends to other aspects of a job as well. It also doesn't lead to possible dependence like other solutions.
I would advise strong caution against this unless you have used any benzo before. I remember I tried one once before a long, 4 hour interview. I literally don't remember a thing I said or did the rest of the day…
I agree with this. Interviewing is a skill like any other that can get stale. It's good to keep it sharp and you never know, while practice interviewing you might find a place you end up really liking.
This should also be observed on HN. I have seen too many Show HN posts with no constructive criticism with the only comment deriding a technical choice / language.
Where did you find your job from?
That's unfortunate. I hate system design interviews where the interviewer has a "known" solution in mind and won't accept any other solutions even with good arguments, but you could have dodged a bullet if they are…
This has been my experience as well. These interviews should be open-ended with no right answer as long as you can reasonably support your design and discuss its tradeoffs. Unfortunately, many interviewers have a set…
All these differing opinions on this tells me interviews are a crapshoot subject to the interviewer's whims. If I got you for an interviewer I would need to be specific, for others who replied to this, I'd need to be…
Go to a derm/doc to see if there are any nutritional deficiencies (unlikely though). Once that's ruled out, get on Finasteride. 99% of people maintain their hair. Unless you're slick bald, this is a must if you're…
I think the wiki explains it well https://wiki.postgresql.org/wiki/Index-only_scans#Is_.22coun... It says that index only scans can be used with predicates and less often without predicates, though in my experience I've…
Apologies, I should've clarified. I just meant postgres doesn't necessarily have to scan the actual table to get the count in some cases if an index is available, not that it caches the actual count.
Not necessarily in postgres. If an index is available it may use that, though it will still have to refer to the visibility map to see if any row is available to the current transaction (cheap check), and if it can't…