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...
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…
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…
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…
As described in the INSTALL file, first run
Read more…
I just want to post it here, so I don’t need to compile from source every time:
dbt3-user (pdf)
1. Change the height (number of rows) of a split window
To increase by 10, type command
:res+10
Configuration:
PostgreSQL 9.0.4. memsize/data size = 1/8
Read more…
For those who didn’t know, DBT2 is an implementation of TPCC benchmark. Following is a list of tables and indexes created:
Read more…
Recent Comments