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 [EMAIL PROTECTED] 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?" _______________________________________________ freebsd-performance@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "[EMAIL PROTECTED]"