Date: Mon, 22 Aug 2005 20:27:13 -0500 From: "Jim C. Nasby" <decibel@decibel.org> To: Michael VInce <mv@roq.com> Cc: freebsd-performance@freebsd.org, Claus Guttesen <kometen@gmail.com> Subject: Re: changing max_connections in postgresql on FreeBSD 5.4 Message-ID: <20050823012713.GN17203@decibel.org> In-Reply-To: <42F6B4CD.5030703@roq.com> References: <b41c755205080410013348d0f@mail.gmail.com> <42F6B4CD.5030703@roq.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, Aug 08, 2005 at 11:26:37AM +1000, Michael VInce wrote: > Also note that I have a MySQL server with a similar table setup and it > performs a lot better. If you provide example queries that are performing worse than in MySQL along with the output of EXPLAIN ANALYZE on them to the PostgreSQL performance tuning list I'm sure you'd get some help. Include details about your machine configuration and postgresql.conf variables you've changed too. Also, make sure you're actually running MySQL in such a way that it's ACID compliant; it's very easy to configure it so that your data isn't safe at all, which would be an apples-oranges comparison to PostgreSQL. -- Jim C. Nasby, Database Architect decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050823012713.GN17203>