Re: [HACKERS] Indexed views?

2004-09-11 Thread Greg Stark
Mischa Sandberg [EMAIL PROTECTED] writes: I take it that it is a very reasonable assumption that only a small proportion of index records are actually invalid (else Yurk why use the index?). That's faulty logic, the percentage of tuples that are valid is entirely independent from the

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

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] 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=enlr=ie=UTF-8selm=cftihc%

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' the

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] 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

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] 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:

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

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

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 'import

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

[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