Re: reducing number of ANDs speeds up query RESOLVED

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: reducing number of ANDs speeds up query RESOLVED
Дата
Msg-id 25904.1358264185@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: reducing number of ANDs speeds up query RESOLVED  ("T. E. Lawrence" <t.e.lawrence@icloud.com>)
Ответы Re: reducing number of ANDs speeds up query RESOLVED  (Jeff Janes <jeff.janes@gmail.com>)
Re: reducing number of ANDs speeds up query RESOLVED  ("T. E. Lawrence" <t.e.lawrence@icloud.com>)
Список pgsql-general
"T. E. Lawrence" <t.e.lawrence@icloud.com> <CAMkU=1y6UuxPYbf_ky8DVDsJi=g=uQ1t0B6kwLEtdc7NLxB_-Q@mail.gmail.com> writes:
> On 15.01.2013, at 05:45, Jeff Janes <jeff.janes@gmail.com> wrote:
>>> Is the autovacuum 100% reliable in relation to VACUUM ANALYZE?

>> No.  For example, if you constantly do things that need an access exclusive lock, then autovac will keep getting
interruptedand never finish. 

> I see.

> So, apparently, we need to interrupt the heavy imports on some reasonable intervals and do manual VACUUM ANALYZE?

Data import as such, no matter how "heavy", shouldn't be a problem.
The question is what are you doing that takes access-exclusive table
locks frequently, and do you really need to do that?

A quick look at the docs suggests that ALTER TABLE, REINDEX, or CLUSTER
would be the most likely candidates for taking exclusive table locks.

            regards, tom lane


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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Linux Distribution Preferences?
Следующее
От: ning chan
Дата:
Сообщение: Re: Streaming Replication