Re: reducing number of ANDs speeds up query RESOLVED - Mailing list pgsql-general

On 15.01.2013, at 16:36, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "T. E. Lawrence" <t.e.lawrence@icloud.com> <CAMkU=1y6UuxPYbf_ky8DVDsJi=g=uQ1t0B6kwLEtdc7NLxB_-
>> 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

Thank you for this.

We will have to research into this, it will take a while.

T.