Re: [GENERAL] Dangers of fsync = off

2007-05-08 Thread Andrew Sullivan
for replication, which is indeed possible. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off. --Alexander Hamilton ---(end of broadcast

Re: [GENERAL] Database performance comparison paper.

2007-02-19 Thread Andrew Sullivan
On Sat, Feb 17, 2007 at 12:02:08AM +0100, Leif B. Kristensen wrote: There ought to be a proper name for this kind of pseudo-technical Gonzo journalism. There is, but it's not the sort of word one uses in polite company ;-) A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately

Re: [GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

2007-02-06 Thread Andrew Sullivan
On Tue, Feb 06, 2007 at 09:43:01AM -0600, Thomas F. O'Connell wrote: DETAIL: Table has type character varying, but query expects character varying. In another thread, someone else is reporting this too. I'm wondering whether something went wrong in the 8.2.2 release. A -- Andrew Sullivan

Re: [GENERAL] Hardware

2007-02-06 Thread Andrew Sullivan
. So I always use 1+0 if I can. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

Re: [GENERAL] replication choices

2007-02-06 Thread Andrew Sullivan
the outbound replication from the centre, assuming that the changes are infrequent. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland

Re: [GENERAL] replication choices

2007-02-06 Thread Andrew Sullivan
. This is really no more load than the single replication user, although it is expensive at the disk level. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspun ---(end

Re: [GENERAL] Compilation Error AIX

2007-02-02 Thread Andrew Sullivan
. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Ok, now what are you handing to ./configure? A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. It's an economics problem. --Bruce Schneier

Re: [GENERAL] DBMS Engines and Performance

2007-02-02 Thread Andrew Sullivan
hairs that relate to MySQL features that are really just there to cover up missing pieces of implementation. (Or rather, used-to-be-missing. MySQL has come a long way in the past couple releases, no matter what anyone thinks of their marketing approach of FUD FUD FUD.) -- Andrew Sullivan | [EMAIL

Re: [GENERAL] DBMS Engines and Performance

2007-02-02 Thread Andrew Sullivan
or read such sentiments often enough to realise that there are plenty of application developers who don't know anything about their database technology. A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way of saying November. --H.W. Fowler

Re: [GENERAL] Can a database be restored successfully after new installation.

2007-02-02 Thread Andrew Sullivan
, oughta work fine, assuming you have all the necessary support in your target system. (e.g. if you're using plpgsql, for instance, you need to have performed createlang for it, c.) A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than

Re: [GENERAL] Compilation Error AIX

2007-02-01 Thread Andrew Sullivan
address or mailto:[EMAIL PROTECTED] Thank you. -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin ---(end

Re: [GENERAL] porting time calcs to PG

2006-12-08 Thread Andrew Sullivan
= DueTime oughta work. -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] vacuum: out of memory error

2006-11-27 Thread Andrew Sullivan
read the data. But you already knew that: it's why your vacuum is blowing up. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 3: Have you checked our extensive

Re: [GENERAL] per-row security

2006-11-07 Thread Andrew Sullivan
documenting. In Slony, the replication user has to be a superuser anyway, so it would have access to that data no matter what. A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack

Re: [GENERAL] Pgsql on Solaris

2006-10-31 Thread Andrew Sullivan
the exact error message you're getting might lead you to more productive responses from people using Solaris today. Or maybe you can use the packages, and you don't need to build it. A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than

Re: [GENERAL] Replicating changes

2006-10-29 Thread Andrew Sullivan
developers, I'm sure people would welcome it. A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't need their acronym. --Josh Hamilton, on the US FEMA ---(end of broadcast)--- TIP 4: Have you searched our list

Re: [GENERAL] password cookie

2006-10-26 Thread Andrew Sullivan
that way. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspun ---(end of broadcast)--- TIP 4: Have you searched our list archives

Re: [GENERAL] Compiling ELF 64-bit on Solaris

2006-10-26 Thread Andrew Sullivan
a compiler that can generate 64 bit binaries? How about your libs? A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack. --Scott Morris ---(end

Re: [GENERAL] benchmark suite

2006-10-24 Thread Andrew Sullivan
are around here, though, and probably can give you a better answer. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin

Re: [GENERAL] problem with using O_DIRECT

2006-10-14 Thread Andrew Sullivan
logfile say? (Not every method works on every platform, and you might have run into an incompatible combination.) A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack

Re: [GENERAL] List of supported 64bit OS

2006-10-14 Thread Andrew Sullivan
first, then buy the hardware to suit, not the other way 'round. (You do this, effectively, when you buy Sun or IBM RS/6000 gear, don't forget.) A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, Wow, this software may be buggy and hard to use, but at least there is a lot of code

Re: [GENERAL] more anti-postgresql FUD

2006-10-13 Thread Andrew Sullivan
that WAL is the one area where, for Postgres, the cost of using raw disk could conceivably be worth the benefit? (I.e. you end up having to write a domain-specific filesystemish thing that is optimised for exactly your cases)? (And before you ask me, no I'm not volunteering :( ) A -- Andrew

Re: [GENERAL] Create Index on Date portion of timestamp

2006-10-13 Thread Andrew Sullivan
to be able to create a functional index on the to_date() of the column. I don't know if that will solve your cast issue, but you could rewrite the CAST into the to_date form to get around that. A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way

Re: [GENERAL] STABLE functions

2006-10-12 Thread Andrew Sullivan
. The Slony-I project has heard a lot of agitating for automatic support of DDL. As near as I can tell, that either requires triggers on system catalogs or else triggers on statements like CREATE TABLE, ALTER TABLE, c. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men

Re: [GENERAL] more anti-postgresql FUD

2006-10-11 Thread Andrew Sullivan
On Tue, Oct 10, 2006 at 02:50:44PM -0400, Tom Lane wrote: Some days I think database independence is a myth. On the day when you don't, please tell me what application you found where it isn't. I want to buy the developers a drink. Or maybe a bar. A -- Andrew Sullivan | [EMAIL PROTECTED

Re: [GENERAL] Performance and Generic Config after install

2006-10-02 Thread Andrew Sullivan
in comparison to MySQL. But it's not a reasonable comparison, because MySQL basically uses a rule-based optimiser. And systems like DB2 and Oracle, that use a cost-based optimiser, are often far from perfect after a fresh install, too. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote

Re: [GENERAL] benchmark suite

2006-09-29 Thread Andrew Sullivan
On Fri, Sep 29, 2006 at 07:27:49PM +0530, km wrote: Is there any good benchmark suite for testing postgresql performance? I suggest looking at the excellent software provided by OSDL. http://www.osdl.org/lab_activities/kernel_testing/osdl_database_test_suite/ A -- Andrew Sullivan | [EMAIL

Re: [GENERAL] benchmark suite

2006-09-29 Thread Andrew Sullivan
) Is this the very first indication of something being wrong? It sure looks to me like you're missing some headers. -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't need their acronym. --Josh Hamilton, on the US FEMA ---(end of broadcast

Re: [GENERAL] Dead Lock problem with 8.1.3

2006-09-27 Thread Andrew Sullivan
such deadlocks in your application, too, of course, but they're not database deadlocks. Also. . . There is no output. It just takes forever. . . .define forever. Is it doing any work? Do you see i/o? Is it in SELECT WAITING state? A -- Andrew Sullivan | [EMAIL PROTECTED] This work

Re: [GENERAL] [HACKERS] PostgreSQL HA questions

2006-09-27 Thread Andrew Sullivan
detailed outlines of how to do this sort of thing by searching for rotor tables. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin

Re: [GENERAL] Good books about PL/PGSQL programming?

2006-09-26 Thread Andrew Sullivan
On Thu, Sep 21, 2006 at 10:33:41AM +0200, [EMAIL PROTECTED] wrote: Are there any good and recommendable books about PL/PGSQL programming? I think the Douglas book is rather good for this. A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way

Re: [GENERAL] Replication and PITR

2006-09-26 Thread Andrew Sullivan
is essentially a node in permanent crash-recovery mode until it's caught up. Think of Oracle's comparable product -- you can't read from those replicas either. A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't need their acronym. --Josh Hamilton

Re: [GENERAL] Replication and PITR

2006-09-26 Thread Andrew Sullivan
colleagues, in fact) appear to have a nasty bug in that functionality that they can't nail down; nobody else has reproduced it. A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack

Re: [GENERAL] in failed sql transaction

2006-09-25 Thread Andrew Sullivan
usable. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off. --Alexander Hamilton ---(end of broadcast)--- TIP 6: explain

Re: [GENERAL] postgresql rising

2006-09-20 Thread Andrew Sullivan
stronger still. So what we need is a spotless reputation -- which we're building. A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell ---(end of broadcast)--- TIP 4

Re: [GENERAL] Child program using parent program's transaction?

2006-09-12 Thread Andrew Sullivan
. In no time at all, the whole application has ground to a halt while everything goes through this serialised global choke-point. It is at this point that you decide there's a reason the system doesn't do this sort of thing out of the box ;-) A -- Andrew Sullivan | [EMAIL PROTECTED] Everything

Re: [GENERAL] On DNS for postgresql.org

2006-09-07 Thread Andrew Sullivan
. A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way of saying November. --H.W. Fowler ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Replace NULL values

2006-09-07 Thread Andrew Sullivan
allow_null_equals. It's ugly, but it might solve this problem for you. A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack. --Scott Morris ---(end

Re: [GENERAL] plz unsubscribe me

2006-09-07 Thread Andrew Sullivan
be bothered. Or what about automatically unsubscribing at that point? (In spite of other ways it's awful, mailman does that rather well.) A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well

[GENERAL] Estimate on gborg rescue?

2006-09-06 Thread Andrew Sullivan
feel free to hit me up. My office phone is +1 416 673 4110, in case someone needs it. I'm even on call this week, so you should be able to reach me more or less any time. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary

[GENERAL] On DNS for postgresql.org

2006-09-06 Thread Andrew Sullivan
Hi, Now that the DNS is back (thanks!), I thought I'd ask why the ra bit is set on the responses. Are those servers providing recursion to the whole Net? (They seem to be.) If so, that's a Bad Thing. A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't need

Re: [GENERAL] Estimate on gborg rescue?

2006-09-06 Thread Andrew Sullivan
lerctr.org by now, because for some reason the primary is broken. Do we need additional DNS hands? That happens to be a thing I know a little about. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become

Re: [GENERAL] On DNS for postgresql.org

2006-09-06 Thread Andrew Sullivan
others' business how the infrastructure is managed A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your

Re: [GENERAL] Estimate on gborg rescue?

2006-09-06 Thread Andrew Sullivan
forever whereas www.postgresql.org stayed up. Although now that the DNS is in serious panting mode, I think we may have a different set of issues. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace. --Philip

Re: [GENERAL] problem with postgres SQL db

2006-08-19 Thread Andrew Sullivan
this upgrade a little tough. Test everything very carefully. It is possible that it will go more smoothly if you first upgrade to 7.4, and then dump from that to 8.1. I can't say for sure. A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness

Re: [GENERAL] GPL Licensed Files in 8.1.4

2006-06-07 Thread Andrew Sullivan
rather than contrib/ A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath. --Damien Katz ---(end of broadcast)--- TIP 5: don't

Re: [GENERAL] Backwards index scan

2006-06-06 Thread Andrew Sullivan
mistaken about something? A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off. --Alexander Hamilton ---(end of broadcast)--- TIP 2

Re: [GENERAL] Making query without trigger

2006-05-26 Thread Andrew Sullivan
. The trigger still fires, but it doesn't do anything. A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way of saying November. --H.W. Fowler ---(end of broadcast)--- TIP 1: if posting

Re: [GENERAL] Strange error while executing query from front end:

2006-01-17 Thread Andrew Sullivan
failure of some kind. In particular, this tells you that a flush of the write ahead log isn't completing. That's a Bad Thing. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well

Re: [GENERAL] Plans for 8.2?

2006-01-13 Thread Andrew Sullivan
to install. Nobody thinks that the DBI is some sort of stupid tacky not-ready tool just because every installation of Perl doesn't have it automatically. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising money

Re: [GENERAL] undefined behaviour for sub-transactions?

2005-12-01 Thread Andrew Sullivan
On Wed, Nov 30, 2005 at 02:58:15PM -0700, Michael Fuhr wrote: Shouldn't that be 8.0 and later? That's when savepoints were introduced. Or are you referring to something else? Doh. Indeed. I was _thinking_ os something else, but not referring to something else. A -- Andrew Sullivan

Re: [GENERAL] undefined behaviour for sub-transactions?

2005-11-30 Thread Andrew Sullivan
is occasionally pretty dodgy, unless you use the strict mode. But it's worth knowing that in Pg 8.1 and later, you can wrap such things in a subtransaction and get out of it that way. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you

Re: [GENERAL] Rebranding PostgreSQL

2005-11-17 Thread Andrew Sullivan
to people who already had picked PostgreSQL. But the OP was suggesting this was a way around the We don't use nuttin' but O-ra-cle 'round here crowd; and I don't see how Magic Blackbox Database is somehow better than Postgres to those people. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact

Re: [GENERAL] Strange slow database

2005-11-17 Thread Andrew Sullivan
repeatable change like that, look for the common changed factor. A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes ---(end of broadcast)--- TIP

Re: [GENERAL] Cursors or Offset, Limit?

2005-11-16 Thread Andrew Sullivan
an ORDER BY), so it's fast at first but possibly painfully slow in the last rows (especially on a large table). A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off. --Alexander

Re: [GENERAL] Rebranding PostgreSQL

2005-11-16 Thread Andrew Sullivan
time, why do you think your customers will be more willing to go for John's Database than some community product called PostgreSQL? (And yes, I suspect there _are_ such people.) A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way of saying November

Re: [GENERAL] Replicating databases

2005-11-03 Thread Andrew Sullivan
, though, and if people want to work on such a target, I'd sure like to know about it. A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way of saying November. --H.W. Fowler ---(end of broadcast

Re: [GENERAL] Replicating databases

2005-11-03 Thread Andrew Sullivan
more like whether it'd be merely horribly nasty or likely to break in unexpected and really painful ways. ;-) But the discussion around that surely should move to the Slony list. -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary

Re: [GENERAL] Replicating databases

2005-11-03 Thread Andrew Sullivan
don't have the whole picture: maybe communications links aren't stable in some of these stores, and can't be made so economically. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast

Re: [GENERAL] Replicating databases

2005-11-02 Thread Andrew Sullivan
, because you can depend on your application to cause no conflicts. Slony is designed to prevent you from writing into the replicated tables. Some of the other master-slave ones don't have that restriction, but they're sort of dangerous for the same reason. A -- Andrew Sullivan | [EMAIL PROTECTED

Re: [GENERAL] How to cluster Postgresql

2005-10-21 Thread Andrew Sullivan
On Fri, Oct 21, 2005 at 04:01:12PM +, Franck Coppola wrote: would be interested too : i don't feel very confident with slony). Why don't you? (The Slony developers would like to know, I think.) A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions

Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase

2005-10-20 Thread Andrew Sullivan
? -- t (1 ligne) But is it the case that Oracle doesn't treat that one any differently from this: andrewtest=# SELECT 'a'||NULL::char='a'::char; ?column? -- (1 ligne) If that's the case, it's pretty odd. A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I

Re: [GENERAL] Select all invalid e-mail addresses

2005-10-20 Thread Andrew Sullivan
registrations yet, and it doesn't appear to have arpa, either.) A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. It's an economics problem. --Bruce Schneier ---(end of broadcast)--- TIP

Re: [GENERAL] Select all invalid e-mail addresses

2005-10-20 Thread Andrew Sullivan
whether a mail address works may change over time (and may have nothing to do with the poor schmuck whose email administrators don't know how to spell MX record). A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary and imaginative work

Re: [GENERAL] Select all invalid e-mail addresses

2005-10-20 Thread Andrew Sullivan
the opposite behaviour -- emailinvalidate(), I guess -- but that seems like a good obviously wrong tester. It might not be fast, though -- that loop at the special character check looks pretty painful. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success

Re: [GENERAL] Select all invalid e-mail addresses

2005-10-20 Thread Andrew Sullivan
one thing to say you should not accept known-bad data; it's quite another to refuse data that is improbable but nevertheless perfectly good. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually

Where to concentrate (was: [pgsql-advocacy] [GENERAL] Oracle buys Innobase)

2005-10-19 Thread Andrew Sullivan
wonder how to get it moving. A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way of saying November. --H.W. Fowler ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] On multi-master

2005-10-18 Thread Andrew Sullivan
is adequate logging (and probably log monitoring) -- and we already provide that. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 5: don't forget to increase your

Re: [GENERAL] On multi-master

2005-10-18 Thread Andrew Sullivan
. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland ---(end of broadcast)--- TIP 9: In versions

Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase

2005-10-18 Thread Andrew Sullivan
think we should avoid worrying about MySQL: it gives others an opportunity to lump us into the open source pile, and dismiss the whole thing on the basis of the missing features in MySQL. A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you

Re: [GENERAL] On multi-master

2005-10-18 Thread Andrew Sullivan
be using of lumping PostgreSQL in with other products, and then attacking the other product. Irrelevance may be fallacious, but it makes for depressingly successful marketing. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes

Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase

2005-10-18 Thread Andrew Sullivan
, you can go after the FOSS area without much additional effort; whereas if you concentrate first on being free, you then have the later problem of moving from free to enterprise grade. A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. It's

Re: [GENERAL] On multi-master

2005-10-14 Thread Andrew Sullivan
with the community sources.) A -- Andrew Sullivan | [EMAIL PROTECTED] It is above all style through which power defers to reason. --J. Robert Oppenheimer ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] On multi-master

2005-10-14 Thread Andrew Sullivan
, that I'm extremely impressed with pgpool. I just think we have some room to grow before we can say we have something to really compete with the commercial multimaster systems. a -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner

Re: [GENERAL] On multi-master

2005-10-14 Thread Andrew Sullivan
never exceed your memory. Who's willing to guarantee the data set won't grow unexpectedly?) That said, using pgpool for higher-reliability, we-checked-it-real- good systems isn't a bad idea; on the contrary. Just let's not pretend it's something that it isn't really. A -- Andrew Sullivan

Re: [GENERAL] On multi-master

2005-10-14 Thread Andrew Sullivan
. Slony-I has a target, but it's not this one. and has truly high-avilabilty). Maybe Slony-II is one of the hope, but I have no idea how the performance is... Well, since it doesn't exist except in prototype yet, I think the performance is pretty bad :-) A -- Andrew Sullivan | [EMAIL

Re: [GENERAL] On multi-master

2005-10-14 Thread Andrew Sullivan
, this is not to say there are any flies on pgpool. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspun ---(end of broadcast)--- TIP 9: In versions

Re: [GENERAL] [pgsql-advocacy] Oracle buys Innobase

2005-10-14 Thread Andrew Sullivan
of the closet. There _are_ such customer lists, but the license for PostgreSQL doesn't entail that those customers be used as marketing fodder. A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way of saying November. --H.W. Fowler

Re: [GENERAL] Cluster/redundancy question

2005-10-13 Thread Andrew Sullivan
, buy Oracle. The limitations on MySQL's implementation give me the willies. As Tom Waits said, The large print giveth, and the small print taketh away. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace

Re: [GENERAL] Considering an upgrade...

2005-10-13 Thread Andrew Sullivan
that you have the ability to roll back to the old release if, once you get the new system into production use, you happen to find something you'd overlooked. A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you do sir? --attr

On multi-master (was: [GENERAL] Limitations of PostgreSQL)

2005-10-13 Thread Andrew Sullivan
thing all called by the same name by the marketing department). A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell ---(end of broadcast)--- TIP 6: explain analyze

Re: [GENERAL] Question about stored procedures

2005-10-13 Thread Andrew Sullivan
. A -- Andrew Sullivan | [EMAIL PROTECTED] It is above all style through which power defers to reason. --J. Robert Oppenheimer ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

Re: [GENERAL] Cluster/redundancy question

2005-10-13 Thread Andrew Sullivan
. It's what really bothers me about their clustered offering. Others might make a different trade-off. Me, I don't like to be in water over my head when I'm awakened in the middle of the night. -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show

Re: [GENERAL] On multi-master

2005-10-13 Thread Andrew Sullivan
(maybe in a sub-project, maybe as a co-operative project). I don't have the problem, so I can't justify the staff time. So if someone _else_ has the problem, maybe s/he can. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you

Re: [GENERAL] On multi-master

2005-10-13 Thread Andrew Sullivan
started down this road, I think, because someone was wanting a multi-master system right away.) But I think it will be soon. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off

Re: [GENERAL] On multi-master

2005-10-13 Thread Andrew Sullivan
and later Chris) to get it growing. That seems to have worked -- I think there is now as much contribution from non-Afilias folks as Afilias folks, and I think Slony is better for it. A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. It's an economics

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

2005-10-12 Thread Andrew Sullivan
On Mon, Oct 10, 2005 at 09:20:47AM -0600, Michael Fuhr wrote: project. I hope their employers appreciate what they've got. Well, I can tell you that Afilias does. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace

Re: [GENERAL] License question[VASCL:A1077160A86]

2005-10-06 Thread Andrew Sullivan
by TheirDB's decision to understand derivative program in a mighty extended way. I seem to be echoing Emily a lot these days. Never mind. A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

2005-10-06 Thread Andrew Sullivan
the PREPARE step succeds, and then the client disconnects, the transaction is automatically rolled back and can't be recovered. I haven't figured out yet whether this is merely dodgy, or an outright violation of the spec. A -- Andrew Sullivan | [EMAIL PROTECTED] It is above all style through which power

Re: [GENERAL] PostgreSQL Gotchas

2005-10-06 Thread Andrew Sullivan
. A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way of saying November. --H.W. Fowler ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] License question[VASCL:A1077160A86]

2005-10-05 Thread Andrew Sullivan
is written by someone else, and that it's not UC's fault if it doesn't work (so you can't sue them). A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 6: explain

Re: [GENERAL] Postgresql replication

2005-08-30 Thread Andrew Sullivan
On Thu, Aug 25, 2005 at 01:44:15PM +0200, Bohdan Linda wrote: there are some other db solutions which have good performance when doing this kind of replication across the world. Bluntly, No. -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. It's

