On Mon, 2009-11-30 at 10:50 -0800, Craig James wrote:
> I have a million-row table (two text columns of ~25 characters each plus two
> integers, one of which is PK) that is replaced every week. Since I'm doing
> it on a live system, it's run inside a transaction. This is the only time
> the ta
I have a million-row table (two text columns of ~25 characters each plus two
integers, one of which is PK) that is replaced every week. Since I'm doing it
on a live system, it's run inside a transaction. This is the only time the
table is modified; all other access is read-only.
I wanted to
