Re: [HACKERS] 7.4RC1 tag'd, branched and bundled ...

2003-11-03 Thread Marc G. Fournier
On Mon, 3 Nov 2003, Peter Eisentraut wrote: Marc G. Fournier writes: As Tom announced on Friday, Release Candidate 1 has now been tag'd and bundled ... Can you please sometime decide once and for all how you're going to name the tarballs and then communicate that information

Re: [HACKERS] 7.4RC1 tag'd, branched and bundled ...

2003-11-03 Thread Marc G. Fournier
On Tue, 4 Nov 2003, Gaetano Mendola wrote: Marc G. Fournier wrote: As Tom announced on Friday, Release Candidate 1 has now been tag'd and bundled ... please test to confirm that nothing seems off with this build Is in the last Tom's patch about Vacuum sleep between pages ? that won't

Re: [HACKERS] 7.4RC1 failed to build on Linux

2003-11-03 Thread Marc G. Fournier
what version of tcl do you have installed? On Tue, 4 Nov 2003, Kenji Sugita wrote: Failed to build on Linux. $ uname -mrp 2.2.18-0ph1smp i686 unknown $ uname -mr 2.2.18-0ph1smp i686 $ cat /etc/redhat-release Red Hat Linux release 6.2 (Zoot) $ gcc --version 2.95.3 $ cat ../myconf

Re: [HACKERS] Open Sourcing pgManage

2003-11-04 Thread Marc G. Fournier
On Tue, 4 Nov 2003, Joshua D. Drake wrote: Hello, If that is the case that is fine. I just wanted to throw it out there but doesn't that mean that psql would be separate as well? no new client applications ---(end of broadcast)--- TIP 9:

Re: [HACKERS] Open Sourcing pgManage

2003-11-04 Thread Marc G. Fournier
On Tue, 4 Nov 2003, Andrew Dunstan wrote: Marc G. Fournier wrote: On Tue, 4 Nov 2003, Joshua D. Drake wrote: Hello, If that is the case that is fine. I just wanted to throw it out there but doesn't that mean that psql would be separate as well? no new client applications

Re: [HACKERS] Open Issues for 7.4

2003-11-05 Thread Marc G. Fournier
On Wed, 5 Nov 2003, Peter Eisentraut wrote: Here are some issues that might need to be addressed before 7.4 goes out: * ECPG has some new include files such as datetime.h decimal.h that come as part of the Informix compatibility mode. I don't think these should be installed directly

Re: [HACKERS] Schema boggle...

2003-11-05 Thread Marc G. Fournier
On Wed, 5 Nov 2003, Jan Wieck wrote: Chris Bowlby wrote: Hi All, I work with Marc Fournier, for those who don't know, and have been working extensively with the schemas feature for Hub.Org's new Account Management package. Each client's data is stored in a seperate schema set

Re: [HACKERS] Schema boggle...

2003-11-05 Thread Marc G. Fournier
On Wed, 5 Nov 2003, Tom Lane wrote: Chris Bowlby [EMAIL PROTECTED] writes: As you can see this is a nice, clean way to break down some datasets. But, if I do: set search_path to public, test_001, test_002; I only get access to the tables in test_001 and public, the tables in

Re: [HACKERS] Schema boggle...

2003-11-05 Thread Marc G. Fournier
Actually, the use of schema's was my idea, to speed up some dreadfully slow queries dealing with traffic stats from a table that was growing painfully monolithic ... the idea is/was that it would be easier to backup/remove all data pertaining to a specific client if they decided to close their

Re: [HACKERS] release timing

