Re: Query runs 38 seconds for small database!

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query runs 38 seconds for small database!
Date: 2006-05-08 17:36:42
Message-ID: e3nvmo$181j$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> BTW, you might want to cut all the autovac thresholds in half; that's
> what I typically do.

I added ANALYZE command to my procedure which creates and loads data to
postgres database
from other DBMS. This runs only onvce after installing my application. I
hope this is sufficient.
If default threshold is so conservative values I expect there is some reason
for it.

Andrus.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-05-08 17:38:12 Re: performance question (something to do w/ parameterized stmts?, wrong index types?)
Previous Message Jim C. Nasby 2006-05-08 17:30:56 Re: Memory and/or cache issues?