Skip site navigation (1) Skip section navigation (2)

Re: query optimization

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 (view raw or flat)
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
> 
> 
> 
>

In response to

pgsql-performance by date

Next:From: ramasubramanianDate: 2009-11-24 05:38:20
Subject: Query is slow when executing in procedure
Previous:From: Sebastian JörgensenDate: 2009-11-24 00:07:33
Subject: Re: query optimization

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group