Some notes about compiling DBT3 (TPC-H)
February 1st, 2012
As described in the INSTALL file, first run
Read more…
Archive
Archive for the ‘Database’ Category
DBT3 (TPC-H) user manual
February 1st, 2012
I just want to post it here, so I don’t need to compile from source every time:
dbt3-user (pdf)
A TPC-H Q21 query plan
November 27th, 2011
Configuration:
PostgreSQL 9.0.4. memsize/data size = 1/8
Read more…
Tables and Indexes created by DBT2
August 25th, 2011
For those who didn’t know, DBT2 is an implementation of TPCC benchmark. Following is a list of tables and indexes created:
Read more…
The overhead size for each tuple in a Postgresql table
August 17th, 2011
A quick take-away message: in version 9.0.4 of Postgresql, every tuple has an overhead of 24 bytes. I think this is mostly the size of OID (object ID).
Read more…
Inside PostgreSQL Shared Memory
August 5th, 2011
postgresql pg_xlog is not strictly a circular buffer
August 4th, 2011
Normally, we think that xlog file is like a circular buffer. We write to the same addresses again and again.
Read more…
How to configure postgresql shared buffer size
August 2nd, 2011
Within file “postgresql.conf”, variable “shared_buffers” decides the size of shared buffer used by postgresql.
Read more…
Error when compiling postgresql
July 27th, 2011
It looks like the following compiling error has something to do pg_class.h
../../../../src/include/catalog/pg_class.h:32: error: expected \u2018)\u2019 before \u2018,\u2019 token
../../../../src/include/catalog/pg_class.h:78: warning: data definition has no type or storage class
../../../../src/include/catalog/pg_class.h:78: warning: type defaults to \u2018int\u2019 in declaration of \u2018FormData_pg_class\u2019
../../../../src/include/catalog/pg_class.h:89: error: expected \u2018=\u2019, \u2018,\u2019, \u2018;\u2019, \u2018asm\u2019 or \u2018__attribute__\u2019 before \u2018*\u2019 token
Recent Comments