Re: [GENERAL] Postgresql replication

2005-08-30 Thread Andrew Sullivan
that price. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off. --Alexander Hamilton ---(end of broadcast)--- TIP 1: if posting

Re: [GENERAL] WHERE

2005-05-13 Thread Andrew Sullivan
On Mon, May 09, 2005 at 12:58:06PM -0700, Dann Corbit wrote: Temp tables go away after the transaction completes. Connection, actually, no? A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace. --Philip

Re: [GENERAL] postgresql replication

2005-05-06 Thread Andrew Sullivan
availability will end up needing some of those additional features.) A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes ---(end of broadcast

Re: [GENERAL] Slony v. DBMirror

2005-05-06 Thread Andrew Sullivan
the only throttle will be the network. Not quite, because your schema needs to be complete on the target system (in particular, you need your unique keys to stay, although you can get rid of some other indexes to speed things up). A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote

Re: [GENERAL] Slony v. DBMirror

2005-05-06 Thread Andrew Sullivan
://developer.postgresql.org/~wieck/slony1/Slony-I-concept.pdf. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well. --Dennis Ritchie ---(end of broadcast

Re: [GENERAL] Slony v. DBMirror

2005-05-06 Thread Andrew Sullivan
bad case, if you fail over to the target? Figuring out how to do that was one of Jan's homework projects, IIRC. ;-) A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now

Re: [GENERAL] postgresql replication

2005-05-05 Thread Andrew Sullivan
use it for the .info and .org top level domains, among other systems. A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes ---(end of broadcast

Re: [GENERAL] do I need replication or something else?

2005-04-15 Thread Andrew Sullivan
think of a nifty way to attempt this with the currently-beta Slony-I software. A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell ---(end of broadcast)--- TIP 8

<    1   2   3   4   5   6   7   8   >