Re: query optimization

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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@xxxxxxxxx> wrote:
      On Tue, Nov 24, 2009 at 12:49 AM, Faheem Mitha <faheem@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance




--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux