Re: [HACKERS] Dual-CPU slower then Single under HP?

2001-06-06 Thread The Hermit Hacker
Great, thanks :) On Wed, 6 Jun 2001, Tom Lane wrote: > The Hermit Hacker <[EMAIL PROTECTED]> writes: > > So, this is one of those "known problem, improved in v7.2" sort of issues? > > Yup. > > regards, tom lane > Marc G

Re: AW: [HACKERS] Postgres Replication

2001-06-12 Thread The Hermit Hacker
which I believe is what the rserv implementation in contrib currently does ... no? its funny ... what is in contrib right now was developed in a weekend by Vadim, put in contrib, yet nobody has either used it *or* seen fit to submit patches to improve it ... ? On Tue, 12 Jun 2001, Zeugswetter A

Re: AW: [HACKERS] vacuum

2001-06-13 Thread The Hermit Hacker
On Wed, 13 Jun 2001, Zeugswetter Andreas SB wrote: > > > Is there a relative consensus for how often to run vacuum? I have a > > table of about 8 columns that I fill with 100,000 items simply via a "\i > > alarms.sql". After 1,000 items or so it gets extremely slow to fill with > > data, and

Re: AW: [HACKERS] vacuum

2001-06-13 Thread The Hermit Hacker
8k ... On Wed, 13 Jun 2001, Andy Samuel wrote: > The same question ... how's the size after you vacuum the tables/db ? > > > continuous UPDATEs happening to his table, no INSERTs, no DELETEs ... and > > his tables quicklky grow from a 8k table to 65Meg if there is no vacuum > > happening every

RE: [HACKERS] vacuum

2001-06-13 Thread The Hermit Hacker
Now that you've narrowed it down to a specific table, at least you can specifically vacuum just that table and ignore the rest of the database ...might help a bit? On Wed, 13 Jun 2001, Mike Cianflone wrote: > After the comment by someone about the UPDATE being responsible for > the reason

[HACKERS] v7.1.1 Branched, Packaged and Released ...

2001-05-05 Thread The Hermit Hacker
This is just a quick announcement that we have now branched off v7.1.x from the main development tree, and are starting to dive into development of v7.2 ... There have been several changes since v7.1 was released, including: Fix for numeric MODULO operator (Tom) pg_dump fixes (Philip) pg_dump c

[HACKERS] Re: [GENERAL] v7.1.1 Branched, Packaged and Released ...

2001-05-07 Thread The Hermit Hacker
takes Vince a day or two to catch up ... yes, we are officially released, and Tom just dump'd some major stats changes into HEAD ... On Mon, 7 May 2001, Tatsuo Ishii wrote: > Does this mean that we have officially released 7.1.1? I could not > find any statements regarding 7.1.1 on the web pag

Re: [HACKERS] Shared library versions

2001-05-09 Thread The Hermit Hacker
On Wed, 9 May 2001, Peter Eisentraut wrote: > We did not bump the shared library versions before the 7.1 release. > Maybe we should do this before 7.1.2 goes out. Ummm ... unless there are any changes that would require someone to recompile their apps between v7.1.1 and v7.1.2, I don't think so

Re: [HACKERS] Shared library versions

2001-05-09 Thread The Hermit Hacker
On Wed, 9 May 2001, Bruce Momjian wrote: > > We did not bump the shared library versions before the 7.1 release. > > Maybe we should do this before 7.1.2 goes out. > > I thought I did that long ago for 7.1, or I should have anyway. I don't > see the commits either. Seems we can't do it in a min

Re: [HACKERS] Shared library versions

2001-05-09 Thread The Hermit Hacker
On Wed, 9 May 2001, Peter Eisentraut wrote: > I'm talking about the minor number. The only thing that effects is > that executables would pick up the new version if they have the old > one in the path as well, no potential problems. Okay, but, what does that buy you? One overwrites the old lib

Re: [HACKERS] 7.1.2 release

2001-05-10 Thread The Hermit Hacker
On Thu, 10 May 2001, Bruce Momjian wrote: > Are we releasing tomorrow. I will stamp the CVS STABLE branch tonight > as 7.1.2. Not that I'm aware of ... I heard mention something about a couple of fixes, but we *just* put out 7.1.1 ... If ppl are affected by the bugs, use cvsup and set yoru tag

Re: [HACKERS] 7.1.2 release

2001-05-10 Thread The Hermit Hacker
On Thu, 10 May 2001, Tom Lane wrote: > Hiroshi Inoue <[EMAIL PROTECTED]> writes: > > I agree with you because the bug is very critical. > > Yes, I'd like to get that plpgsql bug fix out as soon as possible. Isn't this only critical for those that are using it? Does it affect those that don't us

Re: [HACKERS] REL7_1_STABLE tag/branch

2001-05-11 Thread The Hermit Hacker
it is a branch ... for lack of a better way to work it: symbolic names: REL7_1_STABLE: 1.106.0.2 REL7_1_BETA: 1.79 REL7_1_BETA3: 1.86 REL7_1_BETA2: 1.86 REL7_1: 1.102 REL7_0_PATCHES: 1.70.0.2 REL7_0: 1.70 REL6_5_PATCHES: 1.52.0.2

Re: [HACKERS] 7.1.2 release

2001-05-11 Thread The Hermit Hacker
On Thu, 10 May 2001, Tom Lane wrote: > The Hermit Hacker <[EMAIL PROTECTED]> writes: > > Isn't this only critical for those that are using it? Does it affect > > those that don't use plpgsql? > > No, but I think it's pretty critical for those that do

Re: [HACKERS] pg_index.indislossy

2001-05-14 Thread The Hermit Hacker
On Mon, 14 May 2001, Bruce Momjian wrote: > > Bruce Momjian wrote: > > > > > > Can someone tell me what we use indislossy for? > > > > IIRC it means that if you get something by this index you must check > > again in the actual data > > > > I think that at least the GIST intarray (actually intset

Re: [HACKERS] Upgrade issue (again).

2001-05-16 Thread The Hermit Hacker
On Wed, 16 May 2001, Lamar Owen wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > I am loathe to even bring this up, but with two messages today about it, I am > going to be short and sweet: > > We don't have a reasonable upgrade path. ASCII dump->install > new->initdb->restore is not

Re: [HACKERS] Upgrade issue (again).

2001-05-17 Thread The Hermit Hacker
On Thu, 17 May 2001, Lamar Owen wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Wednesday 16 May 2001 19:05, The Hermit Hacker wrote: > > On Wed, 16 May 2001, Lamar Owen wrote: > > > I am loathe to even bring this up, but with two messages today about

Re: [HACKERS] Plans for solving the VACUUM problem

2001-05-20 Thread The Hermit Hacker
On Sun, 20 May 2001, Vadim Mikheev wrote: > > >> 1. Space reclamation via UNDO doesn't excite me a whole lot, if we can > > >> make lightweight VACUUM work well. > > > > > Sorry, but I'm going to consider background vacuum as temporary solution > > > only. As I've already pointed, original PG aut

Re: [HACKERS] Not released yet, but could someone take a quick peak...

2001-05-23 Thread The Hermit Hacker
which ones should I pull in? the ones in ~/ftp/pub/doc/7.1? or is there newer along that tree that we need to generate? On Tue, 22 May 2001, Peter Eisentraut wrote: > The Hermit Hacker writes: > > > ftp://ftp.postgresql.org/pub/source/v7.1.2 ... > > > > Just want a

Re: [HACKERS] Not released yet, but could someone take a quick peak...

2001-05-23 Thread The Hermit Hacker
all mirrors use rsync to update their code, and all of those that are listed at www.postgresql.org, both ftp and www, are no more then 2 days old (Vince, it is two days we set it at, right?) ... On Wed, 23 May 2001, bpalmer wrote: > On Wed, 23 May 2001, Tom Lane wrote: > > > every time I've tr

Re: [HACKERS] Not released yet, but could someone take a quick peak...

2001-05-24 Thread The Hermit Hacker
later this evening after some of the mirrors have had a chance to download ... On Wed, 23 May 2001, Peter Eisentraut wrote: > The Hermit Hacker writes: > > > which ones should I pull in? the ones in ~/ftp/pub/doc/7.1? or is there > > newer along that tree that we need to gen

Re: [CORE] Re: [HACKERS] Mirrors not tracking main ftp site?

2001-06-05 Thread The Hermit Hacker
okay, just removed the .hidden directory from the ftp server, which should correct that ... I had setup that .hidden directory to be excluded though, not sure why it was bothering things :( On Mon, 4 Jun 2001, bpalmer wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > > However, it se

RE: [HACKERS] Baby girl

2001-06-11 Thread The Hermit Hacker
trust me ... girls are soo much fun ... *roll eyes* *watches for lightening* On Mon, 11 Jun 2001, Mikheev, Vadim wrote: > > I had a baby girl on Tuesday. I am working through my > > backlogged emails > > today. > > Congratulations -:) > > Vadim > > ---(end of broad

[HACKERS] Re: fts.postgresql.org ?

2001-06-15 Thread The Hermit Hacker
already fixed ... On Fri, 15 Jun 2001, Oleg Bartunov wrote: > Marc, > > when I try to reach http://fts.postgresql.org/ I see > http://www.hub.org/ > > what's happens ? > > Regards, > Oleg > _ > Oleg Bartunov, sci.re

Re: [HACKERS] Doc translation

2001-06-18 Thread The Hermit Hacker
Tatsuo ... setting up a seperate CVS module for this does sound like a great idea ... you already have access to the CVS repository, right? Can you send me a tar file containing what you have so far, and I'll get it into CVS and then you'll be able to update that at will? If we set it up as: p

Re: [HACKERS] Doc translation

2001-06-18 Thread The Hermit Hacker
On Mon, 18 Jun 2001, Peter Eisentraut wrote: > Tatsuo Ishii writes: > > > Hi, some PostgreSQL users in Japan have been translating 7.1 docs into > > Japanese. I hope the work would finish within 1-2 months. My question > > is how the translated docs could be merged into the doc source tree > > on

[HACKERS] LEFT JOIN ...

2001-06-18 Thread The Hermit Hacker
Morning ... I'm trying to wrack my brain over something here, and no matter how I try and look at it, I'm drawing a blank ... I have two tables that are dependent on each other: notes (86736 tuples) and note_links (173473 tuples) The relationship is that one no

[HACKERS] Re: [SQL] LEFT JOIN ...

2001-06-18 Thread The Hermit Hacker
On Mon, 18 Jun 2001, Tom Lane wrote: > The Hermit Hacker <[EMAIL PROTECTED]> writes: > > FROM note_links nl, notes n LEFT JOIN calendar c ON (n.nid = c.nid) > > WHERE (n.type = 'A' OR n.type = 'N' OR n.type = 'H' OR n.type = 

Re: [HACKERS] Universal admin frontend

2001-06-19 Thread The Hermit Hacker
something like this, web based, would be most cool ... have to be able to monitor multiple port/backends too ... On Tue, 19 Jun 2001, [iso-8859-1] Pedro Abelleira Seco wrote: > Hi all! > > I'm thinking about starting a (serius) project to > bring a good graphical interface to the administration

[HACKERS] Re: [SQL] LEFT JOIN ...

2001-06-18 Thread The Hermit Hacker
Perfect, thank you ... i knew I was overlooking something obvious ... the query just flies now ... On Mon, 18 Jun 2001, Tom Lane wrote: > The Hermit Hacker <[EMAIL PROTECTED]> writes: > >> Try adding ... AND n.nid = 15748 ... to the WHERE. > > > n.nid is the note

Re: [HACKERS] 7.2 stuff

2001-06-20 Thread The Hermit Hacker
On Thu, 21 Jun 2001, Tom Lane wrote: > "Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > > How far off is 7.2? Ages? > > Hopefully not. I'd like to see us get back on a reasonably short > release cycle, like every six months or less --- the last couple > major release cycles have been pai

Re: [HACKERS] Pg on SMP half-powered

2001-07-05 Thread The Hermit Hacker
What is the postgres process doing? what does iostat show for disk I/O? from reading this, you are comparing apples->oranges ... are the drives the same on the non-SMP as the SMP? amount of RAM? speed of CPUs? hard drive controllers with same amount of cache on them? etc, etc, etc ... On Thu

[HACKERS] Re: hub.org out of disk space

2001-07-20 Thread The Hermit Hacker
there, and I just cleared out about 500Meg+ of old garbage ... 1.2gig free again ... On Fri, 20 Jul 2001, Chris Bowlby wrote: > On Thu, 19 Jul 2001, Tom Lane wrote: > > Hi Tom, > > I removed an ISO that Corey had made for me, that should free up some > space. > > > /home/projects/pgsql partiti

Re: [HACKERS] Gram.y patches for better parenthesis handling.

2000-10-28 Thread The Hermit Hacker
On Sat, 28 Oct 2000, Larry Rosenman wrote: > Err, with Tom's objections, why was this applied? was going to ask this too ... someone going patch-happy again? :) > * Bruce Momjian <[EMAIL PROTECTED]> [001028 11:34]: > > Applied. Thanks. > > > > > > > Okay, here's my attempt at fixing the pr

hrmmmm ... ignore ...

2000-10-29 Thread The Hermit Hacker
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org

okay, retry this one ...

2000-10-29 Thread The Hermit Hacker
something screwed up, possibly in the configs ... subscriptions should all be fine, but have to fix the configurations after getting these reloaded ... Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED]

[HACKERS] checking new server ...

2000-10-29 Thread The Hermit Hacker
one list at a time, I move and test .. -hackers is the second ... Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org

Re: [HACKERS] another try

2000-10-29 Thread The Hermit Hacker
is anyone else getting these but me? On Sun, 29 Oct 2000, Marc G. Fournier wrote: > > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org

Re: [HACKERS] WAL status update

2000-10-30 Thread The Hermit Hacker
I believe that its just resting on Vadim again to give us the go ahead ... which I believe its always been on his shoulders, no? :) Vadim? On Mon, 30 Oct 2000, Peter Eisentraut wrote: > Vadim Mikheev writes: > > > WAL todo list looks like: > > So what's the latest on going beta? > > -- >

Re: [HACKERS] Re: [GENERAL] Query caching

2000-10-31 Thread The Hermit Hacker
On Tue, 31 Oct 2000, Alfred Perlstein wrote: > * Steve Wolfe <[EMAIL PROTECTED]> [001031 13:47] wrote: > > > > > >(Incidentally, we've toyed around with developping a > > query-caching > > > > system that would sit betwen PostgreSQL and our DB libraries. > > > > > > Sounds amazing, but

[HACKERS] Mailing List Slowdowns ...

2000-10-27 Thread The Hermit Hacker
As a large part of you will have noticed by now, this past week has been killer on the mailing lists. One of the web clients on that machine decided to not warn us of one of their countries holidays, and, as a result, we got hit with a diluge of hits, similar to a slashdot effect ... We ordered

[HACKERS] READ THIS: changes in mailing list ...

2000-10-29 Thread The Hermit Hacker
Morning all ... Today, we are moving the mailing lists over to the new mail server. There *might* be a brief period where any mail sent to the lists will be returned with a 'user unknown' error, as there will be a brief period where the aliases will be disabled on the old server and the

RE: [HACKERS] list owner please help me get off the list.

2000-11-01 Thread The Hermit Hacker
even better, of course, is the fact that you aren't even on this list: Majordomo>unsubscribe pgsql-hackers [EMAIL PROTECTED] Cannot unsubscribe [EMAIL PROTECTED]: no matching addresses. On Wed, 1 Nov 2000, Jones, Colin wrote: > I want off this list immediately!!! If I am not o

[HACKERS] Re: [CORE] 7.0.3 Release date?

2000-11-01 Thread The Hermit Hacker
sounds great, then hopefully we get v7.0.3 out early next week :) thanks ... On Wed, 1 Nov 2000, Bruce Momjian wrote: > I am back, and will resolve the cvs and brand 7.0.3 tomorrow. > > > > > > this week, once I hear from bruce that he's ready ... last I heard, he was > > back with his old

Re: [HACKERS] Re: [CORE] 7.0.3 Release date?

2000-11-02 Thread The Hermit Hacker
On Wed, 1 Nov 2000, Bruce Momjian wrote: > Yes, sorry about the delay. Also, I will send a report to core about > the summit. is there a reason why -hackers wouldn't be interested as well? *raised eyebrow* > > > > > sounds great, then hopefully we get v7.0.3 out early next week :) thanks >

Re: [HACKERS] me too

2000-11-02 Thread The Hermit Hacker
okay, to date I've just been manually fixing stuff like this, but its time to debug what the problem is here ... so, what have you tried to do to set it as digest, and what error did you get? On Thu, 2 Nov 2000 [EMAIL PROTECTED] wrote: > >> I too got somehow on the list without subscribing. >

Re: [HACKERS] me too

2000-11-03 Thread The Hermit Hacker
sorry, the migration this past weekend was to remove all traces of hub.org from the list addresses ... we built a 'virtual server' that now houses the postgresql.org mailing lists, so you need to send to [EMAIL PROTECTED], and it should work ... please try that and let me know if it works or not

[HACKERS] v7.0.3 *pre-release* ...

2000-11-04 Thread The Hermit Hacker
In order that we can get a few days of testing on these, make sure the packaging is right and whatnot, we are holding off on a formal release until early->mid next week ... I've just put pre-release tar balls into: ftp://ftp.postgresql.org/pub/source/v7.0.3 Please take a minute to down

Re: [HACKERS] Re: [COMMITTERS] pgsql/contrib/pg_dumpaccounts (MakefileREADME pg_dumpaccounts.sh)

2000-11-02 Thread The Hermit Hacker
On Thu, 2 Nov 2000, Tom Lane wrote: > Ned Lilly <[EMAIL PROTECTED]> writes: > > Well, here in relatively minor form is the First Example of a Great > > Bridge Priority (which Tom, Bruce, and Jan have all predicted would > > come... ;-) > > Hmm. I wasn't aware that Jan had done it at Great Bri

Re: [HACKERS] Re: [COMMITTERS] pgsql/contrib/pg_dumpaccounts (MakefileREADME pg_dumpaccounts.sh)

2000-11-02 Thread The Hermit Hacker
On Thu, 2 Nov 2000, Bruce Momjian wrote: > > Ned Lilly <[EMAIL PROTECTED]> writes: > > > Well, here in relatively minor form is the First Example of a Great > > > Bridge Priority (which Tom, Bruce, and Jan have all predicted would > > > come... ;-) > > > > Hmm. I wasn't aware that Jan had don

Re: [HACKERS] More cvs branch problems

2000-11-02 Thread The Hermit Hacker
On Thu, 2 Nov 2000, Tom Lane wrote: > Lamar Owen <[EMAIL PROTECTED]> writes: > > I do have a question -- just how much configuration (and other) changes > > occurred to REL7_0_PATCHES (since the logs seem to not be telling the > > whole story)? > > I say this because I found at least one such cha

Re: [HACKERS] Re: [COMMITTERS] pgsql/contrib/pg_dumpaccounts (MakefileREADME pg_dumpaccounts.sh)

2000-11-02 Thread The Hermit Hacker
On Thu, 2 Nov 2000, Ned Lilly wrote: > We recognize this is a temporary hack - and fully expect it to go away > in 7.1 We actually think that the final solution might be more > appropriate in pg_dump itself than pg_dumpall, but that's obviously a > much more breakable proposition (hence the separ

Re: [HACKERS] Re: [COMMITTERS] pgsql/contrib/pg_dumpaccounts (MakefileREADME pg_dumpaccounts.sh)

2000-11-02 Thread The Hermit Hacker
On Thu, 2 Nov 2000, Tom Lane wrote: > The Hermit Hacker <[EMAIL PROTECTED]> writes: > > I do feel strongly about this ... 7.0.3 was considered in a release state > > *before* it was committed, pending your docs changes ... personally, if we > > leave this in contrib,

[HACKERS] How to get around LIKE inefficiencies?

2000-11-05 Thread The Hermit Hacker
I'm tryin to figure out how to speed up udmsearch when run under postgresql, and am being hit by atrocious performance when using a LIKE query ... the query looks like: SELECT ndict.url_id,ndict.intag FROM ndict,url WHERE ndict.word_id=1971739852 AND url.rec_id=ndict.url_id AND (ur

Re: [HACKERS] How to get around LIKE inefficiencies?

2000-11-05 Thread The Hermit Hacker
yowch ... removing that one index makes my 'test' search (mvcc) come back as: [97366] SQL 0.05s: SELECT ndict.url_id,ndict.intag FROM ndict,url WHERE ndict.word_id=572517542 AND url.rec_id=ndict.url_id AND (url.url LIKE 'http://www.postgresql.org/%') vs what we were doing before ... now, let

Re: [HACKERS] How to get around LIKE inefficiencies?

2000-11-05 Thread The Hermit Hacker
On Mon, 6 Nov 2000, Philip Warner wrote: > At 21:59 5/11/00 -0500, Tom Lane wrote: > > > >Looks like a great kluge to me ;-) > > > > Hmph. I prefer to think of it as a 'user-defined optimizer hint'. ;-} Except, if we are telling it to get rid of using the index, may as well get rid of it altoge

Re: [HACKERS] How to get around LIKE inefficiencies?

2000-11-05 Thread The Hermit Hacker
On Sun, 5 Nov 2000, Tom Lane wrote: > The Hermit Hacker <[EMAIL PROTECTED]> writes: > > On Mon, 6 Nov 2000, Philip Warner wrote: > >> At 21:59 5/11/00 -0500, Tom Lane wrote: > >>>> Looks like a great kluge to me ;-) > >> > >> Hmph.

Re: [HACKERS] How to get around LIKE inefficiencies?

2000-11-05 Thread The Hermit Hacker
On Mon, 6 Nov 2000, Philip Warner wrote: > At 23:12 5/11/00 -0400, The Hermit Hacker wrote: > > > >Except, if we are telling it to get rid of using the index, may as well > >get rid of it altogether, as updates/inserts would be slowed down by > >having to update that

Re: [HACKERS] How to get around LIKE inefficiencies?

2000-11-05 Thread The Hermit Hacker
On Sun, 5 Nov 2000, Bruce Momjian wrote: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > I am adding a new TODO item: > > > * Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM > > > ANALYZE, and CLUSTER > > > Seems we should be able to emit NOTICE messages suggesting perf

Re: [HACKERS] CVS problem

2000-11-06 Thread The Hermit Hacker
what version of CVS are you running? when was the last time you did anything with it? cvs on hub hasn't been upgraded since Sept 13th, so it isn't an upgrade issue ... and just tested from work, and I can checkout no probs ... On Mon, 6 Nov 2000, Michael Meskes wrote: > Here's what I get

RE: [HACKERS] list owner please help me get off the list.

2000-11-01 Thread The Hermit Hacker
ya know, I always love seeing email's like this ... what time do you consider to be the end of the day? and going directly to the top means talking to ... wow, me. and its the end of my day here, and I don't have you off yet, so now you are in a pickle, no? :) On Wed, 1 Nov 2000, Jones, Colin

Re: [HACKERS] 7.0.2 dies when connection dropped mid-transaction

2000-11-09 Thread The Hermit Hacker
On Thu, 9 Nov 2000, Alfred Perlstein wrote: > * Bruce Momjian <[EMAIL PROTECTED]> [001109 18:55] wrote: > > > I guess the immediate question is do we want to hold up 7.0.3 release > > > for a fix? This bug is clearly ancient, so I'm not sure it's > > > appropriate to go through a fire drill to f

Re: [HACKERS] 7.0.2 dies when connection dropped mid-transaction

2000-11-09 Thread The Hermit Hacker
On Thu, 9 Nov 2000, Tom Lane wrote: > The Hermit Hacker <[EMAIL PROTECTED]> writes: > > Tom, if you can plug this one in the next, say, 48hrs (Saturday night), > > Done. Want to generate some new 7.0.3 release-candidate tarballs? Done, and just forced a sync to ftp.post

