Caching systems and methods

A system comprising:

• a memory;
• and
• a processing device operatively coupled to the memory, the processing device to:
• receive a set of queries to be processed by a set of virtual warehouses, wherein each virtual warehouse of the set of virtual warehouses includes a first set of processors and cache resources corresponding to the first set of processors;
• distribute, by a second set of processors, the set of queries to the set of virtual warehouses to be executed by the first set of processors;
• create, during the processing of the set of queries by the set of virtual warehouses, a new virtual warehouse, wherein:
• cache resources associated with the new virtual warehouse are populated with data files associated with the set of queries at a time the virtual warehouse is created;
• and
• the cache resources vary among the first set of processors, wherein a first subset of the first set of processors comprises minimal cache resources and a second subset of the first set of processors comprises cache resources providing faster input-output operations;
• and
• redistribute, as a result of the creating, the set of queries across the set of virtual warehouses.

A non-transitory computer-readable medium having instructions stored thereon that, when executed by a processing device, cause the processing device to:

• receive a set of queries to be processed by a set of virtual warehouses, wherein each virtual warehouse of the set of virtual warehouses includes a first set of processors and cache resources corresponding to the first set of processors;
• distribute, by a second set of processors, the set of queries to the set of virtual warehouses to be executed by the first set of processors;
• create, during the processing of the set of queries by the set of virtual warehouses, a new virtual warehouse, wherein:
• cache resources associated with the new virtual warehouse are populated with data files associated with the set of queries at a time the virtual warehouse is created;
• and
• the cache resources vary among the first set of processors, wherein a first subset of the first set of processors comprises minimal cache resources and a second subset of the first set of processors comprises cache resources providing faster input-output operations;
• and
• redistribute, as a result of the creating, the set of queries across the set of virtual warehouses.