Re: What's WAL (wasRe: [GENERAL] Postgres INSERTs much slower than MySQL?)

1999-10-21 Thread Gene Selkov, Jr.
> The other end of the spectrum is where you load the payware VMWare stuff. > It allows you to emulate a complete new PC with it's own BIOS on Linux. > Basically you run Linux, and then within Linux you can boot up one or even > more virtual PCs which can run DOS, Windows, OS/2 Linux even and so o

Re: [GENERAL] Postgres INSERTs much slower than MySQL?

1999-10-21 Thread Bruce Momjian
> WAL is Write Ahead Log, transaction logging. > This will reduce # of fsyncs (among other things) Postgres has > to perform now. > Test above took near 38 min without -F flag and 24 min > with -F (no fsync at all). > With WAL the same test without -F will be near as fast as with > -F now. > > Bu

[GENERAL] Re: What's WAL

1999-10-21 Thread Christian Rudow
Jimmie Houchin wrote: > What is WAL? Or is it something that is only known by the Illuminati? :) I understand your fears. I can also not follow all that the linux cracks around me are talking about. I also was still using a Windows workstation for quite some time, when we had already started ou

Re: [GENERAL] Postgres INSERTs much slower than MySQL?

1999-10-21 Thread Vadim Mikheev
Lincoln Yeoh wrote: > > At 04:38 PM 20-10-1999 +0800, Vadim Mikheev wrote: > >You hit buffer manager/disk manager problems or eat all disk space. > >As for "modifying" - I meant insertion, deletion, update... > > There was enough disk space (almost another gig more). So it's probably > some buff

Re: [GENERAL] stored procedure revisited

1999-10-21 Thread Rudy Gireyev
On 12 Oct 99, at 19:34, Yin-So Chen wrote: [SP discussion snipped] > > Come on, everybody, speak out your thought on this matter :) Alright, alright. Last I used the SP was on a Teradata box, and I must admit it's a useful functionality. It makes the code much easier to read, in addition to all

Re: What's WAL (wasRe: [GENERAL] Postgres INSERTs much slower than MySQL?)

1999-10-21 Thread Lincoln Yeoh
I dunno what's WAL either. >not trying to be. Please forgive me. If at all possible I will try to >atone by installing RH 6.x on my machine at work, if I can do it where >my boss can boot (from a shutdown machine) into windows without knowing >Linux exists. :) There are many different ways to a

Re: [GENERAL] Installation simplicity

1999-10-21 Thread Alain TESIO
--- Duncan Kinder <[EMAIL PROTECTED]> wrote: > There appears to be some difference between the RPM Postgres > distribution > and what you would expect from compiling the binaries. > > I don't know what the problem was, but rather than try to figure > the thing > out, I finally removed the RPM's d

What's WAL (wasRe: [GENERAL] Postgres INSERTs much slower than MySQL?)

1999-10-21 Thread Jimmie Houchin
I've seen WAL mentioned several times, but have yet to see anything about what it is. Help! :) What is WAL? Or is it something that is only known by the Illuminati? :) I did a search in the archives and came up empty, no hits. Not even the messages which only mention it. Nothing, nada, zip, no

Re: [GENERAL] cidr and inet

1999-10-21 Thread Aaron J. Seigo
hi... > insert into ip values (10.20.30.40); > > It always points to the third part of the IP (ie, 100 > in case of 10.30.100.200) > pgsql is seeing it as a decimal number. enclose it in single quotes and it will work fine. insert into ip values ('10.20.30.40'); -- Aaron J. Seigo Sys Admin

Re: [GENERAL] cidr and inet

1999-10-21 Thread amy cheng
try: insert into ip values ('10.20.30.40'); >From: soundar rajan <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: [GENERAL] cidr and inet >Date: Thu, 21 Oct 1999 12:15:03 -0700 (PDT) > >Hi all, > >I created two tables with CIDR and inet data values >separately. I was not able to insert value

Re: [GENERAL] cidr and inet

1999-10-21 Thread Aaron Holtz
Enclose the IP in single quotes. insert into ip values ('10.20.30.40'); -- Aaron Holtz ComNet Inc. UNIX Systems Administration/Network Operations "It's not broken, it just lacks duct tape." --

[GENERAL] cidr and inet

1999-10-21 Thread soundar rajan
Hi all, I created two tables with CIDR and inet data values separately. I was not able to insert values into it. When I tries to do insert into ip values (10.20.30.40); the error I get time and again is 'parser error at or near .30' It always points to the third part of the IP (ie, 100 in c