From: | Faheem Mitha <faheem(at)email(dot)unc(dot)edu> |
---|---|
To: | Sebastian Jörgensen <jorgensen(dot)sebastian(at)gmail(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: query optimization |
Date: | 2009-11-24 04:49:41 |
Message-ID: | alpine.DEB.2.00.0911232349070.2983@orwell.homelinux.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(dot)mank(at)gmail(dot)com> wrote:
> On Tue, Nov 24, 2009 at 12:49 AM, Faheem Mitha <faheem(at)email(dot)unc(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | ramasubramanian | 2009-11-24 05:38:20 | Query is slow when executing in procedure |
Previous Message | Sebastian Jörgensen | 2009-11-24 00:07:33 | Re: query optimization |