Re: Need to increase performance of a query
| От | Anne Rosset |
|---|---|
| Тема | Re: Need to increase performance of a query |
| Дата | |
| Msg-id | 4C11570F.9050209@collab.net обсуждение исходный текст |
| Ответ на | Re: Need to increase performance of a query (Joe Conway) |
| Список | pgsql-performance |
Дерево обсуждения
Need to increase performance of a query
(Anne Rosset,
)
Re: Need to increase performance of a query (Jesper Krogh, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Jochen Erwied, )
Re: Need to increase performance of a query (hubert depesz lubaczewski, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Kenneth Marshall, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Jochen Erwied, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Craig James, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Joe Conway, )
Re: Need to increase performance of a query (Joe Conway, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Joe Conway, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Heikki Linnakangas, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Heikki Linnakangas, )
Re: Need to increase performance of a query (Jesper Krogh, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Jochen Erwied, )
Re: Need to increase performance of a query (hubert depesz lubaczewski, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Kenneth Marshall, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Jochen Erwied, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Craig James, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Joe Conway, )
Re: Need to increase performance of a query (Joe Conway, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Joe Conway, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Heikki Linnakangas, )
Re: Need to increase performance of a query (Anne Rosset, )
Re: Need to increase performance of a query (Heikki Linnakangas, )
Joe Conway wrote: > On 06/10/2010 01:21 PM, Anne Rosset wrote: > >>> >>> >> I tried that and it didn't make any difference. Same query plan. >> > > A little experimentation suggests this might work: > > create index item_rank_project on item_rank(project_id, rank) where > pf_id IS NULL; > > Joe > > Yes it does. Thanks a lot! Anne
В списке pgsql-performance по дате отправления: