Re: Join slow on "large" tables

From: Josué Maldonado
Subject: Re: Join slow on "large" tables
Date: ,
Msg-id: 40C4FA85.8070205@lamundial.hn
(view: Whole thread, Raw)
In response to: Re: Join slow on "large" tables  (Josh Berkus)
List: pgsql-performance

Tree view

Join slow on "large" tables  (Josué Maldonado, )
 Re: Join slow on "large" tables  (Josh Berkus, )
  Re: Join slow on "large" tables  (Josué Maldonado, )
   Re: Join slow on "large" tables  (Josh Berkus, )
    Re: Join slow on "large" tables  (Josué Maldonado, )
   Re: Join slow on "large" tables  (Tom Lane, )
 Re: Join slow on "large" tables  ("Scott Marlowe", )
  Re: Join slow on "large" tables  (Josué Maldonado, )
   reindex and copy - deadlock?  (Litao Wu, )
    Re: reindex and copy - deadlock?  (Tom Lane, )
     Re: reindex and copy - deadlock?  (Litao Wu, )
      Re: reindex and copy - deadlock?  (Tom Lane, )
       Re: reindex and copy - deadlock?  (Litao Wu, )
        Re: reindex and copy - deadlock?  (Tom Lane, )
         Re: reindex and copy - deadlock?  (Litao Wu, )
          Re: reindex and copy - deadlock?  (Tom Lane, )
           Re: reindex and copy - deadlock?  (Litao Wu, )
            Re: reindex and copy - deadlock?  (Tom Lane, )
           Re: reindex and copy - deadlock?  (Litao Wu, )
            Re: reindex and copy - deadlock?  (Tom Lane, )
             Re: reindex and copy - deadlock?  (Litao Wu, )
              Re: reindex and copy - deadlock?  (Tom Lane, )
               Re: reindex and copy - deadlock?  (Litao Wu, )
                Re: reindex and copy - deadlock?  (Tom Lane, )
                 network address query  (Litao Wu, )
   Re: Join slow on "large" tables  ("Scott Marlowe", )

Josh,

El 07/06/2004 5:21 PM, Josh Berkus en su mensaje escribio:
>
> Huh?   It is not at all the same.   Your index scan is down to 87ms from
> 27,000!   And the total query is down to 16seconds from 47 seconds.   Don't
> you consider that an improvement?

Yes there was an improvement with respect the previus query, but still
16 seconds is too slow for that query. And usually the query takes more
than 10 seconds even with small data sets returned.

Thanks,


--
Sinceramente,
Josué Maldonado.

"La cultura es capaz de descifrar los enigmas en que nos envuelve la vida."


pgsql-performance by date:

From: Tom Lane
Date:
Subject: Re: Join slow on "large" tables
From: Russell Smith
Date:
Subject: Use of Functional Indexs and Planner estimates