Re: [HACKERS] Huge memory consumption during vacuum (v.8.0)

On Tue, 1 Feb 2005, Tom Lane wrote: Oleg Bartunov writes: I see that pgsql_tmp/ contains files, looks like clustered table. What postmaster is doing if disk usage doesn't changed ? Most likely doing a disk-based merge sort ... so, it uses 'work_mem' as a buffer ? regards,

Re: [HACKERS] FunctionCallN improvement.

Sorry, forgot the compiler version. gcc (GCC) 3.3.4 20040623 (Gentoo Linux 3.3.4-r1, ssp-3.3.2-2, pie-8.7.6) On Wed, 2 Feb 2005 01:12:04 +, Mike Rylander <[EMAIL PROTECTED]> wrote: > On Tue, 01 Feb 2005 16:23:56 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > > a_ogawa <[EMAIL PROTECTED]> writes

Re: [HACKERS] [NOVICE] Last ID Problem

> With a default to return the primary key? Of course, that would be ideal ... :) ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] [NOVICE] Last ID Problem

> No one has stated that they will disappear. Ohh,... just the impression I've been getting when speaking with people. ... John ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] FunctionCallN improvement.

On Tue, 01 Feb 2005 16:23:56 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > a_ogawa <[EMAIL PROTECTED]> writes: > > I made the test program to measure the effect of this macro. > > Well, if we're going to be tense about this, let's actually be tense > about it. Your test program isn't a great model

Re: [HACKERS] [NOVICE] Last ID Problem

On Tue, 2005-02-01 at 17:50 -0500, Tom Lane wrote: > It'd be safe enough within the same transaction, since VACUUM can't kill > a tuple inserted by an open transaction; nor could VACUUM FULL touch the > table at all, since you'll be holding at least a writer's lock on the > table. True, but it sti

Re: [HACKERS] [NOVICE] Last ID Problem

Neil Conway <[EMAIL PROTECTED]> writes: > On Tue, 2005-02-01 at 11:24 -0300, Alvaro Herrera wrote: >> How about the TID? > That wouldn't be sufficiently stable for use by client applications, I > believe: a concurrent VACUUM FULL could mean your TID no longer points > at what you think it does. I

Re: [HACKERS] [NOVICE] Last ID Problem

On Tue, 2005-02-01 at 11:24 -0300, Alvaro Herrera wrote: > How about the TID? That wouldn't be sufficiently stable for use by client applications, I believe: a concurrent VACUUM FULL could mean your TID no longer points at what you think it does. -Neil ---(end of broadc

Re: [HACKERS] FunctionCallN improvement.

On February 1, 2005 01:23 pm, Tom Lane wrote: > a_ogawa <[EMAIL PROTECTED]> writes: > > I made the test program to measure the effect of this macro. > > Well, if we're going to be tense about this, let's actually be tense > about it. Your test program isn't a great model for what's going to > happ

Re: [HACKERS] float4 regression test failed on linux parisc

Tom, The issue is with a select 'Infinity'::float4/'Infinity'::float4; which should return NAN. without the cast I get the overflow message from CheckFloat4Val with the cast I get NAN (as expected). How about testing for isnan() inside CheckFloat4Val (just for PARISC / Linux)? I am trying t

Re: [HACKERS] float4 regression test failed on linux parisc

"Jim Buttafuoco" <[EMAIL PROTECTED]> writes: > Change: > CheckFloat4Val(result); > To: > CheckFloat4Val((float4)result); CheckFloat4Val is defined to take a double, so whatever the above is accomplishing is wrong: probably it's masking an out-of-range result. I think you've hit a b

Re: [HACKERS] float4 regression test failed on linux parisc

"Jim Buttafuoco" <[EMAIL PROTECTED]> writes: > I am trying to get this system working for the buildfarm as there are > NO other HP PARISC system on the farm. I still use a PA-RISC machine as my primary development environment, so I can assure you that platform gets tested every day. I'm not parti

Re: [HACKERS] float4 regression test failed on linux parisc

Source: CSV HEAD (As of yesterday) Platform: HP PARISC (HP 710) OS: Debian Sarge File: src/backend/utils/adt/float.c Change: CheckFloat4Val(result); To: CheckFloat4Val((float4)result); I tested this on my parisc box and it passed all tests. This could just be an issue with a very