2003-11-07 Thread Marc G. Fournier
On Fri, 7 Nov 2003, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: What is the current schedule for RC2/final? I believe the plan is to wrap RC2 this Sunday evening, and to release final the following Monday (11/17), barring problems. Core will make a go/no-go release decision

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Marc G. Fournier
On Fri, 7 Nov 2003, Bruce Momjian wrote: Here are the major things I do for the PostgreSQL project. Are there some items I should be doing more/less of? o Patches o TODO/FAQ o Email discussion, coordination o Win32 o Talks o Books/articles

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Marc G. Fournier
On Fri, 7 Nov 2003, Bruce Momjian wrote: Marc G. Fournier wrote: On Fri, 7 Nov 2003, Bruce Momjian wrote: Here are the major things I do for the PostgreSQL project. Are there some items I should be doing more/less of? o Patches o TODO/FAQ o Email discussion

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Marc G. Fournier
On Fri, 7 Nov 2003, Robert Treat wrote: On Fri, 2003-11-07 at 14:00, Bruce Momjian wrote: Peter Eisentraut wrote: Bruce Momjian writes: o TODO/FAQ The FAQ might as well be maintained just like the rest of the documentation, i.e., by the development group as a

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Marc G. Fournier
On Fri, 7 Nov 2003, Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Bugzilla is far from perfect. But it's getting better. FWIW, I would like to try a bugzilla-based tracking system for Postgres. Our last attempt at a tracking system failed miserably, but I think that was (a)

Re: [HACKERS] [BUGS] postgresql-7.4RC1 - unrecognized privilege type

2003-11-08 Thread Marc G. Fournier
On Sat, 8 Nov 2003, Tom Lane wrote: [EMAIL PROTECTED] writes: select * from information_schema.tables; ERROR: unrecognized privilege type: RERERENCES Replacing the word RERERENCES with REFERENCES in the predicate has_table_privilege(c.oid, 'RERERENCES'::text) near the end of

Re: [HACKERS] OSR5: Passes without the setsockopt() calls...

2003-11-09 Thread Marc G. Fournier
On Sun, 9 Nov 2003, Larry Rosenman wrote: Can I get a comment from someone on this please... no, the release will not be held up LER --On Saturday, November 08, 2003 18:03:45 -0600 Larry Rosenman [EMAIL PROTECTED] wrote: From my SCO contacts re: the failure on OSR5: I

[HACKERS] RC2 tag'd and bundled ...

2003-11-10 Thread Marc G. Fournier
Should be on the mirrors now, will announce it this evening ... things looked to build clean, just would like a second opinion on it ... ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [pgsql-www] [HACKERS] Changes to Contributor List

2003-11-10 Thread Marc G. Fournier
On Mon, 10 Nov 2003, Robert Treat wrote: On Fri, 2003-11-07 at 13:51, Josh Berkus wrote: really the most important thing here is that we get some movement on the site in order to ditch the old VM the site lives on and get it on our new web VM. On techdocs? What part of that

Re: [pgsql-www] [HACKERS] Changes to Contributor List

2003-11-10 Thread Marc G. Fournier
On Mon, 10 Nov 2003, Josh Berkus wrote: Justin, From memory, the OpenOffice.org surveys still run from the techdocs virtual machine too. That may or may not be the case these days, I just don't remember. Really? I thought that they were running from one of Sun's machines. Will

Re: [pgsql-www] [HACKERS] Changes to Contributor List

2003-11-10 Thread Marc G. Fournier
In fact: http://oosurvey.gratismania.ro/stats On Mon, 10 Nov 2003, Marc G. Fournier wrote: On Mon, 10 Nov 2003, Josh Berkus wrote: Justin, From memory, the OpenOffice.org surveys still run from the techdocs virtual machine too. That may or may not be the case these days, I just

[HACKERS] [7.3.x] function does not exist ... ?

2003-11-10 Thread Marc G. Fournier
'k, this doesn't look right, but it could be that I'm overlooking something ... The function I created: CREATE FUNCTION month_trunc (timestamp without time zone) RETURNS timestamp without time zone AS 'SELECT date_trunc(''month'', $1 )' LANGUAGE sql IMMUTABLE; The query that fails:

Re: [HACKERS] [7.3.x] function does not exist ... ?

