High inserting by syslog

Hello all, I have a perl script thats load a entire day squid log to a=20
postgres table. I run it at midnight by cronjob and turns off the indexes=
=20
before do it (turning it on after). The script works fine, but I want
to=20
change this to a diferent approach.

I'd like to insert on the fly the log lines, so long it be generated to
hav=
e=20
the data on-line. But the table has some indexes and the load of lines is=
=20
about 300.000/day, so the average inserting is 3,48/sec. I think this
could=
=20
overload the database server (i did not test yet), so if I want to create
a=
=20
no indexed table to receive the on-line inserting and do a job moving all=
=20
lines to the main indexed table at midnight.

My question is, Does exists a better solution, or this tatic is a good way
=
to=20
do this?

--=20
Valter Douglas Lisb=C3=B4a Jr.
S=C3=B3cio-Diretor
Trenix - IT Solutions
"Nossas Id=C3=A9ias, suas Solu=C3=A7=C3=B5es!"
www.trenix.com.br
contato@[EMAIL PROTECTED]
 +55 19 3402.2957
Cel. +55 19 9183.4244

--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general