Re: [GENERAL] Safe to kill idle connections?

2005-10-17 Thread Thomas Beutin
Francisco Reyes wrote: Ever since I installed a particular program, PHPWiki, I am seeing idle postgres sessions.. even days old. Is it safe to delete them? I wouln't do that. These seems to be php persistent connections, and they are idle for the moment but reused for new wiki requests. http://

Re: [GENERAL] Oracle buys Innobase

2005-10-15 Thread Thomas Beutin
CSN wrote: There are some articles on eweek about this: Oracle Finds the Flaw in MySQL's Business Plan http://www.eweek.com/article2/0,1895,1869989,00.asp "This is what Oracle says in its release: "InnoDB's contractual relationship with MySQL comes up for renewal next year. Oracle fully expects

[GENERAL] ORDER BY problem

2004-03-01 Thread Thomas Beutin
the first; but line 7 is in the correct place compared to lines 2-6. Has anybody any hint for me to resolve the problem? Any help is greatly appreciated. -tb -- Thomas Beutin [EMAIL PROTECTED] Beam me up, Scotty. There is no intelligent live down in Redmond

Re: [GENERAL] Slow Performance with 7.4.1

2004-01-05 Thread Thomas Beutin
ng the proper module or compiling this into Your kernel. Hope this helps. Greetings, -tb -- Thomas Beutin [EMAIL PROTECTED] Beam me up, Scotty. There is no intelligent live down in Redmond. ---(end of broadcast)--- TIP 2: y

[GENERAL] left outer join terrible slow compared to inner join

2003-08-28 Thread Thomas Beutin
rodukt_a_id_idx on o_produkt (cost=0.00..17.83 rows=1 width=68) (actual time=0.29..0.65 rows=11 loops=1) -> Index Scan using o_kat_prod_p_id_idx on o_kat_prod (cost=0.00..17.42 rows=5 width=170) (actual time=0.16..0.24 rows=4 loops=11) Total runtime: 7.96 msec Do i've any c

Re: [GENERAL] PostGreSQL - Accessing It

2003-08-14 Thread Thomas Beutin
sage > "authentication failed for user 'postgres'". The administrator's manual > confirms that I first need to connect as this predefined user, but > doesn't say what that user's password is. Did You tried "su - postgres" as root? T

[GENERAL] german tsearch in 7.2.4

2003-07-22 Thread Thomas Beutin
version of tsearch at the same time in the same database? Any help welcome! Thanks in advance, -tb -- Thomas Beutin [EMAIL PROTECTED] Beam me up, Scotty. There is no intelligent live down in Redmond. ---(end of broadcast