| From: | Federico Di Gregorio <fog(at)initd(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-bugs(at)postgresql(dot)org, fog(at)initd(dot)org |
| Subject: | Re: BUG #1286: indices not used after a pg_restore |
| Date: | 2004-10-14 11:06:39 |
| Message-ID: | 1097751999.3427.12.camel@lana.initd.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Thu, 2004-10-14 at 06:54 -0400, Tom Lane wrote:
> "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> > After a pg_dump/pg_restore (using the tar format) queries that were using
> > the indices don't use them anymore until the indices are dropped and
> > recreated. After that the indices are used the correct way.
>
> I do not believe that you remembered to ANALYZE after restore.
unfortunately for your belief, i remembered. :)
also, this problem can be replicated at will. i can send a dump that
exposes the problem if necessary but i'll need some time to purge
customers data and create a dump a can freely send.
--
Federico Di Gregorio http://people.initd.org/fog
Debian GNU/Linux Developer fog(at)debian(dot)org
INIT.D Developer fog(at)initd(dot)org
Debian. The best software from the best people [see above]
-- brought to you by One Line Spam
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2004-10-14 16:45:20 | Re: SELECT FOR UPDATE and LIMIT 1 behave oddly |
| Previous Message | Tom Lane | 2004-10-14 10:54:55 | Re: BUG #1286: indices not used after a pg_restore |