performance error

Поиск
Список
Период
Сортировка
От
Тема performance error
Дата
Msg-id OFC8AD1176.D2DA3C39-ONC1256E68.003BE341-C1256E68.003C74E7@flender.com
обсуждение исходный текст
Список pgsql-hackers-win32
Дерево обсуждения

Hi to all,

I downloaded the last win32-snapshot and got it all in a ready state.

After that I created a simple testtable like

CREATE TABLE public.testdaten1
(
 id int4 NOT NULL,
 name varchar(20),
 firstname varchar(20),
 CONSTRAINT testdaten1_pkey PRIMARY KEY (id)
) WITH OIDS;

GRANT ALL ON TABLE public.testdaten1 TO public;

Now I tested a simple c++ program which, do many inserts within a for-loop (connected over ODBC)

I'm not sure but I think the performance is not very well (it's really bad)

cpu-usage between 0 and 5 %

harddisc is permanently busy but the inserting-process is very slow (50000 records in 30 minutes)

Are there any ideas to get rid of this problem ?

Regards tom


Вложения

В списке pgsql-hackers-win32 по дате отправления:

Предыдущее
От: Vitaly Belman
Дата:
Сообщение: Still can't connect :(
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: performance error