btree.
On 2016-04-19 06:53, Jeff Janes wrote:
On Apr 19, 2016 6:37 AM, <rolf@xxxxxxxxxxx> wrote:
We had a server approach wraparound yesterday on a 9.3 box. I
restarted in single user mode and only one table was above
autovacuum_freeze_max_age. The dataset was ~750G. We left vacuum
running for 21hrs and it still did not complete. What was interesting
is that disk IO graph kept cycling, lots of reads for ~45min, then a
few writes for another 45min.
What kind of indexes were on the table?
Cheers,
Jeff
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
