Re: query optimization
| От | Sebastian Jörgensen |
|---|---|
| Тема | Re: query optimization |
| Дата | |
| Msg-id | 1bd00d800911231607x5087505er429229083cb5d642@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: query optimization (marcin mank <marcin.mank@gmail.com>) |
| Ответы |
Re: query optimization
|
| Список | pgsql-performance |
How often are the tables you query from updated?
Rgds
Sebastian
Rgds
Sebastian
On Tue, Nov 24, 2009 at 12:52 AM, marcin mank <marcin.mank@gmail.com> wrote:
On Tue, Nov 24, 2009 at 12:49 AM, Faheem Mitha <faheem@email.unc.edu> wrote:excellent report!
>
> 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.
>
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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
В списке pgsql-performance по дате отправления: