Re: Unexplainable slow down...

> -----Original Message-----
> From: Stephan Szabo [mailto:sszabo(at)megazone23(dot)bigpanda(dot)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