Re: cross table indexes or something?

From: Neil Conway <neilc(at)samurai(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu>, postgres performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: cross table indexes or something?
Date: 2003-12-02 21:57:27
Message-ID: 87llpu288o.fsf@mailbox.samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Josh Berkus <josh(at)agliodbs(dot)com> writes:
> 1) to keep it working, you will probably need to run ANALZYE more
> often than you have been;

I'm not sure why this would be the case -- can you elaborate?

> 4) Currently, pg_dump does *not* back up statistics settings.

Yes, it does.

-Neil

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2003-12-02 22:32:11 Re: A question on the query planner
Previous Message Vivek Khera 2003-12-02 20:37:40 autovacuum daemon stops doing work after about an hour