Re: vacuum, performance, and MVCC - Mailing list pgsql-hackers

From Luke Lonergan
Subject Re: vacuum, performance, and MVCC
Date
Msg-id 3E37B936B592014B978C4415F90D662D039896E2@MI8NYCMAIL06.Mi8.com
Whole thread Raw
In response to vacuum, performance, and MVCC  ("Mark Woodward" <pgsql@mohawksoft.com>)
List pgsql-hackers
Csaba,

> Regularly clustering is out of question as it would render
> the system unusable for hours. There's no "0 activity hour"
> we could use for such stuff. There's always something
> happening, only the overall load is smaller at night...

We are planning to implement a btree organized table, which keeps the
data organized by storing it with the index and using btree insertion to
store the data.  This will make your design more attractive.

- Luke



pgsql-hackers by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: vacuum, performance, and MVCC
Next
From: "William ZHANG"
Date:
Subject: Re: Shared library conflicts