Monday, 5 September 2022

Postgresql - Random number generation

update foo set bar = floor(random() * 9 + 1); 

SELECT random(),floor(random() * 9 + 1) LIMIT 10;

select floor(7000000000 + random() * 8999);  

No comments:

Snowflake - Cost Optimization

Reduce auto-suspend to 60 seconds Reduce virtual warehouse size Ensure minimum clusters are set to 1 Consolidate warehouses Separate warehou...