From: Seb <spluque@gmail.com>
To: pgsql-sql@postgresql.org
Subject: indexes
Date: Fri, 15 Jan 2010 10:04:56 -0600
Message-ID: <87iqb3z74n.fsf@kolob.sebmags.homelinux.org> (raw)
Hi,
I have some views and queries that take a bit too long to return, so
perhaps some judicious indexes might help, but I don't know much about
how to use them. The PostgreSQL manual has a good section on indexes,
but I can't find guidance on (unless I missed something):
o How to decide what columns need an index?
o Should all foreign keys have an index?
o Naming conventions?
o Does PostgreSQL use available indexes that can be useful in any query,
without the user having to do anything in particular?
I'd appreciate any pointers to documents with guidance on these
questions. Thanks.
--
Seb
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: spluque@gmail.com
Subject: Re: indexes
In-Reply-To: <87iqb3z74n.fsf@kolob.sebmags.homelinux.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox