[Bizgres-general] Statement Queuing take II - Resource Scheduling
Mark Kirkwood
mkirkwood at greenplum.com
Sun Jun 18 02:07:49 UTC 2006
Josh Berkus wrote:
> Mark,
>
>
>> I was not thinking of amending the client protocol - the idea being that
>> queuing would be "transparent" to clients (there was the discussion
>> point about whether there should be resource queuing specific timeouts).
>>
>
> It's not going to be very "transparent" if the client has to wait, frozen, for
> 10 minutes while the queue clears.
>
>
(chuckles) - sure no-one likes to wait, but for DSS type queries there
is usually waiting involved anyway. In addition the aim of resource
scheduling is to improve the throughput by utilizing the available
resources more carefully, so on average there should be less waiting.
I do agree that being able to send a "query is queued" client message
type would be good, but the level of impact on existing client
libraries/drivers makes that not so nice.
Cheers
Mark
More information about the Bizgres-general
mailing list