Re: [HACKERS] [SQL] [GENERAL] CURRENT_TIMESTAMP

2002-10-06 Thread Yury Bokhoncovich
the issues with CURRENT_TIMESTAMP in more detail. -- WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group. Phone: +7 (3832) 106228, ext.140, E-mail: [EMAIL PROTECTED] Unix is like a wigwam -- no Gates, no Windows, and an Apache inside. ---(end

Re: [HACKERS] (Fwd) Re: Any Oracle 9 users? A test please...

2002-10-02 Thread Yury Bokhoncovich
users out there? I need this run: BEGIN; SELECT CURRENT_TIMESTAMP; -- wait 5 seconds SELECT CURRENT_TIMESTAMP; Are those two timestamps the same? -- WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group

Re: [HACKERS] 7.2.3 patching done

2002-10-01 Thread Yury Bokhoncovich
Hello! BTW, is it possible to have just patch against previous version (to reduce traffic and CPU)? I.e. something like 7.2.2-7.2.3.diff.gz? -- WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group. Phone: +7 (3832) 106228, ext.140, E-mail: [EMAIL PROTECTED] Unix is like

Re: [HACKERS] 7.2.3 patching done

2002-10-01 Thread Yury Bokhoncovich
on). BTW, I had no problems with patching Linux kernel this way (e.g. having vanilla 2.2.16 then sequentially patch for 2.2.17, .18, .19, .20, .21, .22) though there were added directories. -- WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group. Phone: +7 (3832) 106228, ext.140

Re: [HACKERS] [GENERAL] Performance while loading data and indexing

2002-09-26 Thread Yury Bokhoncovich
have done upgrade from 2.2 kernel on ext2 to ext3 capable 2.4 one so I'm planning to do some benchmarking. Roughly saying w/o benchmarks, the performance have been degraded in 2/3 proportion. But better safe then sorry. -- WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group

Re: [HACKERS] Default privileges for 7.3

2002-09-24 Thread Yury Bokhoncovich
? That seems to be more reasonable. -- WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group. Phone: +7 (3832) 106228, ext.140, E-mail: [EMAIL PROTECTED] Unix is like a wigwam -- no Gates, no Windows, and an Apache inside. ---(end of broadcast

[HACKERS] btree page merging

2002-09-12 Thread Yury Bokhoncovich
+The+Mumps+Language -- WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group. Phone: +7 (3832) 106228, ext.140, E-mail: [EMAIL PROTECTED] Unix is like a wigwam -- no Gates, no Windows, and an Apache inside. ---(end of broadcast

Re: [HACKERS] [PATCHES] Big number of unused pages as reported by

2002-09-06 Thread Yury Bokhoncovich
---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html Yep! Suggest to add this as well as that typical mistake with LANGUAGE/HANDLER (plpgsql.so I mean).:-) -- WBR, Yury

[HACKERS] parse_datestyle_internal always return TRUE

2002-03-20 Thread Yury Bokhoncovich
Hello! Does anybody know a reason parse_datestyle_internal always returns TRUE? -- WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group. Phone: +7 (3832) 106228, ext.140, E-mail: [EMAIL PROTECTED] Unix is like a wigwam -- no Gates, no Windows, and an Apache inside

[HACKERS] Changing constant in src/include/miscadmin.h

2002-03-20 Thread Yury Bokhoncovich
/commands/variable.c) in this way: datestyle=0; if () datestyle=USE_xxx ... if (!datestyle) elog(ERROR -- WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group. Phone: +7 (3832) 106228, ext.140, E-mail: [EMAIL PROTECTED] Unix is like a wigwam -- no Gates, no Windows, and an Apache