Re: [GENERAL] Disk I/O Question

2015-11-10 Thread Adrian Klaver
On 11/10/2015 10:58 AM, tbro wrote: The application is called Nable and is owned by Solarwinds http://www.n-able.com Is it the application that is using Postgres? What would really help is some sort of schematic of how data is flowing through the system and exactly where the hangup is.

Re: [GENERAL] Disk I/O Question

2015-11-10 Thread Joshua D. Drake
On 11/10/2015 10:58 AM, tbro wrote: The application is called Nable and is owned by Solarwinds http://www.n-able.com It is not uncommon for DAS to be much faster than NAS/SAN. JD -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support

Re: [GENERAL] Disk I/O Question

2015-11-10 Thread teeeebro
The application is called Nable and is owned by Solarwinds http://www.n-able.com -- View this message in context: http://postgresql.nabble.com/Disk-I-O-Question-tp5873364p5873428.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing l

Re: [GENERAL] Disk I/O Question

2015-11-10 Thread Adrian Klaver
On 11/10/2015 10:42 AM, tbro wrote: Fair question Let me elaborate. The command was simply to test the speed at which data can be written to disk. Postgre comes into play with the monitoring application itself. Information pertaining to the 5000+ devices being monitored is sent to the mon

Re: [GENERAL] Disk I/O Question

2015-11-10 Thread teeeebro
Fair question Let me elaborate. The command was simply to test the speed at which data can be written to disk. Postgre comes into play with the monitoring application itself. Information pertaining to the 5000+ devices being monitored is sent to the monitoring application and written to the Po

Re: [GENERAL] Disk I/O Question

2015-11-10 Thread Andreas Joseph Krogh
På tirsdag 10. november 2015 kl. 17:23:15, skrev tbro mailto:ter...@esi.net>>: The third party application is locked down and we do not have root access to the server.  We have reached out to them for the version number of PostgreSQL. The application server is a virtual machine (RedHat 6) r

Re: [GENERAL] Disk I/O Question

2015-11-10 Thread Adrian Klaver
On 11/10/2015 08:23 AM, tbro wrote: The third party application is locked down and we do not have root access to the server. We have reached out to them for the version number of PostgreSQL. The application server is a virtual machine (RedHat 6) running on VMware 5.5. This is a stand-alone

Re: [GENERAL] Disk I/O Question

2015-11-10 Thread teeeebro
The third party application is locked down and we do not have root access to the server. We have reached out to them for the version number of PostgreSQL. The application server is a virtual machine (RedHat 6) running on VMware 5.5. This is a stand-alone host server running only the third party

Re: [GENERAL] Disk I/O Question

2015-11-10 Thread Jim Nasby
On 11/10/15 8:34 AM, tbro wrote: What I've read about PostgreSQL is that it's a single-thread disk I/O system where only one read/write operation executes at a time. Definitely false. However... Other databases support asynchronous IO, where the database tries to issue IO requests before

Re: [GENERAL] Disk I/O Question

2015-11-10 Thread Pavel Stehule
2015-11-10 15:34 GMT+01:00 tbro : > Hello - I am new to this forum and know nothing about PostgreSQL. I have > managed Microsoft SQL for 15 years (I know ) > > We have a third party application that uses PostgreSQL for the database > engine. Performance writing to our Dell Compellent SAN i

Re: [GENERAL] Disk I/O Question

2015-11-10 Thread Geoff Winkless
On 10 November 2015 at 14:34, tbro wrote: > We have a third party application that uses PostgreSQL for the database > engine. Performance writing to our Dell Compellent SAN is lacking. > > What I've read about PostgreSQL is that it's a single-thread disk I/O > system > where only one read/wri

Re: [GENERAL] Disk I/O Question

2015-11-10 Thread Adrian Klaver
On 11/10/2015 06:34 AM, tbro wrote: Hello - I am new to this forum and know nothing about PostgreSQL. I have managed Microsoft SQL for 15 years (I know ) We have a third party application that uses PostgreSQL for the database engine. Performance writing to our Dell Compellent SAN is lack

[GENERAL] Disk I/O Question

2015-11-10 Thread teeeebro
Hello - I am new to this forum and know nothing about PostgreSQL. I have managed Microsoft SQL for 15 years (I know ) We have a third party application that uses PostgreSQL for the database engine. Performance writing to our Dell Compellent SAN is lacking. What I've read about PostgreSQL is