Re: AW: [HACKERS] v7.0.3 *pre-release* ...

2000-11-07 Thread The Hermit Hacker
If its that easy to fix the regress test so that it passes, can we get it committed and build a new tarball so that ppl doing regression on v7.0.3 see a clean regress? On Tue, 7 Nov 2000, Tom Lane wrote: > Pete Forman <[EMAIL PROTECTED]> writes: > > The only remaining failure is geometry. The

[HACKERS] Re: FW: Returned mail: see transcript for details

2000-11-13 Thread The Hermit Hacker
fixed, let mek now if there are any others I've missed ... On Mon, 13 Nov 2000, Larry Rosenman wrote: > Are the @postgresql.org addresses supposed to work? > > > > -Original Message- > From: Mail Delivery Subsystem [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 13, 2000 4:13 PM

Re: [HACKERS] why transfer limits on ftp.postgresql.org ?

2000-11-14 Thread The Hermit Hacker
On Tue, 14 Nov 2000, Hannu Krosing wrote: > when trying to do > > get -R RedHat-6.x RedHat-7.0 Mandrake-7.x > > I got > > get RedHat-7.0: server said: Permission denied on server. (Transfer > limits exceeded) > > aftre all of RedHat-6.x was retrieved > > is there any reason for this ? Yes,

