Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-03 Thread Christopher Browne
The world rejoiced as [EMAIL PROTECTED] (Hannu Krosing) wrote: Christopher Browne kirjutas E, 03.11.2003 kell 02:15: Well, actually, the case where it _would_ be troublesome would be where there was a combination of huge tables needing vacuuming and smaller ones that are _heavily_ updated (e.g

[HACKERS] RC1 on AIX - working thus far

2003-11-03 Thread Christopher Browne
regress.o gmake[2]: Leaving directory `/opt/OXRS/PkgSrc/pgsql74-rc1/src/test/regress' gmake[1]: Leaving directory `/opt/OXRS/PkgSrc/pgsql74-rc1/src/test' bash-2.05a$ uname -a AIX ibm-db 1 5 000CD13A4C00 -- cbbrowne,@,libertyrms.info http://dev6.int.libertyrms.com/ Christopher Browne (416) 646 3304

Re: [HACKERS] RC1 on AIX - working thus far

2003-11-03 Thread Christopher Browne
Peter Eisentraut [EMAIL PROTECTED] writes: Christopher Browne writes: bash-2.05a$ uname -a AIX ibm-db 1 5 000CD13A4C00 We already have a report for AIX. Were you trying to indicate that this is a different variant thereof? I'm afraid I hadn't seen another AIX report; this may replicate

[HACKERS] RC1 on AIX - Some Anti-results

2003-11-04 Thread Christopher Browne
[EMAIL PROTECTED] (Peter Eisentraut) writes: Christopher Browne writes: bash-2.05a$ uname -a AIX ibm-db 1 5 000CD13A4C00 We already have a report for AIX. Were you trying to indicate that this is a different variant thereof? Actually, after some more work, there's an anomaly when

Re: [HACKERS] Open Sourcing pgManage

2003-11-05 Thread Christopher Browne
[EMAIL PROTECTED] (Greg Stark) writes: Andrew Dunstan [EMAIL PROTECTED] writes: I think there is room for lots of GUIs, though, and having a Java admin GUI would be cool too, as would having a servlet/JSP based admin client deployable as a web archive. If someone's looking for an

Re: [HACKERS] Performance features the 4th

2003-11-07 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Bruce Momjian) wrote: Tom Lane wrote: Jan Wieck [EMAIL PROTECTED] writes: As a matter of fact, people who have performance problems are likely to be the same who have upgrade problems. And as Gaetano pointed out correctly, we

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

2003-11-07 Thread Christopher Browne
= reverse(ofni.smrytrebil @ enworbbc) http://dev6.int.libertyrms.com/ Christopher Browne (416) 646 3304 x124 (land) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] cvs head? initdb?

2003-11-13 Thread Christopher Browne
reimplementing initdb in C. Jan checked in the ARC changes last night, and he and Tom ran into some problems, leading to that being pulled back out, while he revisits the code. -- select 'cbbrowne' || '@' || 'libertyrms.info'; http://dev6.int.libertyrms.com/ Christopher Browne (416) 646 3304 x124 (land

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

2003-11-14 Thread Christopher Browne
, I would be quick to test the patch to ensure it causes no adverse side-effects.) But it's not apparent that it is _vital_ here right now. -- let name=cbbrowne and tld=libertyrms.info in name ^ @ ^ tld;; http://dev6.int.libertyrms.com/ Christopher Browne (416) 646 3304 x124 (land

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

2003-11-18 Thread Christopher Browne
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Christoper Smiga) transmitted: 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. If

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

2003-11-18 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (ow) wrote: Have *never* seen ppl running Oracle or Sybase on Windows. I haven't seen Sybase on Windows (only barely have seen it anywhere, fitting with the comment made that it hides in the lucrative financial industry); I _have_

Re: [HACKERS] Release cycle length

2003-11-24 Thread Christopher Browne
Quoth [EMAIL PROTECTED] (Jim C. Nasby): On Fri, Nov 21, 2003 at 01:32:38PM -0500, Jan Wieck wrote: bootstrap mode to apply the changes, could be an idea to think of. It would still require some downtime, but nobody can avoid that when replacing the postgres binaries anyway, so that's not a

Re: [HACKERS] *sigh*

