Re: [PERFORM] Failed System follow up

2004-06-14 Thread Marcus Whitney
Just as a point of reference, my situation is very much like the one in this thread: http://archive.netbsd.se/?list=pgsql-admin&a=2004-02&mid=50891 Thanks again. - Marcus ---(end of broadcast)--- TIP 7: don't forget to increase your free space ma

Re: [PERFORM] Failed System. Help.

2004-06-14 Thread Marcus Whitney
Hello all, I have a PostgreSQL instance running on a Dell Poweredge 6450. 4 700Mhz processors, 6 GB of Ram, 2GB Backside, 60GB Raid 10 Server. Today, it crashed hard. At the command line (BASH), all I could get was 'bus fault' . After rebooting, we were unable to mount the partition that

Re: [PERFORM] pl/pgsql and Transaction Isolation

2004-06-08 Thread Marcus Whitney
You were right not to believe it. I had an update on a whole table that I hadn't noticed. Thanks for debunking. On Monday 07 June 2004 23:29, you wrote: > Marcus Whitney <[EMAIL PROTECTED]> writes: > > I have an instance where I have a series of pl/pgsql calls, that rep

Re: [PERFORM] Pl/Pgsql Functions running simultaneously

2004-06-07 Thread Marcus Whitney
no different than regular statements, just keep in mind that the queries > inside the function will work like an implicit transaction. I've noticed. Thanks for the info. > > Robert Treat > > On Thu, 2004-06-03 at 17:38, Marcus Whitney wrote: > > Am I on the wrong list t

[PERFORM] pl/pgsql and Transaction Isolation

2004-06-07 Thread Marcus Whitney
. will: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; before these DML queries eliminate the locking? -- marcus whitney chief architect : cold feet creative www.coldfeetcreative.com 800.595.4401   cold feet presents emma email marketing for discriminating organizations everywhere

Re: [PERFORM] Pl/Pgsql Functions running simultaneously

2004-06-03 Thread Marcus Whitney
Am I on the wrong list to ask this question, or does this list usually have low activity? Just asking because I am new and I need to know where to ask this question. Thanks. On Wednesday 02 June 2004 16:08, Marcus Whitney wrote: > Hello all, > > I have an import function that I

Re: [PERFORM] Inherited Tables Performance

2004-06-02 Thread Marcus Whitney
uch ever affect the performance of Kids? Thanks. -- marcus whitney chief architect : cold feet creative www.coldfeetcreative.com 800.595.4401   cold feet presents emma email marketing for discriminating organizations everywhere visit www.myemma.com

Re: [PERFORM] Pl/Pgsql Functions running simultaneously

2004-06-02 Thread Marcus Whitney
-- Create clean import file EXECUTE create_clean_import_file_sql; -- Create groups_id file EXECUTE create_members_groups_ids_file_sql; -- Empty import table EXECUTE empty_import_table_sql; -- Upload clean members from import EXECUTE upload_clea