Postgres Pro
Downloads
Home   >   mailing lists

General query optimization howto - Mailing list pgsql-general

From Miroslav Šulc
Subject General query optimization howto
Date
Msg-id 42339897.40504@startnet.cz
Whole thread Raw
Responses Re: General query optimization howto  (Peter Eisentraut <peter_e@gmx.net>)
Re: General query optimization howto  (Ragnar Hafstað <gnari@simnet.is>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Mike Rylander
Date:
Subject: Re: partitionning
Next
From: Lonni J Friedman
Date:
Subject: Re: postgresql error