Re: [HACKERS] Huge memory consumption during vacuum (v.8.0)

On Tue, 1 Feb 2005, Tom Lane wrote: Oleg Bartunov writes: I see that pgsql_tmp/ contains files, looks like clustered table. What postmaster is doing if disk usage doesn't changed ? Most likely doing a disk-based merge sort ... just interesting - multiway, in-place or just place merge sort ?

Re: [HACKERS] Huge memory consumption during vacuum (v.8.0)

Oleg Bartunov writes: > I see that pgsql_tmp/ contains files, looks like clustered table. > What postmaster is doing if disk usage doesn't changed ? Most likely doing a disk-based merge sort ... regards, tom lane ---(end of broadcast)-

Re: [HACKERS] FunctionCallN improvement.

a_ogawa <[EMAIL PROTECTED]> writes: > I made the test program to measure the effect of this macro. Well, if we're going to be tense about this, let's actually be tense about it. Your test program isn't a great model for what's going to happen in fmgr.c, because you've designed it so that Nargs c

Re: [HACKERS] Huge memory consumption during vacuum (v.8.0)

On Sun, 30 Jan 2005, Oleg Bartunov wrote: Seems, postmaster eats expected amount of memory now ! Will see how long it will proceeded. Probably, my case should be documented somewhere. just to inform - vacuum took almost 48 hours ! Another possibility is to use CLUSTER or a rewriting ALTER TABLE t

Re: [HACKERS] Allow GRANT/REVOKE permissions to be applied to all schema

Josh Berkus writes: > And overall, I'd think it would make the feature a > *lot* less useful; basically it would encourage a > lot of DBAs to organize their schemas by > security level, which is not really what schemas > are for. > that's not the way Oracle do things? one schema per user and th

Re: [HACKERS] float4 regression test failed on linux parisc

Tom Lane wrote: "Jim Buttafuoco" <[EMAIL PROTECTED]> writes: I am getting a float4 regression test failure. I have extracted the SQL from both the float4 and float8 tests below. Both should return NAN I looked at the code, The float4div does the operation as float8's then checks the value. Th

Re: [HACKERS] Allow GRANT/REVOKE permissions to be applied to all schema

Josh Berkus writes: > The problem with this approach is it leaves us with no way to REVOKE > permissions on a specific table from a user who has permissions on the > SCHEMA. Our permissions model is completely additive, so if you did: Why is that a problem? The complaint seems about analogous

Re: [HACKERS] float4 regression test failed on linux parisc

"Jim Buttafuoco" <[EMAIL PROTECTED]> writes: > I am getting a float4 regression test failure. I have extracted the SQL from > both the float4 and float8 tests below. > Both should return NAN > I looked at the code, The float4div does the operation as float8's then > checks the value. The va

Re: [HACKERS] Patent issues and 8.1

