Re: good pc but bad performance,why?

Поиск
Список
Период
Сортировка
От Steven Butler
Тема Re: good pc but bad performance,why?
Дата
Msg-id 001c01c41c8c$993eded0$fd08a8c0@steve
обсуждение исходный текст
Ответ на Re: good pc but bad performance,why?  (huang yaqin <hyq@gthome.com>)
Список pgsql-performance
It sounds almost like you're doing one insert per transaction.  Try wrapping
multiple inserts into a single transaction and see if that helps.  This may
not be appropriate for your application, but it does guarantee that
committed transactions will not be lost.

My apologies if you are already doing this. :)

BEGIN;
insert ...
insert ...
insert ...
COMMIT;

Regards,
Steve Butler

----- Original Message -----
From: "huang yaqin" <hyq@gthome.com>
To: "Richard Huxton" <dev@archonet.com>
Cc: <pgsql-performance@postgresql.org>
Sent: Wednesday, April 07, 2004 6:56 PM
Subject: Re: [PERFORM] good pc but bad performance,why?


Hello, Richard Huxton,

  You said  turning fsync off may cause losing data, that's terrible.
I use SCSI disk, and file system is ext3. I tune postgresql.conf and can't
get any improvement. So what can I do?
Does SCSI disk and IDE disk have difference?

     Regards,
Huang yaqin



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

Предыдущее
От: Dennis Bjorklund
Дата:
Сообщение: Re: good pc but bad performance,why?
Следующее
От: Andrew McMillan
Дата:
Сообщение: Re: good pc but bad performance,why?