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

2002-09-05 Thread Yury Bokhoncovich
nd 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 Bokhoncovi

[HACKERS] btree page merging

2002-09-12 Thread Yury Bokhoncovich
p;a1=1002+Mumps+Language+Research&a2=1011+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. ---

Re: [HACKERS] Default privileges for 7.3

2002-09-24 Thread Yury Bokhoncovich
ed on while loading old dumps? > Comments? 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.

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

2002-09-26 Thread Yury Bokhoncovich
sfully pass thru a few serious crashes on various systems (mostly on power problems). If fsync is on in Pg, performance gets so-oh-oh-oh-oh slowly!=) I just 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 benchmark

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 a

Re: [HACKERS] 7.2.3 patching done

2002-10-01 Thread Yury Bokhoncovich
. 7.2.2->7.2.3, 7.3.0->7.3.1 and so 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

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

2002-10-02 Thread Yury Bokhoncovich
T; Commit complete. --- cut --- > > > > > Any Oracle 9 users out there? > > > > > > > > > > I need this run: > > > > > > > > > > BEGIN; > > > > > SELECT CURRENT_TIMESTAMP; > > &

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

2002-10-06 Thread Yury Bokhoncovich
n|statement|clock") functionality > > I have attached an SGML patch that explains 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 PR

[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