Postgres Pro
Downloads
Home   >   mailing lists

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

From norn
Subject Re: significant slow down with various LIMIT
Date
Msg-id e3368ad6-8a61-4671-bff0-fe4a003d4e65@z7g2000yqb.googlegroups.com
Whole thread Raw
In response to Re: significant slow down with various LIMIT  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
Tree view 
On Apr 21, 9:52 pm, Kevin.Gritt...@wicourts.gov ("Kevin Grittner")
wrote:
> 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;


Yeah, I noticed it and ran correctly.

pgsql-performance by date:

Previous
From: norn
Date:
Subject: Re: significant slow down with various LIMIT
Next
From: Robert Haas
Date:
Subject: Re: autovacuum strategy / parameters