On 15.01.2013, at 16:36, Tom Lane <t...@sss.pgh.pa.us> wrote: > "T. E. Lawrence" <t.e.lawre...@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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
