A Study on SSD Aware Scan Operation Optimization in PostgreSQL Database

Simple item page
dc.contributor.authorNakandala, S
dc.contributor.authorWithana, S
dc.contributor.authorKumarasiri, D
dc.contributor.authorJayawardena, H
dc.date.accessioned2017-12-15T00:44:40Z
dc.date.available2017-12-15T00:44:40Z
dc.description.abstractCost functions used by query optimizers in database systems are built around the properties of conventional hardware technologies like spin type hard disk drives. But with the rapid development in storage technology several new technologies have emerged to overcome the limitations in conventional storage media. One such storage technology is flash storage type which belongs to the broader category of SSDs (Solid State Devices). In this paper we discuss a study done to optimize scan operation performance in PostgreSQL database running on flash storage media by changing the random block transfer cost parameter to a suitable value.en_US
dc.identifier.conferenceITRU RESEARCH SYMPOSIUMen_US
dc.identifier.departmentDepartment of Computer Science & Engineeringen_US
dc.identifier.emailsupun.10@cse.mrt.ac.lken_US
dc.identifier.emailsachith.10@cse.mrt.ac.lken_US
dc.identifier.emailhirantha.10@cse.mrt.ac.lken_US
dc.identifier.facultyEngineeringen_US
dc.identifier.pgnos16-19en_US
dc.identifier.placeUNIVERSITY OF MORATUWAen_US
dc.identifier.urihttp://dl.lib.mrt.ac.lk/handle/123/12939
dc.identifier.year2014en_US
dc.language.isoenen_US
dc.titleA Study on SSD Aware Scan Operation Optimization in PostgreSQL Databaseen_US
dc.typeConference-Full-texten_US

Files

Collections

ITRU - 2014