Skip site navigation (1) Skip section navigation (2)

Re: Optimization support

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 (view raw, whole thread or download thread mbox)
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> ::
19:19 < pg_docbot_adz> ::

> 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.

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°

In response to


pgsql-novice by date

Next:From: David GardnerDate: 2009-01-04 06:44:09
Subject: Re: Optimization support
Previous:From: kulmacet101Date: 2009-01-03 18:05:44
Subject: Optimization support

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group