Re: Unexplainable slow down...

> -----Original Message-----
> From: Stephan Szabo [mailto:sszabo@megazone23.bigpanda.com]
> > Limit  (cost=0.00..833.71 rows=15 width=426)
> >   ->  Seq Scan on builds  (cost=0.00..123873.38 rows=2229 width=426)
> >
> > EXPLAIN
>
> What's the explain for limit 14? And what if you set
> enable_seqscan=off?

The explain for limit 14 was the same (except that rows=14).  I know I can
disable seqscan in the .conf file-- is there a way that I can turn that off
in the psql client?  (It's a production database and they (the users) have
about 300 client connections that don't handle disconnections very well.)

We did increase shared_buffers from 1024 to 8096, but it doesn't seem to
have helped.

>
> Some of these indices seem obvious others I'm not sure what
> they're supposed to cover.
>

I agree, unfortunately I don't have a lot of information about the indices.

Thanks for taking a look.

-ron