2003-11-29 Thread Christopher Browne
Oops! [EMAIL PROTECTED] (Gaetano Mendola) was seen spray-painting on a wall: Doug McNaught wrote: Randolf Richardson [EMAIL PROTECTED] writes: What about adding a total number of rows value to the internal header of each table which gets incremented/decremented after each row is

Re: [HACKERS] Max number of rows in a table

2003-12-01 Thread Christopher Browne
Clinging to sanity, [EMAIL PROTECTED] (ow) mumbled into her beard: --- Tom Lane [EMAIL PROTECTED] wrote: Wouldn't the above put a limit on a number of records one could have in table? No. If I understand correctly, a table that has 4B+ rows cannot be restored after the dump and that,

Re: [HACKERS] *sigh*

2003-12-02 Thread Christopher Browne
Martha Stewart called it a Good Thing when Randolf Richardson [EMAIL PROTECTED] wrote: The count(*) information can be revisioned too, am I wrong ? I'm able to create a trigger that store the count(*) information in a special table, why not implement the same in a way builded in ? Then

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-09 Thread Christopher Browne
[EMAIL PROTECTED] (Ivelin Ivanov) writes: Has this subject been discussed before? I did not find any references to it in the archives. I think that a co-bundle between an open source J2EE container like JBoss and a scalable database like PostgreSQL will be a blast. There are several well

Re: [HACKERS] WITH clause

2003-12-12 Thread Christopher Browne
[EMAIL PROTECTED] (David Fetter) wrote: I'm looking to the SQL WITH clause as a way to get better regex support in PostgreSQL. I've been chatting a little bit about this, and here's an idea for a behavior. Implementation details TBD. WITH res = match (x.foo, '([0-9]+)x([0-9]+)') SELECT *

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

2003-12-20 Thread Christopher Browne
[EMAIL PROTECTED] (Tom Lane) wrote: Christopher Kings-Lynne [EMAIL PROTECTED] writes: Speaking of fund raising, SourceForge has just started a 'donations' system whereby people can donate money to projects. Maybe you want to enable it on the PostgreSQL project. Uh ... there is no

Re: [HACKERS] What's planned for 7.5?

2004-01-12 Thread Christopher Browne
similar but _much_ less obscure/opaque with SLONY-1. We'll see what happens... Another fairly important item not mentioned: Nested Transactions. -- let name=cbbrowne and tld=libertyrms.info in String.concat @ [name;tld];; http://dev6.int.libertyrms.com/ Christopher Browne (416) 646 3304 x124

Re: [HACKERS] What's planned for 7.5?

2004-01-13 Thread Christopher Browne
];; http://dev6.int.libertyrms.com/ Christopher Browne (416) 646 3304 x124 (land) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] BUG #1053: Configuration should be in /etc/postgres

2004-01-17 Thread Christopher Browne
.int.libertyrms.com/ Christopher Browne (416) 646 3304 x124 (land) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Recursive queries?

2004-02-04 Thread Christopher Browne
Clinging to sanity, [EMAIL PROTECTED] (Andrew Rawnsley) mumbled into her beard: I haven't had any problems with it so far, although I haven't really stressed it yet. I was going to make this very plea... I agree that the syntax can probably be improved, but its familiar to those of us

Re: [HACKERS] PITR Dead horse?

2004-02-07 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Bruce Momjian) wrote: Austin Gonyou wrote: As previously stated by Bruce I believe, the mindshare department needs some work. For this, the PITR is a necessity, but also when comparing features with other DBs that people and

Re: [HACKERS] Vacuum Delay feature

2004-02-12 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Bruce Momjian) would write: I guess my question is that now that we have the new cache replacement policy, is the vacuum delay worth while. I looked at http://developer.postgresql.org/~wieck/vacuum_cost/ and does seem useful. They

Re: [HACKERS] Slony-I makes progress

2004-03-09 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] (Jochem van Dieten) wrote: Josh Berkus wrote: I personally don't think that a GUI tool should be the province of the Slony project. Seriously. I think that Slony should focus on a command-line api and catalogs, and allow the existing GUI

Re: [HACKERS] subversion vs cvs

2004-03-26 Thread Christopher Browne
After a long battle with technology, [EMAIL PROTECTED] (Marc G. Fournier), an earthling, wrote: On Tue, 23 Mar 2004, Sailesh Krishnamurthy wrote: Which brings me to another question .. has anybody considered using subversion instead of CVS ? Why? not that I'm for a chance from something

Re: [HACKERS] PITR for replication?

2004-04-06 Thread Christopher Browne
Oops! [EMAIL PROTECTED] (J. Andrew Rogers) was seen spray-painting on a wall: I may be completely missing the point here, but it looks to me as though the PITR archival mechanism is also most of a native replication facility. Is there anyone reason this couldn't be extended to replication,

Re: [HACKERS] PostgreSQL configuration

2004-04-09 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] (Kevin Brown) wrote: If we want to be a bit paranoid (justifiable if you've got really important data on the line), we could also require that a version string exist in the config file. If the version string doesn't match the version of the

Re: [HACKERS] The Tomb of the Unknown Type?

2004-04-09 Thread Christopher Browne
[EMAIL PROTECTED] (Tom Lane) wrote: The cure is to cast the literal to some specific type when you do the CREATE. I figured that was the case, and pointed that cure back to the developer. What I was hoping to hear was some way of coercing the data into a more usable type after the fact. The

Re: [HACKERS] Hacking MySQL Database

2004-05-11 Thread Christopher Browne
After takin a swig o' Arrakan spice grog, Anonymous [EMAIL PROTECTED] belched out: Does anybody here know how to hack into a mysql database? You might want to visit a mailing list devoted to MySQL; they might know... -- output = reverse(gro.gultn @ enworbbc)

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib,

2004-05-03 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Joshua D. Drake) would write: Personally, plpgSQL is only useful to those who are coming from Oracle. People are more likely to be comfortable with plPython or plPerl than plpgSQL. I beg to differ. In order to use pl/Python or

Re: [HACKERS] contrib vs. gborg/pgfoundry for replication solutions

2004-04-26 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Tom Lane) wrote: Joshua D. Drake [EMAIL PROTECTED] writes: My personal opinion is that contrib should be removed entirely. That's not real workable for code that is tightly tied to the backend, such as the various GIST index

Re: [HACKERS] pg_autovacuum crashes when query fails for temp

2004-04-26 Thread Christopher Browne
[EMAIL PROTECTED] (Matthew T. O'Connor) wrote: Bruce Momjian wrote: Should pg_autovacuum be vacuuming temporary tables? This is a good question, and I would like some opinions from some other people more informed than I. Secondly, why would a temporary table for another session be visible

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib, etc.

2004-04-26 Thread Christopher Browne
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] transmitted: Is anyone really ready for this sort of commitment? By that, I presume you mean... Are people prepared to stop working on the doubtless useful things that they are working on in favor of spending their time

Re: [HACKERS] Feature freeze approaching

2004-05-20 Thread Christopher Browne
After a long battle with technology, [EMAIL PROTECTED] (Magnus Hagander), an earthling, wrote: 2) Pick upt he default OS timezone. This still need a little bit more work. But the code as it stands on Win32 will give you GMT on startup unless you specify a TZ in postgresql.conf. On Unix, it

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-31 Thread Christopher Browne
On Fri, 2003-01-31 at 07:22, Christopher Browne wrote: But it's not /nearly/ that straightforward. If you look at the downloads that MySQL AB provides, they point you to a link that says Windows binaries use the Cygwin library. Which apparently means that this feature is not actually

Re: [HACKERS] location of the configuration files

2003-02-13 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] (Curt Sampson) wrote: On Wed, 12 Feb 2003, Peter Bierman wrote: What do you gain by having the postmaster config and the database data live in different locations? You can then standardize a location for the configuration files. Everybody has

Re: [HACKERS] Incremental backup

2003-02-14 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Kevin Brown) wrote: Bruce Momjian wrote: OK, once we have PITR, will anyone want incremental backups? None of my database references (Date's Introduction to Database Systems and Garcia-Molina's Database Systems - The Complete

Re: [HACKERS] postgresql and oracle, compatibility assessment

2003-02-17 Thread Christopher Browne
[EMAIL PROTECTED] (Martin Matusiak) wrote: Would it be possible to create some sort of transparent API based on ODBC to be used with PostgreSQL and Oracle? I know there exists a JDBC - ODBC bridge for java. If you wrote your application exclusively using JDBC using functions existing in both

Re: [HACKERS] request for sql3 compliance for the update command

2003-02-19 Thread Christopher Browne
After a long battle with technology,[EMAIL PROTECTED] (Mike Aubury), an earthling, wrote: On Wednesday 19 February 2003 8:18 pm, Dave Cramer wrote: I have a customer with a rather large application which uses this syntax, because they were using informix. There is also a rather interesting 4GL

Re: [HACKERS] Largest filesize under Linux

2003-03-11 Thread Christopher Browne
After a long battle with technology,Partho Bhowmick [EMAIL PROTECTED], an earthling, wrote: Well, I am running kernel-2.4.18-26. What's the limit on this baby? Sounds like you didn't read what I wrote. Which filesystem? Which version of GLIBC? By the way, have your applications been compiled

Re: [HACKERS] SQL99 ARRAY support proposal

2003-03-14 Thread Christopher Browne
Do you really think someone looking for a function to break up a string into a list of strings would ever think of looking up explode in an index if he hadn't already used PHP or (shudder) VBScript? It's also one of the classic examples of things used in introductory courses on Lisp that are

Re: [HACKERS] Roadmap for FE/BE protocol redesign

2003-03-14 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Greg Stark) wrote: So, just to throw out a wild idea: If you're talking about making large changes to the on-the-wire protocol. Have you considered using an existing database protocol? This would avoid having to reinvent the wheel

Re: [HACKERS] Largest filesize under Linux

2003-03-11 Thread Christopher Browne
Quoth Partho Bhowmick [EMAIL PROTECTED]: I am working on extending the functionality of PostgreSQL on Linux. I need to know what's the largest filesize for a single file that I can have under Linux? That depends. It depends on the size supported by the filesystem. Usually that's at least

Re: [HACKERS] new food for the contrib/ directory

2002-04-18 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Alexandre Dulaunoy) would write: On 18 Apr 2002, Doug McNaught wrote: Alexandre Dulaunoy [EMAIL PROTECTED] writes: first comment : * a special directory with ./contrib/gpl ? Doesn't really change anything. second

Re: [HACKERS] I am being interviewed by OReilly

2002-07-10 Thread Christopher Browne
[EMAIL PROTECTED] (Bruce Momjian) wrote: Lamar Owen wrote: If you doubt that fact, you need to read the archives for awhile to get a sense of how this project is organized. If the steering committee (the core six) decide against something, then that something _does_not_happen_. End of

Re: [HACKERS] Ingres to be released as open source

2004-05-31 Thread Christopher Browne
Quoth [EMAIL PROTECTED] (Christopher Kings-Lynne): Ingres is to be released as open source: http://developers.slashdot.org/article.pl?sid=04/05/25/0043219mode=nestedtid=126tid=137tid=163tid=185tid=198 Like the article says, I wonder if these is any synergy between the products. ie. Can we

Re: [HACKERS] Win32, PITR, nested transactions, tablespaces

2004-05-31 Thread Christopher Browne
[EMAIL PROTECTED] (Bruce Momjian) wrote: Win32 has 98% of its code in CVS, so it will make it Tablespaces - Christopher says it is ready, and has run tests PITR - some functionality might be in 7.5, but we aren't sure Nested transactions - Alvaro thinks it is close, but

Re: [HACKERS] Win32, PITR, nested transactions, tablespaces

2004-05-31 Thread Christopher Browne
The world rejoiced as [EMAIL PROTECTED] (Greg Stark) wrote: Tom Lane [EMAIL PROTECTED] writes: Greg Stark [EMAIL PROTECTED] writes: This is the only place where I see hardly any movement on major items the whole development cycle, then a rush of radical changes just before the freeze.

Re: [HACKERS] sequences and addval('myseq', value)

2004-06-09 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] writes: Anyway, I'm not quite getting the idea of caching sequence values. I understand the performance benefits, but it seems problematic across multiple backends, almost ensuring holes in the sequence of numbers. The

Re: [HACKERS] signal 11 on AIX: 7.4.2

2004-06-18 Thread Christopher Browne
Quoth [EMAIL PROTECTED] (Bruce Momjian): Andrew Sullivan wrote: On Thu, Jun 17, 2004 at 01:12:10PM -0400, Bruce Momjian wrote: Well, the bad news is that this backtrace isn't very useful. No kidding. It's pretty frustrating. My only guess is that getaddrinfo in your libc has a bug

Re: [HACKERS] xeon processors

2004-06-30 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Jaime Casanova) would write: Can anyone tell me if postgresql has problems with xeon processors? If so, there is any fix or project of fix it? Well, there's a known issue that IA-32 systems with more than 4GB of memory use an extension

Re: [HACKERS] Release planning

2004-07-18 Thread Christopher Browne
A long time ago, in a galaxy far, far away, Gaetano Mendola [EMAIL PROTECTED] wrote: I was thinking of something much simpler where Jan would create an ARC patch against 7.4.X and have it either in /contrib for 7.4.X or on our ftp servers, or on a web site. I could create a mechanism so

Re: [HACKERS] try/catch macros for Postgres backend

2004-08-01 Thread Christopher Browne
[EMAIL PROTECTED] (Tom Lane) wrote: Does anyone have a problem with this macro syntax? The try/catch names are stolen from Java, so I'm figuring they won't terribly surprise any modern programmer, but I'm open to different names if anyone has a better idea. Mitch Bradley, once of Sun, once

Re: [HACKERS] Version Numbering -- The great debate

2004-08-01 Thread Christopher Browne
After takin a swig o' Arrakan spice grog, Gaetano Mendola [EMAIL PROTECTED] belched out: Peter Eisentraut wrote: Alvaro Herrera wrote: What was the rule for increasing the first number after just before 7.0? That was just to avoid having to release a 6.6.6, which Jan had clearly been

Re: [HACKERS] Postgres development model

2004-08-13 Thread Christopher Browne
Oops! [EMAIL PROTECTED] (Reinoud van Leeuwen) was seen spray-painting on a wall: On Mon, Aug 09, 2004 at 09:30:09AM +0200, Peter Eisentraut wrote: Tom Lane wrote: I haven't seen any particular reason why we should adopt another SCM. Perhaps BitKeeper or SubVersion would be better for our

Re: [HACKERS] Postgres development model

2004-08-14 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] (Bruce Momjian) wrote: Tom Lane wrote: Christopher Browne [EMAIL PROTECTED] writes: Oops! [EMAIL PROTECTED] (Reinoud van Leeuwen) was seen spray-painting on a wall: Why? I understood that using BitKeeper for free for Open Source projects

Re: [HACKERS] [ADMIN] Pseudo-Off-topic-survey: Opinions about future of Postgresql(MySQL)?

2004-08-19 Thread Christopher Browne
Clinging to sanity, [EMAIL PROTECTED] (Shahbaz Javeed) mumbled into her beard: # This message was accidentally sent only to Bruce. It's pasted here for comment from the rest of the list too :) Folks, While on the topic of Ingres and open source, I was wondering whether there's interest in

Re: [HACKERS] Win32 release warning

2004-08-29 Thread Christopher Browne
After a long battle with technology, [EMAIL PROTECTED] (Andrew Dunstan), an earthling, wrote: Bruce Momjian wrote: I have shortened your paragraph to: Because Win32 is significantly different from the Unix platforms supported in previous releases, this port might have more bugs

Re: [HACKERS] Developers page is down

2004-09-10 Thread Christopher Browne
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 middle of a table? A relation is simply a set of attributes that _don't_ forcibly

Re: [HACKERS] Supporting Encryption in Postgresql

2004-09-10 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when Murat Kantarcioglu [EMAIL PROTECTED] would write: For our research project, I need to implement an encryption support for Postgressql. At this current phase, I need to at least support page level encryption In other words, each page that belongs to a

Re: [HACKERS] APR 1.0 released

2004-09-10 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Marc G. Fournier) would write: On Sat, 4 Sep 2004, Gaetano Mendola wrote: Hi all, now that Apache Portable Runtime was release why don't use it on Postgres? Short question: why? what does it give us, other then potential reliance

Re: [HACKERS] pg_dump --exclude-schema=foo

2004-09-18 Thread Christopher Browne
Quoth [EMAIL PROTECTED] (Tom Lane): Chris Browne [EMAIL PROTECTED] writes: We have discovered an interesting locking scenario with Slony-I that is pointing to a use for the ability to exclude certain schemas from pg_dump. The situation is that when a full pg_dump kicks off, a Slony-I create