A new organization called the "Software Freedom Law Center" was announced yesterday; that seems like it may be one of the best places open-source groups could go for questions like this ARC pending patent. Eben Moglen (The FSF's main lawyer and Columbia Law prof), Diane Peters (OSDL's general couns

Re: [HACKERS] STABLE functions

strk <[EMAIL PROTECTED]> writes: > Hello all, I saw that STABLE-defined functions > don't get replaced by their output, shoudn't they ? > Following shows that VOLATILE and STABLE functions outputs > won't get into the Filter, while IMMUTABLE will. The examples are acting exactly as they should. S

Re: [HACKERS] [NOVICE] Last ID Problem

I have a suggestion... For libpq: Since OID's are now deprecated, and will eventually disappear, wouldn't it be a good idea, to have INSERT and UPDATE return a copy of the tuple that was inserted/updated? This way, you could have a funtion to fetch an arbitrary named column from that tuple. Lik

Re: [HACKERS] Allow GRANT/REVOKE permissions to be applied to all schema

Josh Berkus wrote: > > pg_find --type=table --schema=foo --name='system_*' > > --execute='GRANT ALL ON % TO myuser' > > Hey, that's a way keen idea. Regardless of what we do with > GRANT/REVOKE. You don't happen to, uh, have any code for that? psql -t -A -c "select tablename from pg_tables where

Re: [HACKERS] Allow GRANT/REVOKE permissions to be applied to all

Josh Berkus wrote: Richard, pg_find --type=table --schema=foo --name='system_*' --execute='GRANT ALL ON % TO myuser' Hey, that's a way keen idea. Regardless of what we do with GRANT/REVOKE. You don't happen to, uh, have any code for that? Well, currently, what you see posted above is the ful

Re: [HACKERS] Allow GRANT/REVOKE permissions to be applied to all schema

Richard, > pg_find --type=table --schema=foo --name='system_*' --execute='GRANT ALL > ON % TO myuser' Hey, that's a way keen idea. Regardless of what we do with GRANT/REVOKE. You don't happen to, uh, have any code for that? -- Josh Berkus Aglio Database Solutions San Francisco --

Re: [HACKERS] Group-count estimation statistics

Manfred Koizar <[EMAIL PROTECTED]> writes: > On Mon, 31 Jan 2005 14:40:08 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: >> Oh, I see, you want a "max" calculation in there too. Seems reasonable. >> Any objections? > Yes. :-( What I said is only true in the absence of any WHERE clause > (or join).

Re: [HACKERS] [NOVICE] Last ID Problem

"John Hansen" <[EMAIL PROTECTED]> writes: >>> Since OID's are now deprecated, and will eventually disappear, No one has stated that they will disappear. >>> wouldn't it be a good idea, to have INSERT and UPDATE >>> return a copy of the tuple that was inserted/updated? >> >> How about the TID?

[HACKERS] Updated FAQ

I have udpated our main FAQ. I was shocked at out stale some of the information was. It wasn't technically wrong but needed a good cleaning. Let me know if anyone sees any other needed improvements. -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.pa.us

Re: [HACKERS] Our getopt_long() doesn't do abbreviations or NLS

Peter Eisentraut <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Should it be gettext'ified? > Probably. I seem to recall that there was some special consideration for files that would conditionally show up in multiple executables. Or were you going to fix that by having just one .mo file for a

Re: [HACKERS] 7.2.7 -> 8.0.1 Bundles Ready ...

/pub/src is now gone ... On Tue, 1 Feb 2005, Dave Page wrote: -Original Message- From: Marc G. Fournier [mailto:[EMAIL PROTECTED] Sent: 01 February 2005 10:52 To: Peter Eisentraut Cc: Dave Page; Marc G. Fournier; Tom Lane; pgsql-hackers@postgresql.org; David Fetter Subject: Re: [HACKERS] 7

Re: [HACKERS] Group-count estimation statistics

On Mon, 31 Jan 2005 14:40:08 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: >Manfred Koizar <[EMAIL PROTECTED]> writes: >> That's not what I meant. I tried to say that if we have a GROUP BY >> several columns and one of these columns alone has more than N/10 >> distinct values, there's no way to get l

[HACKERS] float4 regression test failed on linux parisc

I am getting a float4 regression test failure. I have extracted the SQL from both the float4 and float8 tests below. Both should return NAN I looked at the code, The float4div does the operation as float8's then checks the value. The value is a valid float8 NAN. The call to CheckFloat4Val

Re: [HACKERS] [NOVICE] Last ID Problem

> > Since OID's are now deprecated, and will eventually disappear, > > wouldn't it be a good idea, to have INSERT and UPDATE > return a copy of > > the tuple that was inserted/updated? > > How about the TID? Yea, that'd work. As long as you can get an arbitrary column back out, 'as it was at

Re: [HACKERS] [NOVICE] Last ID Problem

On Tue, Feb 01, 2005 at 06:31:30PM +1100, John Hansen wrote: > Since OID's are now deprecated, and will eventually disappear, > wouldn't it be a good idea, to have INSERT and UPDATE return > a copy of the tuple that was inserted/updated? How about the TID? -- Alvaro Herrera (<[EMAIL PROTECTED]

Re: [HACKERS] FunctionCallN improvement.

(BTom Lane wrote: (B> Neil Conway <[EMAIL PROTECTED]> writes: (B> > I agree; I think the macro is a nice improvement to readability. (B> (B> But a dead loss for performance, since it does a MemSet *and* some other (B> operations. What's worse, it changes a word-aligned MemSet into a (B> n

Re: [HACKERS] 7.3.8 under FC3 takes excessive semaphores?

> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: 31 January 2005 16:35 > To: Mark Cave-Ayland > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] 7.3.8 under FC3 takes excessive semaphores? (cut) > Judging by the symptoms, you have built a version with wha

Re: [HACKERS] 7.2.7 -> 8.0.1 Bundles Ready ...

> -Original Message- > From: Marc G. Fournier [mailto:[EMAIL PROTECTED] > Sent: 01 February 2005 10:52 > To: Peter Eisentraut > Cc: Dave Page; Marc G. Fournier; Tom Lane; > pgsql-hackers@postgresql.org; David Fetter > Subject: Re: [HACKERS] 7.2.7 -> 8.0.1 Bundles Ready ... > > > So d

Re: [HACKERS] 7.2.7 -> 8.0.1 Bundles Ready ...

Marc G. Fournier wrote: > So do I get rid of the src directory altogether then, since > apparently nobody likes, or wants, it? :) Sure. Just to recap, I believe my complaint at the time was that release announcements and the like were inconsistent regarding the version names (not anymore, I thi

[HACKERS] STABLE functions

Hello all, I saw that STABLE-defined functions don't get replaced by their output, shoudn't they ? Following shows that VOLATILE and STABLE functions outputs won't get into the Filter, while IMMUTABLE will. Documentation says that STABLE is the modifier to use for functions which don't change out

[HACKERS] Connect By for 8.0

I notice the CONNECT BY patch has been updated for 8.0: http://gppl.moonbone.ru/ Seriously, we really need to get this into 8.1. Convert it to the standard WITH RECURSIVE syntax if necessary... Chris ---(end of broadcast)--- TIP 6: Have you searche

Re: [HACKERS] Allow GRANT/REVOKE permissions to be applied to all

At 2005-02-01 16:31:32 +0530, [EMAIL PROTECTED] wrote: > > Speaking of which, see Actually, -- ams ---(end of broadcast)--- TIP 3: if posting/reading through Usen

Re: [HACKERS] Allow GRANT/REVOKE permissions to be applied to all

At 2005-02-01 11:02:52 +0100, [EMAIL PROTECTED] wrote: > > We really should reimplement our query language in Scheme and > implement SQL on top of that. It will make many things much > easier. :-) Speaking of which, see -- ams ---(end

Re: [HACKERS] 7.2.7 -> 8.0.1 Bundles Ready ...

So do I get rid of the src directory altogether then, since apparently nobody likes, or wants, it? :) On Tue, 1 Feb 2005, Peter Eisentraut wrote: Dave Page wrote: Urgh. No offence to Peter, but I think it's a helluva lot messier having all those symlinks. That wasn't my idea. -- Peter Eisentraut

Re: [HACKERS] Allow GRANT/REVOKE permissions to be applied to all

Richard Huxton wrote: > Do we perhaps want a pg_find tool instead, rather than getting too > clever inside the backend? > > pg_find --type=table --schema=foo --name='system_*' --execute='GRANT > ALL ON % TO myuser' We really should reimplement our query language in Scheme and implement SQL on top

Re: [HACKERS] Our getopt_long() doesn't do abbreviations or NLS

Tom Lane wrote: > I just noticed that our port/getopt_long.c substitute implementation > does not accept abbreviated names for long options: That is known, but since we don't advertise that feature, it's not a problem. > Barring objections, I'm going to modify our version to allow unique > abbre

Re: [HACKERS] 7.2.7 -> 8.0.1 Bundles Ready ...

Dave Page wrote: > Urgh. No offence to Peter, but I think it's a helluva lot messier > having all those symlinks. That wasn't my idea. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: Have you checked ou

Re: [HACKERS] Allow GRANT/REVOKE permissions to be applied to all

Josh Berkus wrote: And overall, I'd think it would make the feature a *lot* less useful; basically it would encourage a lot of DBAs to organize their schemas by security level, which is not really what schemas are for. This does seem conceptually cleaner than GRANT ON NEW TABLES, which to me ha