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

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

pgsql-performance by date

Next:From: Sebastian JörgensenDate: 2009-11-24 00:07:33
Subject: Re: query optimization
Previous:From: Faheem MithaDate: 2009-11-23 23:49:18
Subject: Re: query optimization

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