Re: [HACKERS] IRC?

2000-11-14 Thread The Hermit Hacker
I'm at Comdex right now, but when I'm around, I'm on channel ... On Tue, 14 Nov 2000, Alfred Perlstein wrote: > I remeber a few developers used to gather on efnet irc, > there was a lot of instability recently that seems to have > cleared up even more recently. > > Are you guys planning on co

Re: [HACKERS] Re: [COMMITTERS] pgsql/contrib/pg_dumpaccounts (MakefileREADME pg_dumpaccounts.sh)

2000-11-04 Thread The Hermit Hacker
On Fri, 3 Nov 2000, Bruce Momjian wrote: > I have talked to GB and they understand their error. Until the next time? This isn't the first time you've "talked to them" ...

Re: [HACKERS] when will PostgreSQL 7.1?

2000-11-26 Thread The Hermit Hacker
On Sun, 26 Nov 2000, xuyifeng wrote: > Hi, > > can anyone tell me when Postgresql 7.1 will be released? about a month after it goes beta ... which should be over the next couple of weeks ...

Re: [HACKERS] Full text Indexing -out of contrib and into main..

2000-11-27 Thread The Hermit Hacker
On Mon, 27 Nov 2000, Bruce Momjian wrote: > > >Well, yes. Why isn't it? > > > > > >Full text indexing should be just as much a feature as any other key feature in > > >PG. > > >With the advent of unlimited file and record lengths in 7.1, this would be a good > > >time to > > >include it. > > > >

[HACKERS] [RELEASE ANNOUNCEMENT] v7.0.3 *Final* now Available

2000-11-12 Thread The Hermit Hacker
After a couple of pre-release tarballs, the PostgreSQL Developers are proud to announce v7.0.3, our most stable release yet. There have been *several* fixes in this release, from v7.0.2, but, being a minor release, there have been *no* changes that will require a dump/restore to happen ... down

Re: [HACKERS] beta testing version

2000-11-28 Thread The Hermit Hacker
On Tue, 28 Nov 2000, xuyifeng wrote: > no doubt, I have touched some problems PG has, right? if PG is so good, > is there any necessary for the team to improve PG again? There is always room for improvements for any software package ... whether it be PgSQL, Linux, FreeBSD or PHPBuilder ...

Re: [HACKERS] beta testing version

2000-11-28 Thread The Hermit Hacker
On Tue, 28 Nov 2000, xuyifeng wrote: > you are complete wrong, if I don't like PG, I'll never go here or talk > anything about PG, I don't care it. I just want PG can be improved > quickly, for me crash recover is very urgent problem, otherewise PG is > forced to stay on my desktop machine, We'll

Re: [HACKERS] beta testing version

2000-11-28 Thread The Hermit Hacker
On Tue, 28 Nov 2000, Hannu Krosing wrote: > xuyifeng wrote: > > > > I just noticed this conversation so I have not followed all of it, > but you seem to have strange priorities > > > I just want PG can be improved quickly, for me crash recover is very urgent >problem, > > Crash avoidance is

Re: [HACKERS] beta testing version

2000-11-28 Thread The Hermit Hacker
On Tue, 28 Nov 2000, Don Baccus wrote: > At 03:25 PM 11/28/00 -0700, Ron Chmara wrote: > >Mitch Vincent wrote: > >> > >> This is one of the not-so-stomped boxes running PostgreSQL -- I've never > >> restarted PostgreSQL on it since it was installed. > >> 12:03pm up 122 days, 7:54, 1 user, lo