Re: [HACKERS] compact PostgreSQL

2004-10-12 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] (Yui Hiroaki) wrote: I would like to install PostgreSQL. But my pc does not have much space. So I would like to make compact PostgreSQL. Does anyone know how to make compact PostgreSQL? For example, to make comment out source code and compile.

Re: [HACKERS] AIX and V8 beta 3

2004-10-03 Thread Christopher Browne
After a long battle with technology, [EMAIL PROTECTED] (Bruce Momjian), an earthling, wrote: config/acx_pthread.m4 should be testing all those thread flags and defining proper Makefile.global values for them. Do you want to send me your config.log offline or check ourself why the tests

Re: [HACKERS] embedded postgresql

2004-10-20 Thread Christopher Browne
Clinging to sanity, [EMAIL PROTECTED] mumbled into her beard: I would like to know if there are any discussions about creating an embedded version on postgresql. My thoughts go towards building/porting a sqlite equivalent of pg. People periodically drive by and suggest that PostgreSQL would

Re: [HACKERS] [Slony1-general] Re: [GENERAL] Slony-I 1.0.4 Released

2004-10-24 Thread Christopher Browne
[EMAIL PROTECTED] (Ed L.) wrote: Wow. First, thanks again for all your efforts, Jan. Second, I'm disappointed to hear the slony author and lead developer is leaving the slony leadership. When is that going to happen? And what does that mean with respect to your future involvement in slony?

Re: [HACKERS] pg_dump for values inserted in last day

2004-11-24 Thread Christopher Browne
Oops! vertigo [EMAIL PROTECTED] was seen spray-painting on a wall: Hello I need to pg_dump my database, but i want only to receive sql commands which will insert row which were inserted into database today. Is there any way to do it ? I have large database and i want to make incremential

Re: [HACKERS] Auto Vacuum

2004-11-29 Thread Christopher Browne
Oops! [EMAIL PROTECTED] (Bruce Momjian) was seen spray-painting on a wall: That could be part of auto-vacuum. Vacuum itself would still sequential scan, I think. The idea is to easily grab expire tuples when they are most cheaply found. The nifty handling of this would be to introduce VACUUM

Re: [HACKERS] Implementing SQL/PSM for PG 8.2

2005-06-27 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Jonah H. Harris) wrote: I don't recommend discussion for this in this thread, but it could also tie in with the packages support we've discussed and (although some may argue this), compiling the PL to bytecode and using that. This

Re: [HACKERS] V8 Beta 5 on AIX

2004-12-11 Thread Christopher Browne
, included with AIX so as to allow it to be considered a standard component that you can expect to find available on AIX systems in general. It's only available if it has been purchased. -- cbbrowne,@,ca.afilias.info http://dev6.int.libertyrms.com/ Christopher Browne (416) 673-4124 (land

Re: [HACKERS] V8.0rc1 On AIX.

2004-12-17 Thread Christopher Browne
That would require that xlc be installed. Neither cc, cc_r, xlc, nor xlcc (or maybe it was xlcpp?) are available on the systems Brad and I are using, so that symlink will not work. As a result, _none_ of these may be remotely considered to be universal answers on AIX. In effect, there are two

Re: [HACKERS] V8.0rc1 On AIX.

2004-12-17 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Travis P) would write: Now, on my AIX 5.1 system, /usr/bin/ cc and cc_r are both just symlinks back to /usr/vac/bin/xlc. The different program names just invoke the different settings. Brad: can you make such a symlink and compile

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-20 Thread Christopher Browne
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Jeff Davis) wrote: I almost think to not supply an MVCC system would break the I in ACID, would it not? I can't think of any other obvious way to isolate the transactions, but on the other hand, wouldn't DB2 want to be ACID

Re: [HACKERS] Goals for 8.1

2005-01-25 Thread Christopher Browne
After a long battle with technology, [EMAIL PROTECTED] (Benjamin Arai), an earthling, wrote: What are the goals for 8.1? 8.0.0 was only just released, so attention is focused for now on whatever falls out as early returns... It's early for the future work to be overly clear. Things that look

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-25 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Manfred Koizar) would write: On Mon, 24 Jan 2005 08:28:09 -0700, Jonah H. Harris [EMAIL PROTECTED] wrote: UPDATE pg_user_table_counts SET rowcount = rowcount + 1 WHERE schemaname =

Re: [HACKERS] OLS BOF for linux postgresql

2005-01-25 Thread Christopher Browne
[EMAIL PROTECTED] (Mark Wong) wrote: http://www.linuxsymposium.org/2005/ I'd be interested in being in on a BOF there; that's already a convenient time for me to seek to be in Ottawa, as one brother will be conferencing (as it were) at Connaught Ranges that week. I notice, by the way,

Re: [HACKERS] IBM patent

2005-01-29 Thread Christopher Browne
Oops! [EMAIL PROTECTED] (Tommi Maekitalo) was seen spray-painting on a wall: Hi, I just read about this IBM-patent-issue at www.heise.de. IBM grants this patens to all projects, which follow one of the licenses, which are approved by the open-source-initiative. And the BSD-license is as far

Re: [HACKERS] Connect By for 8.0

2005-02-08 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Hans-Jürgen Schönig) wrote: I think it is important not to think in dogmas (in this case this means SQL syntax is always better) - there should be a reasonable compromise between compatibility and standard. My compromise would be:

[HACKERS] Finding if old transactions are running...

2005-02-23 Thread Christopher Browne
There is a cleanup loop that (commonly) runs every 10 minutes or so and vacuums the tables that are used by the replication application. If there is some long-running transaction kicking around, this will keep that from actually cleaning things out. Consider the scenario where the system is

[HACKERS] Finding if old transactions are running...

2005-02-23 Thread Christopher Browne
I was thinking about one of the pathological cases where Slony-I behaves badly, and had an optimization thought... There is a cleanup loop that (commonly) runs every 10 minutes or so and vacuums the tables that are used by the replication application. If there is some long-running transaction

Re: [HACKERS] Finding if old transactions are running...

2005-02-28 Thread Christopher Browne
In an attempt to throw the authorities off his trail, Christopher Browne [EMAIL PROTECTED] transmitted: It sure would be nice to be able to have a way to query the start time of the eldest transaction on the system. I can see this function available in the backend: TransactionId

Re: [HACKERS] Finding if old transactions are running...

2005-02-28 Thread Christopher Browne
I can see this function available in the backend: TransactionId GetOldestXmin(bool alldbs); The cost is based on walking thru each backend process, which I guess is obvious, as if there are 47 backends, that means 47 xids. Presumably not _too_ expensive; certainly something that has to be run

Re: [HACKERS] hi all

2005-03-04 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Qu Tianlian) wrote: Hi all: I have a question. How to add table in slony. I try to add table in already being database that using slony . but it's not realize table's replication. I used postgresql version 7.4.2 and slony

Re: [HACKERS] One vacuum full is not enough.

2005-03-13 Thread Christopher Browne
[EMAIL PROTECTED] (Gaetano Mendola) wrote: Hi all, running a 7.4.5 it happen to me with another table where a single vacuum full was not freeing enough pages, here the verbose vacuum full, as you can see only at the end: truncated 8504 to 621 pages. I use pg_autovacuum and it's not enough.

Re: [HACKERS] Real-Time Vacuum Possibility

2005-03-20 Thread Christopher Browne
[EMAIL PROTECTED] (Rod Taylor) wrote: It's a fairly limited case and by no means removes the requirement for regular vacuums, but for an update heavy structure perhaps it would be worth while? Even if it could only keep indexes clean it would help. The problem that persists with this is that

Re: [HACKERS] Real-Time Vacuum Possibility

2005-03-20 Thread Christopher Browne
The problem that persists with this is that it throws in extra processing at the time that the system is the _most_ busy doing updates, thereby worsening latency at times when the system may already be reeling at the load. I think, as a result, that VACUUM will _have_ to be done asynchronously.

Re: [HACKERS] Urgent

2005-04-18 Thread Christopher Browne
Clinging to sanity, [EMAIL PROTECTED] (ElayaRaja S) mumbled into her beard: Hi, I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and i have to install postgresql 7.4.5. Plz let me know how to uninstall completely - postfesql 7.3.2 I am getting as [EMAIL PROTECTED] root]# rpm

Re: [HACKERS] argtype_inherit() is dead code

