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 по дате отправления
От: lopezf@adinet.com.uy
Дата:
Сообщение: Is PostgreSQL for this?
От: postgresql.org@tgice.com
Дата:
FAQ