Re: Speeding up a query.

Поиск
Список
Период
Сортировка
От Hartman, Matthew
Тема Re: Speeding up a query.
Дата
Msg-id 366642367C5B354197A1E0D27BC175BD02259847@KGHMAIL.KGH.ON.CA
обсуждение исходный текст
Ответ на Re: Speeding up a query.  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-performance
> From: Simon Riggs [mailto:simon@2ndQuadrant.com]
> Sent: Tuesday, July 07, 2009 5:39 AM
>
> Another way would be to arrange all appointments that need odd number
of
> timeslots into pairs so that you have at most one appointment that
needs
> an odd number of timeslots. Then schedule appointments on 10 minute
> boundaries, rounding up their timeslot requirement. (The single odd
> timeslot appointment will always waste 1 timeslot).

Now THAT is an interesting idea. I'll have to play with this in my head
a bit (during really boring meetings) and get back to you. Thanks!

Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital



В списке pgsql-performance по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Speeding up a query.
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Bundling postgreSQL with my Java application