2005-04-18 Thread Christopher Browne
The world rejoiced as [EMAIL PROTECTED] (Jim C. Nasby) wrote: On Sun, Apr 17, 2005 at 06:56:01AM -0700, Joshua D. Drake wrote: Is it really an important area to improve, or are there other priorities? I know some people wished we had better support for inheritance, but how strong is that

Re: [HACKERS] Feature freeze date for 8.1

2005-04-29 Thread Christopher Browne
In the last exciting episode, pgman@candle.pha.pa.us (Bruce Momjian) wrote: o integrated auto-vacuum (Bruce) If this can kick off a vacuum of a Very Large Table at an unfortunate time, this can turn out to be a prety painful misfeature. What I'd _really_ love to see (and alas, it's beyond

Re: [HACKERS] Feature freeze date for 8.1

2005-04-29 Thread Christopher Browne
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Marc G. Fournier) wrote: I know one person was talking about being able to target only those that pages that have changes, instead of the whole table ... but some sort of load monitoring that checks # of active connections and

Re: [HACKERS] Feature freeze date for 8.1

2005-05-02 Thread Christopher Browne
The world rejoiced as matthew@zeut.net (Matthew T. O'Connor) wrote: Marc G. Fournier wrote: On Fri, 29 Apr 2005, Christopher Browne wrote: Some reasonable approximations might include: - How much disk I/O was recorded in the last 60 seconds? - How many application transactions (e.g

Re: [HACKERS] [pgsql-advocacy] Increased company involvement

2005-05-02 Thread Christopher Browne
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Jim C. Nasby) wrote: Anyone interested in pooling funds for features should take a look at http://people.freebsd.org/~phk/funding.html, which is about a FreeBSD developer who offered to work full-time on developing some specific

Re: [HACKERS] Feature freeze date for 8.1

2005-05-02 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] would write: We sometime discuss here for geographic system datatypes and feature. First, a database must have real database features, not extreme features. Oh, but it would be so much better if we could call the next version

Re: [HACKERS] Feature freeze date for 8.1

2005-05-02 Thread Christopher Browne
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] belched out: On Sun, 1 May 2005 14:35:37 -0500 Bruno Wolff III [EMAIL PROTECTED] wrote: On Sun, May 01, 2005 at 19:57:37 +0300, [EMAIL PROTECTED] wrote: Listen Tom, write a client software that releases the resources / locks that

Re: [HACKERS] inclusions WAS: Increased company involvement

2005-05-04 Thread Christopher Browne
The world rejoiced as [EMAIL PROTECTED] (Andrew Dunstan) wrote: As for CVS - if we can't do development the way we want using it then it's time to replace it. I have been convinced for quite a while that it is living on borrowed time, but I am far less certain about what should be used to

Re: [HACKERS] inclusions WAS: Increased company involvement

2005-05-04 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when josh@agliodbs.com (Josh Berkus) would write: Look at other large projects with lots of options. Apache, Perl, Linux, Java, emacs, KDE, etc., all of them strike a balance between including stuff and leaving stuff as add-ins (some more narrowly than

Re: [HACKERS] Consumer-grade vs enterprise-grade disk drives

2005-06-01 Thread Christopher Browne
[EMAIL PROTECTED] (Jeffrey W. Baker) wrote: On Mon, 2005-05-30 at 21:38 -0700, Luke Lonergan wrote: After reading this very comprehensive benchmark: http://print.tweakers.net/?reviews/557 I purchased one of the Areca controllers with a large battery-backed cache. It is unholy fast. I

Re: [PGF Members]Re: [HACKERS] Google's Summer of Code ...

2005-06-05 Thread Christopher Browne
Incidentally I havent seen any objections, if there are none should we go ahead and whip up an email to google? Do we want to run this through the foundation? ISTM we would, though I don't know the full extent of what ramifications that would have. No, the Foundation wasn't formed

Re: [HACKERS] Autovacuum in the backend

2005-06-17 Thread Christopher Browne
[EMAIL PROTECTED] (Gavin Sherry) wrote: I guess the main point is, if something major like this ships in the backend it says to users that the problem has gone away. pg_autovacuum is a good contrib style solution: it addresses a problem users have and attempts to solve it the way other users

  1   2   3   4   5   >