2003-11-10 Thread Marc G. Fournier
On Mon, 10 Nov 2003, Gaetano Mendola wrote: Marc G. Fournier wrote: 'k, this doesn't look right, but it could be that I'm overlooking something ... The function I created: CREATE FUNCTION month_trunc (timestamp without time zone) RETURNS timestamp without time zone

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-11 Thread Marc G. Fournier
On Tue, 11 Nov 2003, Shridhar Daithankar wrote: --- Hello, My name is and I work with postgresql group. Recently we/postgresql advocay/general group have decided to form a group of people who would help other projects w.r.t postgresql. So feel free to ask me questions. I can

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marc G. Fournier
On Tue, 11 Nov 2003, Peter Eisentraut wrote: Do we have any data on how many people download the partial tarballs (-base, -opt, etc.)? I have a feeling that more people are confused by them than use them. on ftp.postgresql.org itself, since June 4th: 2812

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marc G. Fournier
On Tue, 11 Nov 2003, Peter Eisentraut wrote: Marc G. Fournier writes: Do we have any data on how many people download the partial tarballs (-base, -opt, etc.)? I have a feeling that more people are confused by them than use them. on ftp.postgresql.org itself, since June 4th

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marc G. Fournier
On Wed, 12 Nov 2003, Marko Karppinen wrote: I agree that the partial tarballs can confuse an ftp user, though. I think a good solution to this would be to put them one level deeper, into a subfolder. The full tarball would then be the only thing a casual user would encounter, but the

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marc G. Fournier
On Tue, 11 Nov 2003, Nigel J. Andrews wrote: On Tue, 11 Nov 2003, Marc G. Fournier wrote: ftp://ftp.postgresql.org/pub/README.dist-split to reduce the confusion, that would be great. I've just symlink'd it into the source directories as the .message, so that its displays when you

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marc G. Fournier
On Wed, 12 Nov 2003, Christopher Kings-Lynne wrote: Even if they weren't useful for anything else, I think there's value in the developers having to consider what is optional and what is not. This need for constant review probably reduces the chance of bloat, over time even in the full

[HACKERS] PostgreSQL v7.4 Release Candidate 2

2003-11-10 Thread Marc G. Fournier
We have just packaged up our second Release Candidate for v7.4, with the hopes of producing a full release next week. A full ChangeLog is available at: ftp://ftp.postgresql.org/pub/sources/v7.4/ChangeLog.RC1.to.RC2 But, one of the highlights is that support for tcl8.0.x has been

Re: [HACKERS] rpm support for 7.4 and beyond

2003-11-12 Thread Marc G. Fournier
On Wed, 12 Nov 2003, Lamar Owen wrote: The biggest issue is going to be 'will it build' on those releases. The tcl version deal (with tcl prior to 8.1) Tom applied a patch so that the build will continue to work on 8.0.x ... or is this some other issue? ---(end of

Re: [HACKERS] rpm support for 7.4 and beyond

2003-11-13 Thread Marc G. Fournier
On Thu, 13 Nov 2003, Lamar Owen wrote: On Wednesday 12 November 2003 11:51 pm, Marc G. Fournier wrote: On Wed, 12 Nov 2003, Lamar Owen wrote: The biggest issue is going to be 'will it build' on those releases. The tcl version deal (with tcl prior to 8.1) Tom applied a patch so

Re: [CORE] [HACKERS] 7.4RC2 regression failur and not running stats

2003-11-14 Thread Marc G. Fournier
On Fri, 14 Nov 2003, Josh Berkus wrote: Tom, Too bad we didn't figure this out yesterday. We are now in code freeze for 7.4 release, and I'm hesitant to apply a fix for what is arguably a broken platform. Core guys, time for a vote ... do we fix, or hold this for 7.4.1? One thing

Re: [HACKERS] oh dear ...

2003-11-14 Thread Marc G. Fournier
On Fri, 14 Nov 2003, Tom Lane wrote: I said: This worked in 7.3: regression=# select '1999-jan-08'::date; ERROR: date/time field value out of range: 1999-jan-08 HINT: Perhaps you need a different datestyle setting. Setting DateStyle to YMD doesn't help, and in any case I'd think

Re: [HACKERS] oh dear ...

2003-11-14 Thread Marc G. Fournier
On Fri, 14 Nov 2003, Bruce Momjian wrote: Tom Lane wrote: I said: This worked in 7.3: regression=# select '1999-jan-08'::date; ERROR: date/time field value out of range: 1999-jan-08 HINT: Perhaps you need a different datestyle setting. Setting DateStyle to YMD doesn't

Re: [HACKERS] oh dear ...

2003-11-14 Thread Marc G. Fournier
On Fri, 14 Nov 2003, Andrew Dunstan wrote: I'm confused. My understanding from what Tom said is that it affects all configurations. the stats collector problem, from what I've seen through this list, affects Solaris, and only some Solaris configuration .. ---(end of

Re: [HACKERS] oh dear ...

2003-11-14 Thread Marc G. Fournier
On Fri, 14 Nov 2003, Tom Lane wrote: Christopher Kings-Lynne [EMAIL PROTECTED] writes: Shouldn't you also add a regression test to catch this in the future? Yes, I absolutely plan to stick some regression test additions into HEAD. There's not a need for such changes in the 7.4 branch

Re: [HACKERS] oh dear ...

2003-11-14 Thread Marc G. Fournier
My bad, confused two different issues in one thread :( On Fri, 14 Nov 2003, Joe Conway wrote: Marc G. Fournier wrote: On Fri, 14 Nov 2003, Andrew Dunstan wrote: I'm confused. My understanding from what Tom said is that it affects all configurations. the stats collector problem, from

[HACKERS] We're finally there ...

2003-11-16 Thread Marc G. Fournier
'k, I just tag'd REL7_4 and built the bundles ... the files are available under ftp://ftp.postgresql.org/pub/source/v7.4beta, and I've open'd up the ftp server there to 100 connections so that ppl can get in and test it ... It is 6:15pm AST here right now ... at ~9pm, I will move those files to

[HACKERS] Release now live ...

2003-11-16 Thread Marc G. Fournier
'k, I just moved the release into the /pub/source/v7.4 directory from the v7.4beta one ... RC2 is still in place, so that I don't break a bunch of links ... tomorrow night, I'll remove the RC2 ... ---(end of broadcast)--- TIP 9: the planner will

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Peter Eisentraut wrote: The time from release 7.3 to release 7.4 was 355 days, an all-time high. We really need to shorten that. We already have a number of significant improvements in 7.5 now, and several good ones coming up in the next few weeks. We cannot let people

Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?

2003-11-17 Thread Marc G. Fournier
On Mon, 17 Nov 2003, Josh Berkus wrote: Given all that, don't people think it's time to jump to 8.0? Seems like even 7.4 is hardly recognizable as the same database as 7.0. Discussion like this tends to be more for just before beta, once we have an idea what actually made it in :) You be

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Peter Eisentraut wrote: Marc G. Fournier writes: That is the usual goal *nod* Same goal we try for each release, and never quite seem to get there ... we'll try 'yet again' with 7.5 though, as we always do :) I don't see how we could have tried for a 4-month

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
Just did a quick search on archives, and the original plan was for a release in mid-2003, which means the beta would have been *at least* a month before that, so beta starting around May: http://archives.postgresql.org/pgsql-hackers/2002-11/msg00975.php On Mon, 17 Nov 2003, Marc G. Fournier

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Christopher Kings-Lynne wrote: Everyone on -hackers should have been aware of it, as its always discussed at the end of the previous release cycle ... and I don't think we've hit a release cycle yet that has actually stayed in the 4 month period :( Someone is always

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Peter Eisentraut wrote: Marc G. Fournier writes: Right now, I believe we are looking at an April 1st beta, and a May 1st related ... those are, as always, *tentative* dates that will become more fine-tuned as those dates become nearer ... OK, here start the problems

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Mon, 17 Nov 2003, Neil Conway wrote: That said, I'm not really sure how we can make better use of the beta period. One obvious improvement would be making the beta announcements more visible: the obscurity of the beta process on www.postgresql.org for 7.4 was pretty ridiculous. Does

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Peter Eisentraut wrote: 0. As you say, make it known to the public. Have people test their in-development applications using a beta. and how do you propose we do that? I think this is the hard part ... other then the first beta, I post a note out to -announce and

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Mon, 17 Nov 2003, Larry Rosenman wrote: I try to test stuff fairly frequently, and this time I didn't know when, exactly, SCO would make the release of the updated compiler. And there was no way you could predict that your contact there would take off on holidays either :(

[HACKERS] So as not to break it for anyone ...

2003-11-17 Thread Marc G. Fournier
://ftp.postgresql.org/pub/source/v[167].* Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 9: the planner

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Neil Conway wrote: Marc G. Fournier [EMAIL PROTECTED] writes: On Tue, 18 Nov 2003, Peter Eisentraut wrote: 0. As you say, make it known to the public. Have people test their in-development applications using a beta. and how do you propose we do that? I think

Re: [HACKERS] Is there going to be a port to Solaris 9 x86 in the

2003-11-18 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Christoper Smiga wrote: All: Does anyone know if there is going to be a port to Solaris 9 x86 in the near future. What is the decission to develop on this platform since Sun is pushing Solaris x86 harder than ever. Doesn't it work? I've run on Solaris 8 x86 extensively

Re: [pgsql-www] [HACKERS] Release cycle length

2003-11-18 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Andrew Dunstan wrote: Josh Berkus wrote: Guys, I agree with Neil ... it's not the length of the development part of the cycle, it's the length of the beta testing. I do think an online bug tracker (bugzilla or whatever) would help. I also think that having a

Re: [pgsql-www] [HACKERS] Release cycle length

2003-11-18 Thread Marc G. Fournier
with it, I have one client would would be willing to test it against a simulated production load on pretty heavy-duty hardware. Can't we have nightly builds always available? Why can't they just use the CVS version? We do do nightly builds ... have for years now ... Marc G. Fournier

Re: [HACKERS] Commercial binary support?

2003-11-19 Thread Marc G. Fournier
G. Fournier PostgreSQL, Inc (http://www.pgsql.com) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] 4 Clause license?

2003-11-20 Thread Marc G. Fournier
is nobody else large enough to bother with ... its going to be interesting to see :) Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast

Re: [HACKERS] 4 Clause license?

2003-11-20 Thread Marc G. Fournier
) ... Marc G. Fournier wrote: On Thu, 20 Nov 2003, Andrew Dunstan wrote: trollOf course, now that SCO is claiming ownership of BSD code . /troll Interesting thread that ... last I read on the FreeBSD lists was speculation that they would be going after ppl like Cisco (re

[HACKERS] [7.4] statistics collector: Protocol not supported

2003-11-22 Thread Marc G. Fournier
/pgsql/bin/postmaster -D /usr/local/pgsql/data -S (postgres) pgsql 60121 0.0 0.1 4908 3316 ?? SJ3:32AM 0:00.00 postmaster: stats buffer process(postgres) pgsql 60123 0.0 0.1 3964 3364 ?? SJ3:32AM 0:00.00 postmaster: stats collector process(postgres) Marc G. Fournier

Re: [HACKERS] [7.4] statistics collector: Protocol not supported

2003-11-23 Thread Marc G. Fournier
On Sun, 23 Nov 2003, Tom Lane wrote: Kurt Roeckx [EMAIL PROTECTED] writes: On Sat, Nov 22, 2003 at 11:32:18PM -0400, Marc G. Fournier wrote: I suspect it might be because I'm running in a jail'd environment, but what should I be looking at to confirm? could not create socket

Re: [HACKERS] Executable files in CVS

2003-11-23 Thread Marc G. Fournier
off the write bits? Just curious, but what do the write bits harm? Everyone that has access to that VM has acccess to CVSROOT, either through CVS or directly ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy

Re: [HACKERS] 7.5 Plans

2003-11-26 Thread Marc G. Fournier
? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] 7.5 Plans

2003-11-26 Thread Marc G. Fournier
committing? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose

[HACKERS] $Id$ - $PostgreSQL$ Change

2003-11-26 Thread Marc G. Fournier
Based on discussions on -hackers, and baring any objections betwen now and then, I'm going to go through all files in CVS and change: $Id$ - $PostgreSQL$ I will do this the evening of Friday, November 29th ... Marc G. Fournier Hub.Org Networking Services (http

Re: [HACKERS] about explain analyze

2003-11-28 Thread Marc G. Fournier
discrepancy myself. Actually, I'm noticing similar problems with v7.4 ... EXPLAIN ANALYZE seems to be showing some *very* high ms for execution time, but if you run the actual query, it doesn't seem to take even 1/10th the time reported ... This is on a FreeBSD 4.x box ... Marc G. Fournier

Re: [HACKERS] about explain analyze

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: Actually, I'm noticing similar problems with v7.4 ... EXPLAIN ANALYZE seems to be showing some *very* high ms for execution time, but if you run the actual query, it doesn't seem to take even 1/10th the time

Re: [HACKERS] $Id$ - $PostgreSQL$ Change

2003-11-28 Thread Marc G. Fournier
, in 'info cvs'? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] about explain analyze

2003-11-28 Thread Marc G. Fournier
None that I've heard of ... Sean? Tom, any way of writing a quite test C program for this? Something to 'simulate' the same thing, but without having to build the whole postmaster? On Fri, 28 Nov 2003, Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: On Fri, 28 Nov 2003, Tom Lane

Re: [HACKERS] $Id$ - $PostgreSQL$ Change

2003-11-28 Thread Marc G. Fournier
On Thu, 27 Nov 2003, Rod Taylor wrote: On Thu, 2003-11-27 at 00:50, Marc G. Fournier wrote: Based on discussions on -hackers, and baring any objections betwen now and then, I'm going to go through all files in CVS and change: $Id$ - $PostgreSQL$ I will do this the evening

Re: [HACKERS] about explain analyze

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: did you happen to take a look at the other set of queries I sent you, that were showing 39k and 41k explain results? You mean this one? Yup ... time psql -c explain analyze select max(intag) from ndict3

Re: [HACKERS] about explain analyze

2003-11-28 Thread Marc G. Fournier
be worth griping to the BSD kernel folk... Still though I think we could be proud that we've gotten the price of a seqscan down to the point where a couple of gettimeofday() calls per row are dominating the runtime. regards, tom lane Marc G. Fournier Hub.Org

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Darcy Buskermolen wrote: I've been running this code on a pair of FreeBSD (i386) boxen, for some time now, one of which is a 4.8-STABLE, the other is a 5.2-BETA. In 10 minutes of execution the 4.8 box has only shown the following: out of order tv_sec: 1070063393 115226,

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Tom Lane wrote: Could it be a hardware problem on Marc's box? Or specific to some other aspect of that installation (Marc, is pgsql74.hub.org multi-CPU, for example?) All the servers are SMP ... pgsql74 is on a Dual-Xeon ... Marc G. Fournier Hub.Org

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: I'm suspecting that the issue is amplified by load on the server itself That would fit right in with my idea that the failure occurs when the process loses its timeslice partway through gettimeofday(). Heavier

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Marc G. Fournier wrote: On Fri, 28 Nov 2003, Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: I'm suspecting that the issue is amplified by load on the server itself That would fit right in with my idea that the failure occurs when the process loses its

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: Just got my first response on this, and, in fact, this is 'acceptable behaviour' to a certain extent ... there is a kernel tuneable called kern.timecounter.method, that is either 1 or 0: 15 minutes of error

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Marc G. Fournier
is kern.timecounter.method set to? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Neil Conway wrote: Marc G. Fournier [EMAIL PROTECTED] writes: On Fri, 28 Nov 2003, Neil Conway wrote: $ uname -a FreeBSD home.samurai.com 4.9-RELEASE [...] what is kern.timecounter.method set to? $ sysctl kern.timecounter.method kern.timecounter.method: 0 FYI

[HACKERS] 7.3.5 to be released this week ...

2003-11-29 Thread Marc G. Fournier
Bruce is going to do whatever magic he needs to on Tuesday, after while I'll bundle it up for testing (at which point in time Peter should point out any oops I happen to have made, no after, eh? *evil grin*) ... then we'll do an announce of its availability on Wednesday ... Marc G. Fournier

Re: [HACKERS] $Id$ - $PostgreSQL$ Change

2003-11-29 Thread Marc G. Fournier
Assuming I didn't miss any files, this is now complete ... I grep'd for both $Header: and $Id:, and appear to have gotten them all ... On Fri, 28 Nov 2003, Marc G. Fournier wrote: On Thu, 27 Nov 2003, Rod Taylor wrote: On Thu, 2003-11-27 at 00:50, Marc G. Fournier wrote: Based

Re: [HACKERS] $Id$ - $PostgreSQL$ Change

2003-11-29 Thread Marc G. Fournier
k, I see why ... fixing right now ... On Sat, 29 Nov 2003, Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: Assuming I didn't miss any files, this is now complete ... I grep'd for both $Header: and $Id:, and appear to have gotten them all ... From here it looks like the $Id

Re: [HACKERS] $Id$ - $PostgreSQL$ Change

2003-11-29 Thread Marc G. Fournier
... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

[HACKERS] Updated code to test gettimeofday() ...

2003-11-29 Thread Marc G. Fournier
, curtime.tv_usec, prevtime.tv_sec, prevtime.tv_usec); } last = now; prevtime = curtime; } return 0; } Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL

Re: [HACKERS] request for feedback - read-only GUC variables,

2003-12-02 Thread Marc G. Fournier
On Tue, 2 Dec 2003, Joe Conway wrote: We (mostly Bruce, Tom, Peter, and I) have been having a discussion on the PATCHES list regarding some new functionality related to read-only GUC variables. The net result is pasted at the bottom of this post. Here is a link to the discussion:

[HACKERS] 7.3.5 bundled ...

2003-12-02 Thread Marc G. Fournier
Please take a quick peak at it ... ftp://ftp.postgresql.org/pub/source/v7.3.5 Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast

Re: [HACKERS] Minor (very) feature request...

2003-12-04 Thread Marc G. Fournier
birth are now laughing out loud. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ

[HACKERS] 7.4.1 looking good for Wednesday?

2003-12-05 Thread Marc G. Fournier
As Tom mentioned previous, we are aiming for 7.4.1 on Wednesday of next week ... is anyone sitting on anything that they feel *just has to* be in it? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy

[HACKERS] 7.4.1 ... slight change of scheduale ...

2003-12-05 Thread Marc G. Fournier
To accomodate ppls travel scheduales, we are going to move the 7.4.1 release up to Monday, *unless* there is a report before then about something that needs to be fixed first ... we know of nothing outstanding right now ... This means it will be tag'd/bundled on Sunday ... Marc G

