From: | Michael Meskes <Michael(dot)Meskes(at)usa(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | jholland(at)isr(dot)umd(dot)edu |
Subject: | Re: [HACKERS] Postgres Speed or lack thereof |
Date: | 1999-01-18 07:48:36 |
Message-ID: | 19990118084836.A370@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sun, Jan 17, 1999 at 09:08:28PM -0500, John Holland wrote:
> I've been lurking on this list for a little while. I have just done a
> little tinkering with Postgres 6.4.2, comparing it to Oracle and mySQL on
> Linux. It would appear that just doing a lot of inserts (ie 40000) in a
> loop is enormously slower in Postgres in two ways that I tried it.
> One - using a loop in Java that makes a JDBC call to insert.
> Two- using plpgsql as a comparision to PL/SQL.
Did you use the '-F' option? I tried somethings similar from C and found
similar results when calling fsync() after each write. Once I used -F it was
way faster and comparable to Oracle.
> Perhaps these are bad techniques and a C based proc would do better?
Feel free to try src/interfaces/ecpg/test/perftest.c
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael(dot)Meskes(at)gmx(dot)net | Use PostgreSQL!
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Meskes | 1999-01-18 07:49:24 | Re: [HACKERS] Postgres Speed or lack thereof |
Previous Message | Vadim Mikheev | 1999-01-18 07:13:30 | Re: [HACKERS] I need a PostgreSQL vacation |