Re: Query runs 38 seconds for small database!

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: Query runs 38 seconds for small database!
Дата
Msg-id e3nvmo$181j$1@news.hub.org
обсуждение исходный текст
Ответ на Query runs 38 seconds for small database!  ("Andrus" <eetasoft@online.ee>)
Ответы Re: Query runs 38 seconds for small database!  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список 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.



В списке pgsql-performance по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: performance question (something to do w/ parameterized stmts?, wrong index types?)
Следующее
От: Mark Lewis
Дата:
Сообщение: Re: performance question (something to do w/