[GENERAL] experiences needed - how does Itanium2/1.5GHz(4MB) compare to AMD and Intel CPUs as far as Postgresql is concerned

2006-03-25 Thread Tomaz Borstnar
Hello! First tried some searching around, but did not find anything useful so I gave up and decided to ask here... I am wondering how do pair of 1.5GHz Itanium2(4MB cache) stack up against pair of AMD or Intel server CPUs as far as postgresql performance is concerned? Is it worthy or not? Th

[GENERAL] This locale setting will prevent use of index optimization for LIKE and regexp searches. (sl_SI.ISO_8859-2)

2000-12-27 Thread Tomaz Borstnar
Hello! Installed 7.1beta1, set LC_ALL to sl_SI.ISO_8859-2 and initialized the database with initdb and got this: NOTICE: Initializing database with sl_SI.ISO_8859-2 collation order. This locale setting will prevent use of index optimization for LIKE and regexp searche

Re: [GENERAL] logger: NOTICE: Unrecognized variable query_limit

2000-11-22 Thread Tomaz Borstnar
At 14:09 22.11.00, Havrylyak Roma wrote: >Does anybody know how to fix error (see subject)? I suppose the problem is >in using PSQL (may be old version) but direct SQL command SET QUERY_LIMIT is >not using... Using phorum 3.1.x with pgsql 7.x? There is a bug where phorum doesn't properly pass var

Re: [GENERAL] pg_check 0.1.3 is now Available

2000-10-31 Thread Tomaz Borstnar
framework for building a standalone dumping utility.for migration Should also be used before starting pgsql. Tomaz ---- Tomaz Borstnar <[EMAIL PROTECTED]> "Love is the answer to the final question you ask" - Unknown

[GENERAL] NOTICE: Unrecognized variable query_limit

2000-10-31 Thread Tomaz Borstnar
couldn't find it. Any idea? Thanks in advance. Tomaz p.s. I use pgsql 7.0.2 installed from FreeBSD ports and Phorum 3.1.2. Tomaz Borstnar <[EMAIL PROTECTED]> "Love is the answer to the final question you ask" - Unknown

Re: [GENERAL] psql 7.0.0 beta

2000-03-01 Thread Tomaz Borstnar
; another install on RedHat 6.0 worked without problems. > > I couldn't compile it on FreeBSD 3.3-STABLE and FreeBSD 3.2-STABLE. Tried > > with stock gcc (2.7.2.1a faik) and gcc 2.95.2: Tomaz Borstnar <[EMAIL PROTECTED]> "Love is the answer to the final question you ask" - Unknown

Re: [GENERAL] psql 7.0.0 beta

2000-03-01 Thread Tomaz Borstnar
me(char *datadir); extern char *GetPidFname(void); extern void UnlinkPidFile(void); extern int SetPidFile(pid_t pid); <-- this line is problematic #endif /* MISCADMIN_H */ Tomaz Tomaz Borstnar <[EMAIL PROTECTED]> "Love is the answer to the final question you ask" - Unknown