FillFactor for UPDATE

What is FillFactor in PostgreSQL? As per offical Doc -- fillfactor (integer) The fillfactor for a table is a percentage between 10 and 100. 100 (complete packing) is the default. When a smaller fillfactor is specified, INSERT operations pack table pages only to the indicated percentage; the remaining space on each page is reserved for … Continue reading FillFactor for UPDATE


S3 Bucket – IllegalLocationConstraintException

A quick one !! Creating bucket failed with "IllegalLocationConstraintException" -- [ec2-user@ip-172-31-33-128 ~]$ aws s3api create-bucket --bucket labtestrand --region us-west-2 An error occurred (IllegalLocationConstraintException) when calling the CreateBucket operation: The unspecified location constraint is incompatible for the region specific endpoint this request was sent to. Solution -- [ec2-user@ip-172-31-33-128 ~]$ [ec2-user@ip-172-31-33-128 ~]$ aws s3api create-bucket --bucket labtestrand … Continue reading S3 Bucket – IllegalLocationConstraintException