Thread: Optimization support
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). I am moving from MySQL to Postgres but the queries seem slow almost too slow. Any support appreciated. Thanks in advance, Kulmacet
kulmacet101@kulmacet.com <kulmacet101@kulmacet.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°
As an addition to that, I would recommend pgadmin3's graphical explain tool, the diagrams it generates are (in my opinion) fantastic and help me quickly spot problems in my schema/query. Also take a look at: http://www.postgresql.org/docs/8.3/static/kernel-resources.html in regards to SHMMAX in Linux you should be able to check your current setting by doing: cat /proc/sys/kernel/shmmax Did you vacuum and analyze the database tables? >> Any support appreciated. >> > > Use 'explain analyse <your query>' to get the execution plan. > > > Andreas > -- David Gardner