From: | Vivek Khera <khera(at)kcilink(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: syslog slowing the database? |
Date: | 2004-03-10 21:00:36 |
Message-ID: | x78yi876yz.fsf@yertle.int.kciLink.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-performance |
>>>>> "GS" == Greg Spiegelberg <gspiegelberg(at)cranel(dot)com> writes:
GS> I've been waiting all day for a pg_restore to finish on a test system
GS> identically configured as our production in hardware and software
GS> with the exception prod is 7.3.5 and test is 7.4.1.
GS> The file it's restoring from is about 8GB uncompressed from a
GS> "pg_dump -b -F t" and after 2 hours the directory the database is in
GS> contains only 1GB. iostat reported ~2000 blocks written every 2
GS> seconds to the DB file system.
Have you considered increasing the value of checkpoint_segments to
something like 50 or 100 during your restore? It made a *dramatic*
improvement on my system when I did the same migration.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2004-03-11 01:34:54 | Re: [PERFORM] syslog slowing the database? |
Previous Message | Sam Barnett-Cormack | 2004-03-10 19:31:15 | Re: EPOCH time vs PG timestamp |
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff | 2004-03-10 23:21:43 | Re: compiling 7.4.1 on Solaris 9 |
Previous Message | Mark Harrison | 2004-03-10 19:08:50 | Re: syslog slowing the database? |