Date: Mon, 8 Jan 2007 10:51:18 +0300 From: "Abdullah Al-Marrie" <almarrie@gmail.com> To: "Ivan Voras" <ivoras@fer.hr> Cc: freebsd-questions@freebsd.org Subject: Re: Tuning PostgreSQL for bulk imports Message-ID: <499c70c0701072351k114119e5kc4d9864fcc651cd7@mail.gmail.com> In-Reply-To: <enrnt5$9h6$1@sea.gmane.org> References: <200701071301.27423.kirk@strauser.com> <enrnt5$9h6$1@sea.gmane.org>
next in thread | previous in thread | raw e-mail | index | archive | help
Kirk Strauser wrote: > I have an hourly job that converts our legacy Foxpro database into > PostgreSQL tables so that our web applications, etc. can run reports off > the data in a reasonable amount of time. Believe it or not, this has been > running perfectly in production for over a year. The only problem I'd > still like to solve is that loading the data pegs the filesystem at 100% > for many minutes at a time. Why did you choose PostgreSQL over MySQL 5.0.x? Is the latest PostgreSQL release performance much better than MySQL 5.0.x in RELENG_6 with SMP and 2 GB of ram now? -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?499c70c0701072351k114119e5kc4d9864fcc651cd7>