On Mon, May 13, 2013 at 8:05 AM, S H <msq001@live.com> wrote:
> Hi,
>
> I have my database in which i am executing vacuuming running manually in one
> hour.
vacuum or vacuum full?
> In my production database sometime when vacuuming is running it is taking
> long time in opening connection.
What is the db server doing when this happens? What does top, vmstat,
iostat etc have to say about it?
> My current version is version 8.1. Is there any known issue about open
> connection problem with vacuuming.
8.1 is out of support and has been for some time.
> I found something but i am not sure if it is applicable to V8.1 too?
Tom wrote:
> broken if we start the scan at a random place within the catalog, so
> that
> allowing syncscan is actually a big deoptimization if pg_attribute is
> large
SNIP
> Back-patch to 8.3, where syncscan was introduced.
It was added in 8.3 so no, it is likely not your issue.
Running 8.1 means you're asking about a system no one else on this
list is likely to still be using much. The hackers aren't gonna be
interested in fixing it either, since it's out of support.