On Thursday 03 July 2008 13:03:49 Joshua D. Drake wrote:
> On Thu, 2008-07-03 at 12:05 -0300, Valter Douglas Lisb=C3=B4a Jr. wrote:
> > Hello all, I have a perl script thats load a entire day squid log to a
> > postgres table. I run it at midnight by cronjob and turns off the
index=
es
> > before do it (turning it on after). The script works fine, but I want
to
> > change this to a diferent approach.
>
> Exactly how do you turn off the indexes?
DROP/CREATE
>
> > I'd like to insert on the fly the log lines, so long it be generated
to
> > have the data on-line. But the table has some indexes and the load of
> > lines is about 300.000/day, so the average inserting is 3,48/sec. I
thi=
nk
> > this could overload the database server (i did not test yet), so if I
> > want to create a no indexed table to receive the on-line inserting and
=
do
> > a job moving all lines to the main indexed table at midnight.
> >
> > My question is, Does exists a better solution, or this tatic is a good
> > way to do this?
>
> 300,000 inserts a day isn't that much for any reasonable server.
>
> Sincerely,
>
> Joshua D. Drake
Thanks
--=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
|
