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.
I'd li
On Thursday 03 July 2008, Richard Huxton <[EMAIL PROTECTED]> wrote:
> You might want to partition the table monthly. That will make it easier
> to manage a few years from now.
> http://www.postgresql.org/docs/current/static/ddl-partitioning.html
Definitely pay attention to this point ... it's pret
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 (t
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.
I'd li
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
>