Re: [HACKERS] 7.4.1 ... slight change of scheduale ...

2003-12-05 Thread Marc G. Fournier
On Fri, 5 Dec 2003, Peter Eisentraut wrote: Marc G. Fournier writes: To accomodate ppls travel scheduales, we are going to move the 7.4.1 release up to Monday, *unless* there is a report before then about something that needs to be fixed first ... we know of nothing outstanding right

Re: [HACKERS] 7.4.1 ... slight change of scheduale ...

2003-12-05 Thread Marc G. Fournier
On Sat, 6 Dec 2003, Peter Eisentraut wrote: Marc G. Fournier wrote: A bug in the information schema concerning the bit types must be fixed. Does anyone have a patch for this? I suppose not, but it's being worked on. Is that the one that Joe just mentioned workign on? about BYTEA

Re: [HACKERS] [COMMITTERS] pgsql-server/src/bin/initdb nls.mk po/it.po

2003-12-11 Thread Marc G. Fournier
little while, and have been grabbing emails as I can .. will try and get you setup during the day tomrorow, sorry ;( Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664

Re: [HACKERS] Resurrecting pg_upgrade

2003-12-12 Thread Marc G. Fournier
, in the case of pg_upgrade, wouldn't just disabling access from anywhere except localhost prevent others from getting in? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664

Re: [HACKERS] Resurrecting pg_upgrade

2003-12-12 Thread Marc G. Fournier
than copying all the files to a new PGDATA ... being able to do a dump to a gzip'd tar file might be an option here also ... should take a significantly less footprint to create the backup, and on an idle server, shouldn't take any longer then other backup methods ... Marc G. Fournier

Re: [HACKERS] Limiting per user and per db accesse (was TODO list)

2003-12-17 Thread Marc G. Fournier
, through GRANT/REVOKE ... why couldn't we do similar at the database level? If you were to know that the database *had* per group restrictions, when you check # of connections, all you'd need to do is figure out if user is part of GroupA and, if so, increment that count ... no? Marc G. Fournier

Re: [HACKERS] replace all with * in pg_hba.conf

2003-12-19 Thread Marc G. Fournier
grounds. why not do both, but deprecate the use of all in the docs? say with an eventual goal of removing the use of all altogether in 2 releases? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ

Re: [HACKERS] [pgsql-advocacy] PostgreSQL speakers needed for OSCON 2004

2003-12-20 Thread Marc G. Fournier
mentioned that the 'fees' were relatively high though ... that you lose a fair amount off the top *to* Sourceforge? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664

Re: [HACKERS] [pgsql-advocacy] PostgreSQL speakers needed for OSCON 2004

2003-12-21 Thread Marc G. Fournier
much money in the way of fees ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 5: Have you checked our

[HACKERS] 7.4.1 tag'd and bundled ...

2003-12-21 Thread Marc G. Fournier
will do a general announce Monday afternoon, but if someone can test and confirm that I haven't missed anything, that would be great... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664

Re: [HACKERS] [COMMITTERS] pgsql-server/doc/src/sgml Tag: REL7_4_STABLE

2003-12-22 Thread Marc G. Fournier
? or maybe a 'make release_prep' target could be created, that would include stuff like this that gets done just before release? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664

Re: [HACKERS] [COMMITTERS] pgsql-server/doc/src/sgml Tag: REL7_4_STABLE

2003-12-22 Thread Marc G. Fournier
here, but how up to date is HISTORY in CVS to start with? I don't go out of my way to watch for them, but commits to HISTORY don't seem to be all that often to start with ... and how many ppl actually look at the HISTORY file *except* at release time? Marc G. Fournier Hub.Org

Re: [HACKERS] [COMMITTERS] pgsql-server/doc/src/sgml Tag: REL7_4_STABLE

2003-12-22 Thread Marc G. Fournier
On Mon, 22 Dec 2003, Bruce Momjian wrote: Marc G. Fournier wrote: On Mon, 22 Dec 2003, Bruce Momjian wrote: The only problem with removing HISTORY from CVS is that we will not have an easily reable list of release changes _until_ we package the release. Perhaps we should keep

Re: [HACKERS] [COMMITTERS] pgsql-server/doc/src/sgml Tag: REL7_4_STABLE

2003-12-22 Thread Marc G. Fournier
... ? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

  1   2   3   4   5   6   7   8   9   10   >