> From: Simon Riggs [mailto:simon@xxxxxxxxxxxxxxx] > 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance