Re: query optimization

On Tue, 24 Nov 2009, Sebastian Jörgensen wrote:

> How often are the tables you query from updated?

Quite rarely. Once in a while. The large tables, eg. geno, are basically
static.

                                                          Regards, Faheem.

> 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:
>       >
>       > 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
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
>
>
>