[PERFORM] how to improve the performance of creating index

Hi, all I am trying to improve the performance of creating index. I've set shared_buffers = 1024MB Effective_cache_size = 1024MB Work_mem = 1GB Maintenance_work_mem=512MB (I'm sure that the server process h

[PERFORM] zero value in statistics collector's result

Hi, When I use the statistics collector to see the number of IO, I always get zero in almost all of columns. I really want to know the reason for that. The result of statistics view: # select * from pg_statio_user_tables; relid | schemaname | relname | heap_blks_read | heap_blks_hit | id