Re: [HACKERS] Alpha FreeBSD port of PostgreSQL !!!

2000-11-03 Thread The Hermit Hacker
On Fri, 3 Nov 2000, Tom Lane wrote: > The Hermit Hacker <[EMAIL PROTECTED]> writes: > > Jeff, feel like trying out the True64 install and seeing how it > > goes? Worst case, we have to install Redhat from scratch *shrug* > > > Tom, anything on that machine that

[GENERAL] Re: [HACKERS] Alpha FreeBSD port of PostgreSQL !!!

2000-11-03 Thread The Hermit Hacker
On Fri, 3 Nov 2000, Tom Lane wrote: > Nathan Boeger <[EMAIL PROTECTED]> writes: > > is anyone working on the port of PostgreSQL for Alpha FreeBSD ?? > > Not that I know about. DEC/Compaq was kind enough to lend the project > an Alpha for testing, but it's running Linux (RedHat 6.2). We've als

Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-20 Thread The Hermit Hacker
On Mon, 20 Nov 2000, Don Baccus wrote: > At 09:43 AM 11/13/00 -0600, [EMAIL PROTECTED] wrote: > >I made it all the way through the article. I'll summarize it for you: > >Postgres - hooray! > >MySQL - boo! > >Since this is an open source database article linked off of slashdot, I > >imagine they'

Re: [HACKERS] beta testing version

2000-11-30 Thread The Hermit Hacker
v7.1 should improve crash recovery for situations like this ... you'll still have to do a recovery of the data on corruption of this magnitude, but at least with the WAL stuff that Vadim is producing, you'll be able to recover up until the point that the power cable was pulled out of the wall ...

Re: [HACKERS] beta testing version

2000-11-30 Thread The Hermit Hacker
On Thu, 30 Nov 2000, Don Baccus wrote: > At 07:02 PM 11/30/00 -0400, The Hermit Hacker wrote: > > > >v7.1 should improve crash recovery for situations like this ... you'll > >still have to do a recovery of the data on corruption of this magnitude, > >but at least

Re: [HACKERS] beta testing version

2000-11-30 Thread The Hermit Hacker
On Thu, 30 Nov 2000, Nathan Myers wrote: > On Thu, Nov 30, 2000 at 07:47:08PM -0400, The Hermit Hacker wrote: > > On Thu, 30 Nov 2000, Don Baccus wrote: > > > At 07:02 PM 11/30/00 -0400, The Hermit Hacker wrote: > > > > > > > >v7.1 should impro

Re: [HACKERS] beta testing version

2000-11-30 Thread The Hermit Hacker
On Thu, 30 Nov 2000, Nathan Myers wrote: > On Thu, Nov 30, 2000 at 07:02:01PM -0400, The Hermit Hacker wrote: > > > > v7.1 should improve crash recovery ... > > ... with the WAL stuff that Vadim is producing, you'll be able to > > recover up until the point tha

Re: [HACKERS] Mailing list archives available?

2000-10-24 Thread The Hermit Hacker
On Tue, 24 Oct 2000, Vince Vielhaber wrote: > On Tue, 24 Oct 2000, The Hermit Hacker wrote: > > > > > http://www.postgresql.org/mhonarc has them all listed .. not sure how to > > get there from the Web site ... Vince? > > There are links from both the Develo

Re: [HACKERS] beta testing version

2000-12-03 Thread The Hermit Hacker
On Sat, 2 Dec 2000, Adam Haberlach wrote: > In any case, can we create pgsql-politics so we don't have to go over > this issue every three months? Can we create pgsql-benchmarks while we > are at it, to take care of the other thread that keeps popping up? no skin off my back: pgs

Re: [HACKERS] beta testing version

2000-12-03 Thread The Hermit Hacker
On Sat, 2 Dec 2000, Don Baccus wrote: > > I *am* one of those volunteers > > Yes, I well remember you screwing up PG 7.0 just before beta, without bothering > to test your code, and leaving on vacation. > > You were irresponsible then, and you're being irresponsible now. Okay, so let me get

Re: [HACKERS] beta testing version

2000-12-03 Thread The Hermit Hacker
On Mon, 4 Dec 2000, Horst Herb wrote: > > > Branding. Phone support lines. Legal departments/Lawsuit prevention. > Figuring > > > out how to prevent open source from stealing the thunder by duplicating > ^^ > > > features. And building

Re: [HACKERS] beta testing version

2000-12-03 Thread The Hermit Hacker
On Sun, 3 Dec 2000, Hannu Krosing wrote: > The Hermit Hacker wrote: > > > > On Sat, 2 Dec 2000, Don Baccus wrote: > > > > > > I *am* one of those volunteers > > > > > > Yes, I well remember you screwing up PG 7.0 just before beta, withou

Re: [HACKERS] beta testing version

