Monthly Archives: November 2016

Auto vacuum and analyse larger tables

Postgresql database operations becomes slower if table gets larger. In order to improve the performance, we can configure to auto-vacuum the table for every x inserts/updates/deletes.

Using below settings, a table would be auto vacuumed and analysed every 5,000 inserts, updates, or deletes.

ALTER TABLE mytable SET (autovacuum_vacuum_scale_factor = 0.0);

ALTER TABLE mytable SET (autovacuum_analyze_scale_factor = 0.0);

ALTER TABLE mytable SET (autovacuum_vacuum_threshold = 10000);

 

 

Advertisements

Elon Musk

I came to know about Elon Mush from my manager some time back and starting reading about him . Elon Mush is known for his new inventions, Tesla, contribution towards renewable energy, sustainable energy, solarcity, Zip2, OpenAI, etc…. the list is going on and on….

He is an inspiration to everyone.