Peter Eisentraut wrote:
Miroslav ¦ulc wrote:
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.
I doubt that there is a generic documentation on SQL optimization,
beca
Bruce Momjian wrote:
Have you read the FAQ?
Yes, but I have found only some useful information saying when indexes
are not used.
Miroslav Šulc
begin:vcard
fn;quoted-printable:Miroslav =C5=A0ulc
n;quoted-printable:=C5=A0ulc;Miroslav
org:StartNet s.r.o.
adr;quoted-printable;quoted-printable:;;Vrchl
On Sun, 2005-03-13 at 02:34 +0100, Miroslav Šulc wrote:
> 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
Miroslav ¦ulc wrote:
> 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.
I doubt that there is a generic documentation on SQL optimization,
because this heavily depends
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 qu
