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

Re: significant slow down with various LIMIT

From: norn <andrey(dot)perliev(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: significant slow down with various LIMIT
Date: 2010-04-21 15:40:42
Message-ID: e3368ad6-8a61-4671-bff0-fe4a003d4e65@z7g2000yqb.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Apr 21, 9:52 pm, Kevin(dot)Gritt(dot)(dot)(dot)(at)wicourts(dot)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.

In response to

pgsql-performance by date

Next:From: Nikolas EverettDate: 2010-04-21 15:43:52
Subject: Re: SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: [PERFORM] Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
Previous:From: Tom LaneDate: 2010-04-21 15:30:26
Subject: Re: SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: [PERFORM] Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set

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