Re: High inserting by syslog
От | Joshua D. Drake |
---|---|
Тема | Re: High inserting by syslog |
Дата | |
Msg-id | 1215101029.6936.14.camel@jd-laptop обсуждение исходный текст |
Ответ на | High inserting by syslog ("Valter Douglas Lisbôa Jr." <douglas@trenix.com.br>) |
Ответы |
Re: High inserting by syslog
|
Список | pgsql-general |
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? > > 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
В списке pgsql-general по дате отправления: