On 12/10/09 8:41 AM, "Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx> wrote: > > There has been some talk about possibly writing tuples in a frozen > state with the hint bits already set if they are loaded in the same > database transaction which creates the table, but I'm not aware of > anyone currently working on this. > Wow, that would be nice. That would cut in half the time it takes to restore a several TB db (3 days to 1.5 here). I assume this would help a lot of "CREATE TABLE AS SELECT ..." use cases too. That is often the fastest way to do a large update on a table, but it can still be annoyingly write intensive. > -Kevin > > -- > Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
