Re: Slow Inserts on 1 table?

Поиск
Список
Период
Сортировка
От Gregory Youngblood
Тема Re: Slow Inserts on 1 table?
Дата
Msg-id FE325C8B-5C5C-4C8D-9B47-87D891C58FBE@mac.com
обсуждение исходный текст
Ответ на Re: Slow Inserts on 1 table?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: Slow Inserts on 1 table?
Список pgsql-general
Дерево обсуждения

On Aug 2, 2005, at 8:16 AM, Alvaro Herrera wrote:

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.

Not to fan the flames, so to speak, but I do have on question. If this is a known limitation, I'd expect the behavior to be consistent. Instead, he is saying that the problem is intermittent. Sometimes it runs fine, other times it slows down to a snail's pace. 

So, does that mean the known problem is indeed intermittent, and not something that happens every time? Or, is this an issue that can be mostly eliminated with appropriate tuning?

I ask, because I may soon be facing similar problems, and forewarned is forearmed. I'd like to anticipate this and tune things accordingly before it becomes an issue.

Thanks,
Greg

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