How often are the tables you query from updated? Rgds Sebastian
On Tue, Nov 24, 2009 at 12:52 AM, marcin mank <marcin.m...@gmail.com> wrote: > On Tue, Nov 24, 2009 at 12:49 AM, Faheem Mitha <fah...@email.unc.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >
