Re: query optimization

Поиск
Список
Период
Сортировка
От marcin mank
Тема Re: query optimization
Дата
Msg-id b1b9fac60911231552p4cbadf9bue9a06784836c3f7d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: query optimization  (Faheem Mitha <faheem@email.unc.edu>)
Ответы Re: query optimization
Список pgsql-performance
On Tue, Nov 24, 2009 at 12:49 AM, Faheem Mitha <faheem@email.unc.edu> wrote:
>
> Yes, sorry. I'm using Postgresql 8.4. I guess I should go through diag.pdf
> and make sure all the information is current. Thanks for pointing out my
> error.
>

excellent report!

about the copy problem: You seem to have created the primary key
before doing the copy (at least that`s what the dump before copy
says). This is bad. Create it after the copy.

Greetings
Marcin

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

Предыдущее
От: Faheem Mitha
Дата:
Сообщение: Re: query optimization
Следующее
От: Sebastian Jörgensen
Дата:
Сообщение: Re: query optimization