Is PostgreSQL for this?
От | lopezf@adinet.com.uy |
---|---|
Тема | Is PostgreSQL for this? |
Дата | |
Msg-id | 25386968.1167238323649.JavaMail.tomcat@fe-ps01 обсуждение исходный текст |
Ответы |
Re: Is PostgreSQL for this?
|
Список | pgsql-general |
Hi everybody, I'm looking for a database system for a SCADA system. The major probles I think it's on performance because the application it's going to poll about 4k variables per second from hardware and has to register the values on the procces table. I heard that PostgreSQL provides a bulk loading mechanism called COPY, which takes tab-delimited or CSV input from a file. Where COPY can be used instead of hundreds or thousands of INSERTS, it can cut execution time. I'm less than a novice so I'll thank any piece of advice. Sorry for my poor english. F.Hi everybody, I'm looking for a database system for a SCADA system. The major probles I think it's on performance because the application it's going to poll about 4k variables per second from hardware and has to register the values on the procces table. I heard that PostgreSQL provides a bulk loading mechanism called COPY, which takes tab-delimited or CSV input from a file. Where COPY can be used instead of hundreds or thousands of INSERTS, it can cut execution time. I'm less than a novice so I'll thank any piece of advice. Sorry for my poor english. F.
В списке pgsql-general по дате отправления: