How to prevent vacuum again and again on the unchanged tables?

From: Haifeng Liu <liuhaifeng(at)live(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: How to prevent vacuum again and again on the unchanged tables?
Date: 2013-05-08 04:41:28
Message-ID: BLU0-SMTP10794DFB213526581A52553B9BB0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I noticed postgresql would do vacuum to prevent wraparound of the transaction id, and I also tried to use vacuum freeze, I am not quite sure about freeze, but it seems postgresql will still vacuum the frezzed unchanged tables automatically.

My scenario is, I have a table with daily partitions, those partition table inherits the parent table, with date check. Each day there is tens of millions rows, and old partitions won't be updated, they may be treat as readonly table.

Meanwhile, there is hot-stanby server, we treat it as a readonly db. when we query on that db, we often got version conflict error, even on the old partitions.

Is there any way better to deal this?

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2013-05-08 07:03:30 Re: Installing multiple instances of Postgred on one FreeBSD server
Previous Message Sergey Konoplev 2013-05-08 03:28:46 Re: Best practice to create a read-only user?