Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with planner choosing nested loop - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Problem with planner choosing nested loop
Date
Msg-id dcc563d10804021127ie4c4e1br90f9c6722da4ae1b@mail.gmail.com
Whole thread Raw
In response to Re: Problem with planner choosing nested loop  ("Rodrigo E. De León Plicet" <rdeleonp@gmail.com>)
List pgsql-general
Tree view 
On Wed, Apr 2, 2008 at 12:12 PM, Rodrigo E. De León Plicet
<rdeleonp@gmail.com> wrote:
> Also important, consider creating additional indexes based on your
>  access patterns.

Good point.  Note that you can create indexes and then track their
usefulness with the pg_stat_user_indexes view, which I find incredibly
useful.  In fact, all the pg_stat_ views are useful.

pgsql-general by date:

Previous
From: Alex Solovey
Date:
Subject: Re: Problem with planner choosing nested loop
Next
From: "Morris Goldstein"
Date:
Subject: Re: Can Postgres 8.x start if some disks containing tablespaces are not mounted?