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

Re: Help with optimizing query

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "Marek Lewczuk" <newsy(at)lewczuk(dot)com>,"Lista dyskusyjna pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Help with optimizing query
Date: 2004-08-20 20:32:33
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
If you supply the following:

1. The schema (including available indexes) for each table in the query
2. The actual query
3. The row counts for the tables via select count(*)

I suspect that someone can formulate a query that is as fast as you

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org 
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Marek Lewczuk
> Sent: Friday, August 20, 2004 2:01 AM
> To: Lista dyskusyjna pgsql-general
> Subject: [GENERAL] Help with optimizing query
> Hello,
> I have a query, which is quite big and there is a huge difference 
> between execution time in MySQL and PostgreSQL. I think that 
> I have made 
> all possible steps to increase the speed of the query, but 
> unfortunately 
>   it is still about 100 times slower. I'm out of ideas what 
> to do next, 
> so maybe you will point me what shall I do. In the attachment 
> I send you 
> the result of "explain analyze".
> I will be appreciated for any help. Thanks in advance.
> ML

pgsql-general by date

Next:From: Thomas F.O'ConnellDate: 2004-08-20 20:41:40
Subject: Cross-datatype Comparisons and Indexes
Previous:From: Joe LesterDate: 2004-08-20 20:27:07
Subject: Re: Postgres filling up hard drive with swap files

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