Re: restore time: sort_mem vs. checkpoing_segments - Mailing list pgsql-performance

Vivek,

> And the winner is... checkpoint_segments.
>
> Restore of a significanly big database (~19.8GB restored) shows nearly
> no time difference depending on sort_mem when checkpoint_segments is
> large.  There are quite a number of tables and indexes.  The restore
> was done from a pg_dump -Fc dump of one database.

Cool!   Thank you for posting this.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco