May be helpful to add on some memory information to my question: shared_buffers - 250MB work_mem - 75 MB maintenance_work_mem - 100MB max_fsm_pages - 1500000 wal_buffers - 96 checkpoint_segments - 32 And some information on the machine (VMWARE) ipcs -l ------ Shared Memory Limits -------- max number of segments = 4096 max seg size (kbytes) = 4194303 max total shared memory (kbytes) = 1073741824 min seg size (bytes) = 1 This is the only process running on this virtual machine. Thanks, Mark > > I'm running postgres 8.2.5 and I'm running a PITR restore on a > remote machine. > The archived logs are being restored at a rate of about 5 every 3 minutes > I was reading in compressed logs and uncompressing them as they are being > restored. I am now reading in uncompressed logs straight into the restore. > > The restore rate only improved slightly - to the rate of 6 every 3 > minutes. > > Is there something I can do in postgresql.conf or in the shared memory to > get this to move faster? At this rate my recovery will run for days as > I'm > copying WAL logs from my production machine. > > > Thanks > > > > Mark Steben > > Autorevenue > > > > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
