Re: [HACKERS] beta1 & beta2 & Windows & heavy load

2004-09-11 Thread Tom Lane
Daniel Schuchardt <[EMAIL PROTECTED]> writes: > is it is known that postgres 8.0 (beta1 and beta2 both same behavoir) > will eat tons of memory on Windows under heavy load? No. I tried setting up a test case with a 64K-row master table, a slave table with the same 64K rows and an ON DELETE CASCA

[HACKERS] beta1 & beta2 & Windows & heavy load

2004-09-11 Thread Daniel Schuchardt
Hi list, is it is known that postgres 8.0 (beta1 and beta2 both same behavoir) will eat tons of memory on Windows under heavy load? Scenario: I have a big delete with about 56000 rows. (DELETE FROM mytable;) There are triggers (after delete) updating 2 or 3 other tables. (there are triggers on t

Re: [HACKERS] x86_64 configure problem

2004-09-11 Thread Gaetano Mendola
Joe Conway wrote: Gaetano Mendola wrote: Joe Conway wrote: I wasn't going to -- python's own docs say I shouldn't need to. From the link above: "the Distutils work just fine with Python 1.5.2, and it is reasonable (and expected to become commonplace) to expect users of Python 1.5.2 to download

Re: [HACKERS] Indexed views?

2004-09-11 Thread Tiago Wright
IMHO, it is worth duplicating the mvcc data to all index entries. To summarize what I understand from this discussion, with the current method: a1 - Index seeks must return invisible tuples because mvcc data is not found in the index. These tuples are eliminated once the data is read from the actu

Re: [HACKERS] x86_64 configure problem

2004-09-11 Thread James William Pye
On Sat, 2004-09-11 at 14:05, Joe Conway wrote: > Perhaps. The first error message seems clear enough to me, but if you > want to send me the necessary distutils test, I can incorporate it. Any > other opinions out there? AC_MSG_CHECKING([for Python distutils module]) if "${PYTHON}" 2>&- -c 'impo

Re: [HACKERS] x86_64 configure problem

2004-09-11 Thread Gaetano Mendola
Joe Conway wrote: Gaetano Mendola wrote: Joe Conway wrote: What version of python comes with RH2.1? 1.5.2 In any case, the online documentation for python suggests that it is reasonable to expect that distutils is already installed (by default for python >= 1.6, and by the user for python 1.5.2)

Re: [HACKERS] x86_64 configure problem

2004-09-11 Thread Joe Conway
Gaetano Mendola wrote: Joe Conway wrote: I wasn't going to -- python's own docs say I shouldn't need to. From the link above: "the Distutils work just fine with Python 1.5.2, and it is reasonable (and expected to become commonplace) to expect users of Python 1.5.2 to download and install the Di

Re: [HACKERS] x86_64 configure problem

2004-09-11 Thread Joe Conway
Gaetano Mendola wrote: Joe Conway wrote: What version of python comes with RH2.1? 1.5.2 In any case, the online documentation for python suggests that it is reasonable to expect that distutils is already installed (by default for python >= 1.6, and by the user for python 1.5.2). See: http://www

Re: [HACKERS] x86_64 configure problem

2004-09-11 Thread Gaetano Mendola
Joe Conway wrote: Gaetano Mendola wrote: Joe Conway wrote: # python -c "from distutils.sysconfig import get_python_lib as f; import os; print os.path.join(f(plat_specific=1,standard_lib=1),'config')" /usr/lib64/python2.3/config Any other proposals? If not, any objections to the attached patch?

Re: [HACKERS] Adding columns in the middle (Was: Developers page is down)

2004-09-11 Thread Gaetano Mendola
Michael Glaesemann wrote: On Sep 4, 2004, at 10:07 PM, Christopher Browne wrote: Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Jaime Casanova) would write: By the way, will be a way in postgresql 8 to add a column in a middle of a table. just curious. What do you mean by "in a middl

Re: [HACKERS] beta 2 crash with unique constraints

2004-09-11 Thread Tom Lane
Daniel Schuchardt <[EMAIL PROTECTED]> writes: > duplicate key violates unique constraint "ferber_rust_params_pkey" > FATAL: block 0 of 1663/19335/476756 is still referenced (local 2) > server closed the connection unexpectedly This is already fixed, but thanks for the report!

Re: [HACKERS] beta2 and blob's

2004-09-11 Thread Tom Lane
Daniel Schuchardt <[EMAIL PROTECTED]> writes: > Hi with beta2 i get > leak:relation "pg_largeobject_loid_pn_index" has refcnt 1 instead of 0 Fixed, thanks. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' th

Re: [HACKERS] Error starting PostgreSQL on Win XP: failed to get token information: 122

2004-09-11 Thread Magnus Hagander
>Hi > >Thanks for PostgreSQL Beta 8.0! > >I try to use the native Win32 build >(http://pgfoundry.org/projects/pginstaller) >(Beta 1) but i get an error during DB startup. > >"failed to get token information: 122" > > >Maybe this is related to >http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&se

Re: [pgsql-hackers-win32] [HACKERS] more dirmod CYGWIN

2004-09-11 Thread Dave Page
-Original Message- From: [EMAIL PROTECTED] on behalf of Tom Lane Sent: Fri 9/10/2004 10:20 PM To: Bruce Momjian Cc: Reini Urban; PostgreSQL-development; PostgreSQL Win32 port list Subject: Re: [pgsql-hackers-win32] [HACKERS] more dirmod CYGWIN > We don't --- apparently the win32 crowd

Re: [HACKERS] Help with check_pqsql PLUGIN!

2004-09-11 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 9 Sep 2004, [koi8-r] ??? ?. wrote: Hello, Hackers! I use Nagios - monitoring system. Can you help, please? I want to compile plugin for Nagios named 'check_pqsql'. Which libraries I need to compile it successful? Thank you. If