September 18, 2018

Dynamic profiles are central to the field specialization process. Runtime profiles are used in the first five steps in the Field Specialization process to identify attractive specialization opportunities, by successively narrowing down the scope to individual functions or...

September 11, 2018

Field specialization has two especially helpful attributes. First, specializations are reusable across queries. Second, specializations are independent of each other.

A specialization is applied to a specific hotspot revealed by dynamic analysis tools that collect informat...

September 11, 2018

Field specialization applies to hotspots at the routine level and sometimes even to short code segments within a routine. As an example, field specialization could be applied to a particular hot loop, minimizing the code changes required. Further, specialization can be ap...

September 11, 2018

This is like a koan: the performance benefits from field specialization are simultaneously independent of workloads used to generate that specialization and intimately aware of details of the workload it is speeding up.

Recall that field specialization generates, at compil...

September 4, 2018

While working with our customers, one common question we receive is the following: Is field specialization applied once and will it potentially cease to improve performance? Another:  We have done optimizations ourselves; what else can field specialization provide?

The hon...

August 30, 2018

As we work with our customers on their ever-evolving code bases, we find that new features and components added to these code bases often bring more specialization opportunities.

Our own experience on PostgreSQL supports this observation.

As an example, PostgreSQL 9.6 intro...

August 29, 2018

We have developed many types of specialization techniques, in three basic categories:

  • Some eliminate unnecessary instruction execution at runtime

  • Some minimize instruction cache pressure, and

  • Some reduce memory access overheads for data-intensive computation.


August 28, 2018

The first step of applying field specialization is to look for runtime hotspots with profiling tools. Once field specialization is applied to address the top few hotspot routines, their overhead typically will reduce significantly. Then we can start the field specializati...

August 28, 2018

Field specialization and cloud applications go well together, in four advantageous ways....

August 27, 2018

Recall that a spiff is code added to the DBMS source that, given values of invariants known in cold code, generate specialized code (termed “speccode”) that will be called in hot code when the query is executed. How big are they?...

Please reload

Recent Posts
Please reload

Please reload

Search By Tags
Please reload

Follow Us
  • Twitter Basic Square
  • LinkedIn Social Icon

© Dataware Ventures, LLC / T 520.490.4843 /      designed and powered by BlueDream

  • LinkedIn Round
  • Twitter Round