[GENERAL] Performance

1999-10-29 Thread Jason C. Leach
hi, I've been playing with pgsql for a few days now and am getting the hang of it. I just did a loop that inserts a few thousand records into a table. I did a statement, prepare, execute; it worked fine although pg seemed to access the hd for every insert. Is there a way to cache inserts and t

Re: [GENERAL] next steps

1999-10-29 Thread Herbert Liechti
Carsten Huettl wrote: > Hello, > > I have set up a postgres installation on a freeBSD box and am now > ready to take the next steps. > > Where can I find some Webpages with postgres applications or > sample. > How do I create a "user front end"/data input mask/menu system? > Can anyone point me t

Re: [GENERAL] Performance

1999-10-29 Thread Jim Richards
I don't know about the DBI specifically, but it should have this, try doing the inserts as BEGIN WORK INSERT ... INSERT ... INSERT ... INSERT ... COMMIT WORK this will wrap all the transactions in one statement, so during the inserts other process won't be able to see the changes until the co

Re: [GENERAL] Performance

1999-10-29 Thread Charles Tassell
Try turning off DBI's autocommit , that way it will cache all the inserts until it's sure there are no errors, then just do the one write to the database. You do this by changing your DBI connect command from: $pg_con=DBI->connect("DBI:Pg:." to $pg_con=DBI->connect("DBI:Pg(AutoCommit=>0):..

[Fwd: [GENERAL] Performance]

1999-10-29 Thread Jurgen Defurne
Jason C. Leach wrote: > I've been playing with pgsql for a few days now and am getting the hang > of it. I just did a loop that inserts a few thousand records into a > table. I did a statement, prepare, execute; it worked fine although pg > seemed to access the hd for every insert. Is ther

Re: [GENERAL] next steps

1999-10-29 Thread Jurgen Defurne
Carsten Huettl wrote: Hello, I have set up a postgres installation on a freeBSD box and am now ready to take the next steps. Where can I find some Webpages with postgres applications or sample. How do I create a "user front end"/data input mask/menu system? Can anyone point me to a webside to lea

Re: [GENERAL] Studying

1999-10-29 Thread Thomas Good
On Thu, 28 Oct 1999, Ken Gunderson wrote: > At 01:17 PM 10/29/99 +1200, John Henderson wrote: > >Hi, > >I am in need of a great SQL reference that is readable by a beginner but is > >also comprehensive, any recommendations? Do you think O'Reilly is best? I > >have seen others recommended? > > > >

[GENERAL] Re: [NOVICE] next steps

1999-10-29 Thread Thomas Good
On Fri, 29 Oct 1999, Carsten Huettl wrote: > Hello, > > I have set up a postgres installation on a freeBSD box and am now > ready to take the next steps. > > Where can I find some Webpages with postgres applications or > sample. Hallo, You can have a look at http://www.simtax.ca/acc where y

Re: [GENERAL] Studying

1999-10-29 Thread Duncan Kinder
> I like `SQL for Smarties', even the parts that elude Currently on 40% discount at Amazon.com Regards, Duncan C. Kinder [EMAIL PROTECTED] - Original Message - From: Thomas Good <[EMAIL PROTECTED]> To: Ken Gunderson <[EMAIL PROTECTED]> Cc: John Henderson <[EMAIL PROTECTED]>; <[EMAIL

Re: [GENERAL] Studying

1999-10-29 Thread Bruce Momjian
> And I never weary of touting the virtue of the `LAN TIMES Guide to SQL' > by Groff and Weinberg. I find it superior to every other tome I've read. > It includes very handy charts. The data type comparison chart includes > Ingres whose data types match PG for the most part. I ripped mine out >

[GENERAL] Stability issues with postgres 6.5

1999-10-29 Thread Oren Teich
I'm running postgres 6.5 on a basically bone stock Redhat 5.1 box. On a separate machine, we have a PHP front end hitting the postgres DB. Everything works fine most of the time, but for no apparent reason, every few weeks, the DB just dies. ps shows plenty of postgres process running, but teln

[GENERAL] Advice on Transfering functions from MS-MSSQL Server

1999-10-29 Thread Darvin Zuch
Good Morning! I've looked at the pgSQL docs but I'd like to get advice from someone thats been "through the fire". I'm attempting to move some code off of MS-SQL Server onto PostgreSQL. Most of my MS code is written in Microsofts T-SQL Functions. I use a lot of variables as well as Server-side

[GENERAL] Re: [NOVICE] next steps

1999-10-29 Thread amy cheng
I'm considering to persuade my boss in making the scheduler project I'm doing as a GPL, just like the accounting one. any ideas? >From: Thomas Good <[EMAIL PROTECTED]> >To: Carsten Huettl <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED], [EMAIL PROTECTED] >Subject: Re: [NOVICE] next steps >Date: Fri,

[GENERAL] drop view seems to have made database unusable . . help!

1999-10-29 Thread Martin Weinberg
Help! I attempted to create a view like create view pscscan as select * from psc, scandat where . . .; which failed with a message about duplicate entries. I tried another with create view pscscan2 as select j_m, j_pts_noise from psc, scandat where . . .; which worked. I the

Re: [GENERAL] Studying

1999-10-29 Thread Bill Meahan
On Thu, 28 Oct 1999, John Henderson wrote: > Hi, > I am in need of a great SQL reference that is readable by a beginner but is > also comprehensive, any recommendations? Do you think O'Reilly is best? I > have seen others recommended? > Though you'll never go wrong with an O'Reilly book, IMNSHO,

Re: [GENERAL] Studying

1999-10-29 Thread Ken Gunderson
At 06:57 PM 10/29/99 -0400, Bill Meahan wrote: >On Thu, 28 Oct 1999, John Henderson wrote: >> Hi, >> I am in need of a great SQL reference that is readable by a beginner but is >> also comprehensive, any recommendations? Do you think O'Reilly is best? I >> have seen others recommended? >> > >Thou