phacai.com

DBT3 creates many indexes: one primary index on the primary key of each table, and the following secondary indexes:
Read more…

Mr. One Coding

First of all, I am using PostgreSQL. The error message looks like this:

ERROR:  missing FROM-clause entry for table "tmp_orderkey1"
LINE 1: delete from lineitem where l_orderkey=tmp_orderkey1.orderkey...

ERROR:  missing FROM-clause entry for table "tmp_orderkey1"
LINE 1: delete from orders where o_orderkey=tmp_orderkey1.orderkey...

Read more…

Mr. One Coding

First of all, this bug may not occur in every environment. I suspect that it has something to do the implementation of C library on your machine, specifically, the implementation of function “strcpy”.
Read more…

Mr. One Coding

We know that every Linux kernel module can accept parameters from command line when it is first loaded, but sometimes we want to change the behavior of a module on the fly, without requiring the module to be removed and inserted again. To achieve this flexibility, we take advantage of the sysfs.
Read more…

Mr. One Coding

check out /proc/kallsyms. You don’t have to be a root to read its content. The normal place “/proc/ksyms” does not exist on my Fedora.
Read more…

Mr. One Coding

As described in the INSTALL file, first run
Read more…

Mr. One Database

I just want to post it here, so I don’t need to compile from source every time:
dbt3-user (pdf)

Mr. One Database

As of version 9.0.4
Read more…

Mr. One Database

1. Change the height (number of rows) of a split window
To increase by 10, type command

:res+10

Read more…

Mr. One Coding

Configuration:
PostgreSQL 9.0.4. memsize/data size = 1/8
Read more…

Mr. One Database