Is PostgreSQL for this?
От
lopezf@adinet.com.uy
Тема
Is PostgreSQL for this?
Дата
Msg-id
25386968.1167238323649.JavaMail.tomcat@fe-ps01
Список
Дерево обсуждения
Is PostgreSQL for this? "lopezf@adinet.com.uy" <lopezf@adinet.com.uy>
Re: Is PostgreSQL for this? Richard Broersma Jr <rabroersma@yahoo.com>
Re: Is PostgreSQL for this? Ron Johnson <ron.l.johnson@cox.net>
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 по дате отправления