tag:blogger.com,1999:blog-7476449567742726187.post4115620120043630988..comments2023-12-18T12:25:52.296-08:00Comments on Database Soup: Settings for a fast pg_restoreJosh Berkushttp://www.blogger.com/profile/09671139717468724246noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-7476449567742726187.post-24673641877540780522016-11-08T07:39:57.581-08:002016-11-08T07:39:57.581-08:00You will need to take a new snapshot of the databa...You will need to take a new snapshot of the database and start PITR as new.Josh Berkushttps://www.blogger.com/profile/09671139717468724246noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-37217878457126688432016-11-08T07:38:01.607-08:002016-11-08T07:38:01.607-08:00It's to make more main memory available for ca...It's to make more main memory available for caching data and writes to the filesystem.Josh Berkushttps://www.blogger.com/profile/09671139717468724246noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-62198317692907671252016-11-07T19:04:34.171-08:002016-11-07T19:04:34.171-08:00Hey Josh,
What's the advantage of reducing sh...Hey Josh,<br /><br />What's the advantage of reducing shared buffers by half?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-43448167199700185482015-12-08T22:59:10.910-08:002015-12-08T22:59:10.910-08:00I have used all your tips and it worked perfectly....I have used all your tips and it worked perfectly. <br />But I am afraid that after PITR changes(last tip about wal and archive), my replication will not work.<br />Can you say for sure, if after restore I will change to my default options so everything will work?<br /> Anonymoushttps://www.blogger.com/profile/06699462397663744560noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-29919381217206809792015-10-22T16:11:30.137-07:002015-10-22T16:11:30.137-07:00I was able to solve this issue creating multiples ...I was able to solve this issue creating multiples workers, and it took one hour and a half to migrate 1.6T.<br />Anonymoushttps://www.blogger.com/profile/02392093100556031686noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-36173929920011021652015-10-02T14:25:54.762-07:002015-10-02T14:25:54.762-07:00I have multiples databases and want to create just...I have multiples databases and want to create just one database with multiple schemas. I use pg_dump and pg_restore and I added in the setting --jobs=24 since I have 24 cores. Each database is about 6G and I have 100 shards. Each shard takes about 8 minutes doing pg_dupm and pg_restpre after reading your article. Before it took 9.5 each. However, I was wondering if there is another setting of way to speed it up this process? It will be great if it takes 1 min per database. Can londiste be a solution? <br /> Thoughts?Anonymoushttps://www.blogger.com/profile/02392093100556031686noreply@blogger.com