Home > mailing lists

Slow query - Mailing list pgsql-general

From	Nicholas Wieland
Subject	Slow query
Date	August 9, 2012 15:47:39
Msg-id	3D2E85F3-7D39-4C9F-8967-C1C3106128C8@nofeed.org Whole thread Raw
Responses	Re: Slow query ("David Johnston" <polobo@yahoo.com>) Re: Slow query ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List	pgsql-general

Hi, I've tried to post on stackoverflow, but nobody is apparently able to help me.

I'm not going to repeat everything here, there's quite some code in there that is nicely formatted, but if this is a problem I can repost it in here.

What seems incredibly strange to me is that postgres is not using the indexes I've set.

Someone has any idea?

TIA,

ngw

From: Merlin Moncure
Date: 09 August 2012, 13:58:39
Subject: Re: JSON in 9.2: limitations

From: "David Johnston"
Date: 09 August 2012, 16:12:06
Subject: Re: Slow query