On Thursday 03 July 2008 13:03:49 Joshua D. Drake wrote: > On Thu, 2008-07-03 at 12:05 -0300, Valter Douglas Lisbôa 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 indexes > > 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 think > > 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 -- Valter Douglas Lisbôa Jr. Sócio-Diretor Trenix - IT Solutions "Nossas Idéias, suas Soluções!" www.trenix.com.br contato@xxxxxxxxxxxxx Tel. +55 19 3402.2957 Cel. +55 19 9183.4244
