Postgres Pro
Downloads
Home   >   mailing lists

Re: significant slow down with various LIMIT - Mailing list pgsql-performance

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

Previous
From: Greg Smith
Date:
Subject: Re: Very high effective_cache_size == worse performance?
Next
From: Robert Haas
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