Re: Avoid huge perfomance loss on string concatenation

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Avoid huge perfomance loss on string concatenation
Date: 2007-12-06 18:53:34
Message-ID: fj9gld$2o1h$2@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you.
I ran manually analyze command.
After that query runs fast.
I have enabled autovacuum and statitics collection in config file.
Every day a lot of rows are added to dok table.

However it seems that statitics is not collected (autovacuum is not running)

Any idea autovacuum is not running ?

Andrus.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Henrik 2007-12-06 19:11:34 Re: Nested loop in simple query taking long time
Previous Message Gauthier, Dave 2007-12-06 18:52:30 Re: reformatting floats ?