煌めくどんな星も、君を照らすから - Princever.GitHub.io

Princever's blog

HOME PAGE

Github
Downloads
About
Contact

Princever.github.io

Sharing and enjoying my life!

Category - Database

Report of Parallel Sequence Scan

Abstract

It is a report about a Test of Parallel Seq Scan on PostgreSQL. We tested the performance when number of worker threads is 0, 1, 2, 4, 6, 8, 12, 16, 20, 24. Then we visualize the result with perf and flame graph.

Test of Parallel Sequence Scan

We tried to test the performance of parallel seq scan, a new feature in version 9.6, postgreSQL.

Debug PostgreSQL with GDB

Now let’s talking about debuging postgreSQL with GUN GDB. First we need to be familiar with the basic structure of processes of postgreSQL. Which is shown as the following fugure:

Set up PostgreSQL

Here is the summary of my work during the internship on day 1.

What To Do

The main target is about PostgreSQL, a free and open-source database system. My work is based on following environment:

Site
Archives
Tags

Categories
Operate System
Algorithm and Data Stucture
Database
Android
Embedded System
Linux
Life In ZJU
Learning Japanese
New Life
Unclassified

Social
GitHub

This page was designed by Prince. Welcome to my Github.