April 4th, 2010 by depesz | Tags: backup, charts, ext3, io, iowait, linux, load, postgresql, rm, truncate | 21 comments »
Question from title sounds weird to you? It's just a 'rm backup_filename'? Well. I really wish it was so simple in some cases. One of the servers I'm looking into, there is interesting situation: quite busy database server (2k tps is the ...
February 9th, 2009 by depesz | Tags: backup, parallel, pg84, pg_dump, pg_restore, postgresql, restore | 3 comments »
On 2nd of February Andrew Dunstan committed his patch (with editing by Tom Lane) that: Log Message: ----------- Provide for parallel restoration from a custom format archive. Each data and post-data step is run in a separate worker child (a thread on Windows, a ...
