Postgres Pro
Downloads
Home   >   mailing lists

Re: cross table indexes or something? - Mailing list pgsql-performance

From Neil Conway
Subject Re: cross table indexes or something?
Date
Msg-id 87llpu288o.fsf@mailbox.samurai.com
Whole thread Raw
In response to Re: cross table indexes or something?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: cross table indexes or something?
List pgsql-performance
Tree view 
Josh Berkus <josh@agliodbs.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

pgsql-performance by date:

Previous
From: Vivek Khera
Date:
Subject: autovacuum daemon stops doing work after about an hour
Next
From: Greg Stark
Date:
Subject: Re: A question on the query planner