Re: Slow Inserts on 1 table?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Slow Inserts on 1 table?
Дата
Msg-id 20050802151616.GB30066@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Slow Inserts on 1 table?  (Dan Armbrust <daniel.armbrust.list@gmail.com>)
Ответы Re: Slow Inserts on 1 table?  (Dan Armbrust <daniel.armbrust.list@gmail.com>)
Re: Slow Inserts on 1 table?  (Gregory Youngblood <gsyoungblood@mac.com>)
Список pgsql-general
On Tue, Aug 02, 2005 at 10:01:50AM -0500, Dan Armbrust wrote:

> I shouldn't have to manually run Analyze to make the DB be capable of
> handling inserts involving tables with foreign keys correctly.  My code
> that is doing the inserts is a java application that works across
> multiple DBS - MySQL, PostgreSQL, DB2, MS Access, Sybase, etc.

[etc, rant removed]

You don't _have_ to be rude.  This is a known limitation, and people
have suggested the usual workarounds.  This is an open source project --
if you think you can make it better, please by all means post a patch.

HAND.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"El sentido de las cosas no viene de las cosas, sino de
las inteligencias que las aplican a sus problemas diarios
en busca del progreso." (Ernesto Hernández-Novich)

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Slow Inserts on 1 table?
Следующее
От: Dan Armbrust
Дата:
Сообщение: Re: Slow Inserts on 1 table?