| From: | "Hartman, Matthew" <Matthew(dot)Hartman(at)krcc(dot)on(dot)ca> |
|---|---|
| To: | "Simon Riggs" <simon(at)2ndQuadrant(dot)com> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Speeding up a query. |
| Date: | 2009-07-07 12:32:58 |
| Message-ID: | 366642367C5B354197A1E0D27BC175BD02259847@KGHMAIL.KGH.ON.CA |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> From: Simon Riggs [mailto:simon(at)2ndQuadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2009-07-07 13:40:22 | Re: Bundling postgreSQL with my Java application |
| Previous Message | Simon Riggs | 2009-07-07 09:38:58 | Re: Speeding up a query. |