From: | Jay Riddle <jcriddle4(at)yahoo(dot)com> |
---|---|
To: | 康桥 <kbridge(at)126(dot)com>, "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
Subject: | Re: initdb and CREATE DATABASE take TOO MUCH time on Win7 |
Date: | 2018-08-06 13:31:21 |
Message-ID: | 351735032.2648829.1533562281871@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
A complete guess on my part but maybe anti-virus software scanning the files as they are being written?
From: 康桥 <kbridge(at)126(dot)com>
To: pgsql-novice(at)lists(dot)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Dewhirst | 2018-08-20 11:21:08 | Switching from 9.1 to 9.5 on Ubuntu 16.04 |
Previous Message | 康桥 | 2018-08-06 07:39:57 | initdb and CREATE DATABASE take TOO MUCH time on Win7 |