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

Re: query optimization

From: Sebastian J├Ârgensen <jorgensen(dot)sebastian(at)gmail(dot)com>
To:
Cc: Faheem Mitha <faheem(at)email(dot)unc(dot)edu>, pgsql-performance(at)postgresql(dot)org
Subject: Re: query optimization
Date: 2009-11-24 00:07:33
Message-ID: 1bd00d800911231607x5087505er429229083cb5d642@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
How often are the tables you query from updated?

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

Responses

pgsql-performance by date

Next:From: Faheem MithaDate: 2009-11-24 04:49:41
Subject: Re: query optimization
Previous:From: marcin mankDate: 2009-11-23 23:52:30
Subject: Re: query optimization

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