Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Partial index causing wrong results to be returned on 8.1.3
- From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
- To: pgsql-bugs(at)postgresql(dot)org
- Subject: Re: Partial index causing wrong results to be returned on 8.1.3
- Date: Tue, 29 Aug 2006 05:03:13 -0000
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > If it gives right answers after you increase work_mem sufficiently, > I'd bet on this one ... That's a good bet. Changing it from 1024 to 3500 did the trick ... only one row returned, even when using the index. Thanks very much! - -- Greg Sabino Mullane greg(at)turnstep(dot)com End Point Corporation PGP Key: 0x14964AC8 200608290100 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFE88nuvJuQZxSWSsgRAkA8AJ9xKgOcEmK4swC0Dji4WtEs4p+juwCeIHJN xyNAvlAT5c2O6pWI0C2G03I= =EvGR -----END PGP SIGNATURE-----
- References:
- Prev by Date: Re: Partial index causing wrong results to be returned on 8.1.3
- Next by Date: Re: BUG #2592: ILIKE does not care about locales
- Previous by thread: Re: Partial index causing wrong results to be returned on 8.1.3
- Next by thread: Partially corrupted table
- Indexes: