From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Optimization support |
Date: | 2009-01-03 18:21:25 |
Message-ID: | 20090103182125.GA14990@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
kulmacet101(at)kulmacet(dot)com <kulmacet101(at)kulmacet(dot)com> schrieb:
> I have a Postgresql 8.3.4 server on a VMWare Linux CentOS 4.6 with 896MB RAM.
> I was wondering if anyone knows of documentation or a site that could help
> me optimize this server. This server is a default installation and only
> used for development by me (Only).
There are some links about performance:
19:19 < pg_docbot_adz> For information about 'performance' see:
19:19 < pg_docbot_adz> http://www.depesz.com/index.php/2007/07/05/how-to-insert-data-to-database-as-fast-as-possible/ ::
http://www.postgresql.org/docs/current/static/performance-tips.html :: http://www.revsys.com/writings/postgresql-performance.html
19:19 < pg_docbot_adz> http://www.powerpostgresql.com/Docs :: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
> I am moving from MySQL to Postgres but the queries seem slow almost too slow.
Define 'slow'.
>
> Any support appreciated.
Use 'explain analyse <your query>' to get the execution plan.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
From | Date | Subject | |
---|---|---|---|
Next Message | David Gardner | 2009-01-04 06:44:09 | Re: Optimization support |
Previous Message | kulmacet101 | 2009-01-03 18:05:44 | Optimization support |