2000-12-03 Thread The Hermit Hacker
On Sun, 3 Dec 2000, mlw wrote: > Hannu Krosing wrote: > > > I know this is a borderline rant, and I am sorry, but I think it is very > > > important that the integrity of open source be preserved at 100% because > > > it is a very slippery slope, and we are all surrounded by the temptation > > >

Re: [HACKERS] beta testing version

2000-12-03 Thread The Hermit Hacker
On Sun, 3 Dec 2000, Gary MacDougall wrote: > > If you write a program which stands on its own, takes no work from > > uncompensated parties, then you have the unambiguous right to do what > > ever you want. > > Thats a given. okay, then now I'm confused ... neither SePICK or erServer are derive

Re: [HACKERS] beta testing version

2000-12-03 Thread The Hermit Hacker
On Sun, 3 Dec 2000, Don Baccus wrote: > At 11:00 PM 12/2/00 -0800, Vadim Mikheev wrote: > >> There is risk here. It isn't so much in the fact that PostgreSQL, Inc > >> is doing a couple of modest closed-source things with the code. After > >> all, the PG community has long acknowleged that the

Re: [HACKERS] beta testing version

2000-12-03 Thread The Hermit Hacker
On Sun, 3 Dec 2000, Ross J. Reedstrom wrote: > > If this is the impression that someone gave, I am shocked ... Thomas > > himself has already posted stating that it was a scheduale slip on his > > part. > > Actually, Thomas said: > > Thomas> Hmm. What has kept replication from happening in th

Re: [HACKERS] beta testing version

2000-12-03 Thread The Hermit Hacker
... pretty much, ya, that sums it up ... > ----- Original Message - > From: "The Hermit Hacker" <[EMAIL PROTECTED]> > To: "Gary MacDougall" <[EMAIL PROTECTED]> > Cc: "mlw" <[EMAIL PROTECTED]>; "Hannu Krosing" <[EMAIL PROTECTED]>

Re: [HACKERS] beta testing version

2000-12-03 Thread The Hermit Hacker
On Sun, 3 Dec 2000, Ross J. Reedstrom wrote: > On Sun, Dec 03, 2000 at 08:53:08PM -0400, The Hermit Hacker wrote: > > On Sun, 3 Dec 2000, Gary MacDougall wrote: > > > > > > If you write a program which stands on its own, takes no work from > > > > u

Re: [HACKERS] beta testing version

2000-12-04 Thread The Hermit Hacker
On Sun, 3 Dec 2000, Don Baccus wrote: > At 11:59 PM 12/3/00 -0400, The Hermit Hacker wrote: > > the sanctity of the *core* server is *always* > >foremost in our minds, no matter what other projects we are working on ... > > What happens if financially things aren'

Re: [HACKERS] Using Threads?

2000-12-04 Thread The Hermit Hacker
On Mon, 27 Nov 2000, Junfeng Zhang wrote: > Hello all, > > I am new to postgreSQL. When I read the documents, I find out the > Postmaster daemon actual spawns a new backend server process to serve > a new client request. Why not use threads instead? Is that just for a > historical reason, or som

Re: [HACKERS] beta testing version

2000-12-04 Thread The Hermit Hacker
On Mon, 4 Dec 2000, Don Baccus wrote: > >A recent example of non-sinister change in another area is the work done > >to release 7.0.3. This is a release which would not have happened in > >previous cycles, since we are so close to beta on 7.1. But GB paid Tom > >Lane to work on it as part of *the

Re: [HACKERS] Using Threads?

2000-12-04 Thread The Hermit Hacker
if we were to do this in steps, I beliee that one of the major problems irght now is that we have global variables up the wazoo ... my 'thread-awareness' is limited, as I've yet to use them, so excuse my ignorance ... if we got patches that cleaned up the code in stages, moving towards a cleaner

Re: [HACKERS] beta testing version

2000-12-05 Thread The Hermit Hacker
On Tue, 5 Dec 2000, Martin A. Marques wrote: > On Sunday 03 December 2000 04:00, Vadim Mikheev wrote: > > > There is risk here. It isn't so much in the fact that PostgreSQL, Inc > > > is doing a couple of modest closed-source things with the code. After > > > all, the PG community has long ackn

[HACKERS] v7.1 beta 1 ...packaged, finally ...

2000-12-07 Thread The Hermit Hacker
Okay, since I haven't gotten word back on where to find the docs for v7.1, it still contains those for v7.0, but I just put up beta1 tarballs in the /pub/dev directory ... can someone take a look at these before we announce them to make sure they look okay? Marc G. Fournier IC

Re: [HACKERS] v7.1 beta 1 ...packaged, finally ...

2000-12-07 Thread The Hermit Hacker
On Thu, 7 Dec 2000, Martin A. Marques wrote: > On Thursday 07 December 2000 16:48, The Hermit Hacker wrote: > > Okay, since I haven't gotten word back on where to find the docs for v7.1, > > it still contains those for v7.0, but I just put up beta1 tarballs in the > >

<    1   2   3   4   5   6   >