Hai Tom,
Your answer on my 7.0 version solved it I changed configure:
# Create compiler version string
if test x$GCC = xyes ; then
! cc_string=GCC `${CC} --version`
else
cc_string=$CC
fi
cat confdefs.h EOF
#define PG_VERSION_STR PostgreSQL $VERSION on $host, compiled by $ccstring
EOF
Line 3
How to config log file to log statement without CONTEXT stuff?
I want log query, but not the detail unless there is a problem, e.g.
Delete aaa from mytable where mysqlfunction(bbb);
I want log this statement, but not any CONTEXT inside mysqlfunction,
because it will easily filled up my disk if
Hello pgsql-admin,
Are there jobs in PostgreSQL? Or tasks?
I saw the pgjobs but it didn't seem active or even finished.
If not, how do you implement them externally? I guess one could
write some sort of mechanism with PHP and an external scheduler of
the OS.
Regards,
Vitaly Belman
I would recommend trying out several stripe sizes, and making your own
measurements.
A while ago I was involved in building a data warehouse system (Oracle,
DB2) and after several file and db benchmark exercises we used 256K
stripes, as these gave the best overall performance results for both