From: Richard Huxton <dev@archonet.com>
To: Patrice Beliveau <pbeliveau@avior.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: Difference in query plan
Date: Fri, 14 Nov 2008 17:14:17 +0000
Message-ID: <491DB1E9.6030500@archonet.com> (raw)
In-Reply-To: <491DB061.4020002@avior.ca>
References: <491DB061.4020002@avior.ca>
Patrice Beliveau wrote:
> Thanks,
>
> I'm already doing a vacuum full every night on all database, but the
> REINDEX fix it and now it's working fine
Are you sure it was the REINDEX? The plan was using a sequential scan.
> But this raise a question
>
> 1) This table is cleared every night and recomputed, does this mean that
> I should REINDEX every night also
Looks like you should. Or drop the indexes, load the data, re-create the
indexes, that can be quicker.
> 2) Why this thing didn't happen in the other schema
Have you re-loaded schema1 more often? It might even be the particular
order that rows are loaded - a btree can become "unbalanced" sometimes.
--
Richard Huxton
Archonet Ltd
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-performance@postgresql.org
Cc: dev@archonet.com, pbeliveau@avior.ca
Subject: Re: Difference in query plan
In-Reply-To: <491DB1E9.6030500@archonet.com>
* 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