Greetings,
Based on some experimentation and reading through the code in:
src/backend/utils/adl/timestamp.c ; it would appear that there's no
error-checking when receiving a binary timestamp. I wouldn't care if
I had figured out the binary timestamp format on the first shot but
apparent
The following bug has been logged online:
Bug reference: 1122
Logged by: P Buder
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.3.5
Operating system: Debian Linux
Description:limit 1 doing a sequential scan
Details:
I am actually running 7.3.6 but that
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> When I do a select * from table limit 1
> Postgresql does a sequential scan on the whole table.
AFAICS you simply are misreading the EXPLAIN output.
(It also sounds like you haven't vacuumed or analyzed that table in a
mighty long time... if y