General query optimization howto

From: Miroslav Šulc <miroslav(dot)sulc(at)startnet(dot)cz>
To: PGSQL mailing list <pgsql-general(at)postgresql(dot)org>
Subject: General query optimization howto
Date: 2005-03-13 01:34:15
Message-ID: 42339897.40504@startnet.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

is there on the net any general howto on SQL query optimizations? We
have recently moved our project from MySQL to PostgreSQL and are having
problem with one of our queries. The EXPLAIN command is surely useful
but I don't know how to read it and how to use the output to optimize
the query so I'm looking for some intro that could help me.

--
Miroslav Šulc

Attachment Content-Type Size
miroslav.sulc.vcf text/x-vcard 387 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lonni J Friedman 2005-03-13 02:19:51 Re: postgresql error
Previous Message Mike Rylander 2005-03-13 00:58:22 Re: partitionning