Re: full table...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: full table...
Дата
Msg-id 2284.1029811989@sss.pgh.pa.us
обсуждение исходный текст
Ответ на full table...  (Felson <felson123@yahoo.com>)
Ответы Re: full table...  (Felson <felson123@yahoo.com>)
Список pgsql-novice
Felson <felson123@yahoo.com> writes:
> I have a table that stores a HUGE volume of data every
> day. I am now running into a problem where when I try
> to insert data, the remote connection times out
> because it takes to long... (1 minute)

How much is HUGE?  I'm having a really hard time believing that a simple
insert could take > 1min regardless of table size ... are there perhaps
triggers or rules or foreign-key references on this table that could be
eating the time?

            regards, tom lane

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

Предыдущее
От: Felson
Дата:
Сообщение: full table...
Следующее
От: Josh Berkus
Дата:
Сообщение: Part 2 of Joy of Index up