| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jaime Casanova <systemguards(at)gmail(dot)com> |
| Cc: | Csaba Nagy <nagy(at)ecircle-ag(dot)com>, Mage <mage(at)mage(dot)hu>, Richard Huxton <dev(at)archonet(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: is this a bug or I am blind? |
| Date: | 2005-12-15 16:23:01 |
| Message-ID: | 14896.1134663781@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jaime Casanova <systemguards(at)gmail(dot)com> writes:
> On 12/15/05, Csaba Nagy <nagy(at)ecircle-ag(dot)com> wrote:
>> Ok, that explains then the problem... but the index is arguably corrupt
>> in this case, with the important difference that it's not even fixable
>> by reindex...
>>
>> I guess what the OP really wants is a solution to his problem.
> MAGE was reproducing the problem in a little table that can be send
> but now tolds me that the problem in the test table disappear when a
> VACUUM was executed... is this consistent with the idea of locale
> problem?
The VACUUM might have caused the planner not to use the index anymore;
check EXPLAIN.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-15 16:29:12 | Re: 7.4.5 vs 8.0 on Debian/sparc |
| Previous Message | Tom Lane | 2005-12-15 16:19:03 | Re: ?$B@hGZ#O#L$,65$($k!"NY$N1|MMEp;#Ej9F$N?$BJT |