Re: significant slow down with various LIMIT

From: Kevin Grittner
Subject: Re: significant slow down with various LIMIT
Date: ,
Msg-id: 4BCEBCE70200002500030C3F@gw.wicourts.gov
(view: Whole thread, Raw)
In response to: Re: significant slow down with various LIMIT  ("Kevin Grittner")
List: pgsql-performance

Tree view

significant slow down with various LIMIT  (Helio Campos Mello de Andrade, )
 Re: significant slow down with various LIMIT  ("Kevin Grittner", )
  Re: significant slow down with various LIMIT  (norn, )
   Re: significant slow down with various LIMIT  ("Kevin Grittner", )
  Re: significant slow down with various LIMIT  (norn, )
   Re: significant slow down with various LIMIT  ("Kevin Grittner", )
    Re: significant slow down with various LIMIT  (Chris Bowlby, )
    Re: significant slow down with various LIMIT  ("Kevin Grittner", )
  Re: significant slow down with various LIMIT  (norn, )
   Re: significant slow down with various LIMIT  ("Kevin Grittner", )
    Re: significant slow down with various LIMIT  ("Kevin Grittner", )
  Re: significant slow down with various LIMIT  (norn, )
  Re: significant slow down with various LIMIT  (norn, )

I wrote:

> ALTER TABLE ALTER plugins_guide_address
>   ALTER COLUMN city_id SET STATISTICS 1000;

One too many ALTERs in there.  Should be:

ALTER TABLE plugins_guide_address
  ALTER COLUMN city_id SET STATISTICS 1000;

-Kevin


pgsql-performance by date:

From: Kris Jurka
Date:
Subject: Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
From: Eliot Gable
Date:
Subject: Replacing Cursors with Temporary Tables