On Sep 5, 2005, at 4:39 PM, Rose, Juergen wrote:
I working now for a wile with postgres (7.4), and I have the
impression
that is one of the slowest dbms with which I've aver worked. Can
please
somebody explain to me, why this is the case?
You've given very few details as to your database schema, size, use-
case (e.g, heavy updates, mostly reads), load, hardware, etc. Are you
vacuuming regularly? Have you tuned your database? Have you set your
stats appropriately? With more detail, such as queries (with EXPLAIN
ANALYZE output), you may be able to get some help on the pgsql-
performance list. Without any real information, people aren't going
to be able to help you.
Here are some references that may help. There are more out there as
well. I'm nowhere near an expert on tuning and performance, but these
can get you started.
http://www.powerpostgresql.com/PerfList/
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
Good luck!
Michael Glaesemann
grzm myrealbox com
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
