Re: Delete slow...

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Delete slow...
Дата
Msg-id 1133296595.28788.75.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Re: Delete slow...  (Diego <diego@unimedijui.com.br>)
Ответы Re: Delete slow...
Список pgsql-admin
On Tue, 2005-11-29 at 15:32, Diego wrote:
> Thanks by answers...
>
> For each record deleted, my postgresql server spended 4 seconds...
> I know because i have logged each sql instruction, showing the time spended.
>
> My question is: is normal this time to a big table (400,000 records)

Do you have any foreign keys involved here?  You might need some indexes
for faster lookups.

And don't worry about your english, I'm sure it's 1,000 times better
than most of our Portuguese.

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

Предыдущее
От: Diego
Дата:
Сообщение: Re: Delete slow...
Следующее
От: "Andrea"
Дата:
Сообщение: Fatal : IDENT authentication