Re: [HACKERS] Optimizer degradation since 8.0

2006-08-21 Thread Tom Lane
Teodor Sigaev <[EMAIL PROTECTED]> writes: > Can I tweak something in 8.1 or it's a bug? It's not a bug, it's an intentional change: 2005-04-24 21:30 tgl * src/: backend/commands/explain.c, backend/executor/nodeBitmapIndexscan.c, backend/executor/nodeIndexscan.c, backend/

[HACKERS] Optimizer degradation since 8.0

2006-08-21 Thread Teodor Sigaev
Table with one million rows: wow=# \d _document83 Table "public._document83" Column |Type | Modifiers +-+--- _idrref| bytea | not null _marked| boolean |