Re: query optimization

From: marcin mank <marcin(dot)mank(at)gmail(dot)com>
To: Faheem Mitha <faheem(at)email(dot)unc(dot)edu>
Cc: Thom Brown <thombrown(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: query optimization
Date: 2009-11-23 23:52:30
Message-ID: b1b9fac60911231552p4cbadf9bue9a06784836c3f7d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sebastian Jörgensen 2009-11-24 00:07:33 Re: query optimization
Previous Message Faheem Mitha 2009-11-23 23:49:18 Re: query optimization