On 11/22/11 7:52 AM, Andrew Sullivan wrote:
But I think performance on that table is going to be pretty bad. I suspect that COPY is going to be your friend here.
indeed. 20M rows/hour is 5500 rows/second. you'd better have a seriously fast disk system, say, 20 15k RPM SAS drives in a RAID10 with a decent SAS raid controller that has 1GB of writeback battery-or-flash backed cache.
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general