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?
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? |