[ADMIN] Shared memory oddity

2001-12-10 Thread Steven Lane
Why would this happen? I had a server where postgres appeared to be running very slowly. Following some advice I found on-line, I boosted the shared memory max for that machine and told postgres to take 15200 buffers (about 128 meg of shared memory). For a while this worked great, but today, the

[ADMIN] Re: error status 139

2001-07-23 Thread Steven Lane
Hello all: I'm trying to load about 10M rows of data into a simple postgres table. The data is straightforward and fairly clean, but does have glitches every few tens of thousands of rows. My problem is that when COPY hits a bad row it just aborts, leaving me to go back, delete or clean up the ro

[ADMIN] Better copy/import

2001-07-23 Thread Steven Lane
Hello all: Sorry for the bad subject line on the last version of this post. I'm trying to load about 10M rows of data into a simple postgres table. The data is straightforward and fairly clean, but does have glitches every few tens of thousands of rows. My problem is that when COPY hits a bad ro

[ADMIN] RE: High memory usage

2001-06-20 Thread Steven Lane
>Date: Wed, 20 Jun 2001 23:06:56 -0500 >To: "Rainer Mager" <[EMAIL PROTECTED]> >From: Steven Lane <[EMAIL PROTECTED]> >Subject: RE: High memory usage >Cc: [EMAIL PROTECTED] >Bcc: >X-Attachments: > >>Hi, >> >> Hmm, I'm not s