Re: How to best use 32 15k.7 300GB drives? - Mailing list pgsql-performance

From Stephen Frost
Subject Re: How to best use 32 15k.7 300GB drives?
Date
Msg-id 20110128172810.GE30352@tamriel.snowman.net
Whole thread Raw
In response to Re: How to best use 32 15k.7 300GB drives?  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: How to best use 32 15k.7 300GB drives?
List pgsql-performance
* Scott Marlowe (scott.marlowe@gmail.com) wrote:
> There's nothing wrong with whole table updates as part of an import
> process, you just have to know to "clean up" after you're done, and
> regular vacuum can't fix this issue, only vacuum full or reindex or
> cluster.

Just to share my experiences- I've found that creating a new table and
inserting into it is actually faster than doing full-table updates, if
that's an option for you.

    Thanks,

        Stephen

Attachment

pgsql-performance by date:

Previous
From: Stephen Frost
Date:
Subject: Re: How to best use 32 15k.7 300GB drives?
Next
From: Scott Carey
Date:
Subject: Re: How to best use 32 15k.7 300GB drives?