Hi!
I'm new to Postgres, so i apologize if my question is stupid.
I'm trying to install Postgress 6.4.2 on a AIX 4.3.2. I'm using IBM XLC compiler
for AIX 4.3, and because i want to use postgress library in my DCE applications,
i'm trying to compile postgres with thread safe compiler xlc_r. So
> > if anyone has any pointers as to why this is so slow, lemme know.
>
> Have you checked the usual stuff:
>
> 1) Each insert and update creates its own transaction. That is, an
>insert is in fact:
>
>BEGIN TRANSACTION;
>INSERT...;
>COMMIT;
>
>So, to make things faster you
> How about -o -F ?
the startup script is:
[ -x /usr/local/pgsql/bin/postmaster ] && {
su -l pgsql -c 'exec /usr/local/pgsql/bin/postmaster -i -S -o -F -d 3 \
-D/usr/local/pgsql/data' >> /usr/local/pgsql/errlog 2>&1
echo -n ' pgsql'
}
--
[ Jim MercerReptilian Research
At 16:10 +0200 on 17/2/99, Jim Mercer wrote:
>
> > 3) Back to the issue of INSERTS - copies are faster. If you can transform
> >the data into tab-delimited format as required by COPY, you save a lot
> >of time on parsing, planning etc.
>
> this sorta defeats the purpose of putting the da
> At 16:10 +0200 on 17/2/99, Jim Mercer wrote:
> You probably didn't understand me. If you convert it to tab delimited text
> and then use COPY table_name FROM filename/stdin instead of INSERT, it will
> be much faster, because you don't have to do the parsing and planning on
> each line, but only
At 16:47 +0200 on 17/2/99, Jim Mercer wrote:
> i will test this with my insertama program, but i see some problems with
>this.
>
> firstly, it assumes that all of your applications programs are updated each
> time you modify the structure of the table.
This is true. That's the sacrifice you get
I was thinking about creating a trigger on every table that would write an
insert, update, or delete statement into a log file. Each replicated
database would pro-actively read these and post them.
-Original Message-
From: Thomas Antepoth [SMTP:[EMAIL PROTECTED]]
On Tue, 16 Feb 1999, Bryan Mattern wrote:
> I'm working on a personal project to develop some sort of GPS software
> for Linux. I was talking with a friend the other day and he let me
> borrow a "TIGER/Line CD" (!1990!) from the US Bureau of the Census. I
> know the data is old, but I just want
