[Tracker-discuss] [issue326] Postgres error: invalid page header ...

Martin v. Löwis metatracker at psf.upfronthosting.co.za
Fri Mar 26 21:28:57 CET 2010


Martin v. Löwis <martin at v.loewis.de> added the comment:

> What does  "EXPLAIN  select * from _file where __retired__=0;" give you?
> 
> I get "Index Scan using _file_retired_idx on _file  ..." after setting
> enable_seqscan to off, but "Seq Scan on _file ..." in the default
> case.

Same here.

> select * from _file where __retired__=0 and id>15000;

That does indeed produce a result. Not sure how this is going to help,
though.

_______________________________________________________
PSF Meta Tracker <metatracker at psf.upfronthosting.co.za>
<http://psf.upfronthosting.co.za/roundup/meta/issue326>
_______________________________________________________


More information about the Tracker-discuss mailing list