On 15.01.2013, at 16:36, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > "T. E. Lawrence" <t.e.lawrence@xxxxxxxxxx> <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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
