initdb and CREATE DATABASE take TOO MUCH time on Win7

[康桥]

Hi all.

My team is developing a product using PostgreSQL as the database. During testing, the QA group found that on some computers 'initdb' and 'CREATE DATABASE' take much more time than that on others.

For example, on my computer, 'initdb' takes less than 4 seconds on an SSD, 10 seconds on a normal hard disk. 'CREATE DATABASE' takes 0.8s for the SSD database. While on my colleague's computer with similar hardware configuration, 'initdb' takes almost 1.5 _minutes_, and 'CREATE DATABASE' takes 1min 14sec! After finding that, I was totally shocked.

Having tried some googling, but didn't find anything useful. Could anyone give me some ideas?

Environment:
- Windows 7 x64
- P

[Jay Riddle]

A complete guess on my part but maybe anti-virus software scanning the files as they are being written?


From: 康桥 <***@126.com>
To: pgsql-***@lists.postgresql.org
Sent: Monday, August 6, 2018 12:40 AM
Subject: initdb and CREATE DATABASE take TOO MUCH time on Win7

Hi all.

My team is developing a product using PostgreSQL as the database. During testing, the QA group found that on some computers 'initdb' and 'CREATE DATABASE' take much more time than that on others.

For example, on my computer, 'initdb' takes less than 4 seconds on an SSD, 10 seconds on a normal hard disk. 'CREATE DATABASE' takes 0.8s for the SSD database. While on my colleague's computer with similar hardware configuration, 'initdb' takes almost 1.5 _minutes_, and 'CREATE DATABASE' takes 1min 14sec! After finding that, I was totally shocked.

Having tried some googling, but didn't find anything useful. Could anyone give me some ideas?

Environment:
- Windows 7 x64
- PostgreSQL 10.1 x86