Category: tech

AWS size flexible - normalization factor table

I always forget where to find the AWS normalization factor table for flexible-size RI. The simple url is https://frankcontrepois.com/rinormalization So here it is: Instance size Normalization factor nano 0.25 micro 0.5 small 1 medium 2 large 4 xlarge 8 2xlarge 16 4xlarge 32 8xlarge 64 10xlarge 80 16xlarge 128 32xlarge 256 Read more...

How to find if an AWS instance is spot

I was expecting this question to be answered in two minutes, while it seems that undertanding if an instance is spot well documented. So here is my very short version In the EC2 Console search for the lifecycle field. Read more...

Get NOW in Postgresql

SELECT CURRENT_TIME; Result: 14:39:53.662522-05 SELECT CURRENT_DATE; Result: 2019-12-23 SELECT CURRENT_TIMESTAMP; Result: 2019-12-23 14:39:53.662522-05 Official Pgsql documentation Read more...

How to change the timezone on Windows 10 when the UI fails

Changing the timezone should not be complicated! There is a nice user interface, with a list of timezones, I pick the one I need, click sync time and … it fails. The old timezone is back and the time on my laptop is wrong! So how to force (in this case brute force works) Windows to change the timezone. Simple we will use powershell Find Powershell and run as Administrator Find the id for your current timezone PS C:\WINDOWS\system32> Get-TimeZone -ListAvailable Read more...