Re: Speeding up a query. - Mailing list pgsql-performance

From Hartman, Matthew
Subject Re: Speeding up a query.
Date
Msg-id 366642367C5B354197A1E0D27BC175BD02259847@KGHMAIL.KGH.ON.CA
Whole thread Raw
In response to Re: Speeding up a query.  (Simon Riggs <simon@2ndQuadrant.com>)
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Speeding up a query.
Next
From: "Kevin Grittner"
Date:
Subject: Re: Bundling postgreSQL with my Java application