Re: [HACKERS] PostgreSQL performance enhancement when query planner fails to

2006-08-09 Thread Jim C. Nasby
On Mon, Aug 07, 2006 at 10:47:39PM +0200, Lukas Smith wrote: > Constantin Teodorescu wrote: > > >EXPLAIN VARIANTS SELECT .. (and so on) that will display the > >different query plans analyzed by the planner and their "estimated time > >values" , not just the "best guess" . > > > >assuming th

Re: [HACKERS] PostgreSQL performance enhancement when query planner fails to

2006-08-07 Thread Lukas Smith
Constantin Teodorescu wrote: EXPLAIN VARIANTS SELECT .. (and so on) that will display the different query plans analyzed by the planner and their "estimated time values" , not just the "best guess" . assuming that the EXPLAIN VARIANTS will show 3 or 4 different query plans, the database

[HACKERS] PostgreSQL performance enhancement when query planner fails to guess the right plan

2006-08-07 Thread Constantin Teodorescu
Hello all, hope you are remembering me, some years ago I've designed the PgAccess , the Tcl/Tk visual interface to PostgreSQL. Thought you haven't received any news from me, I continued working with PostgreSQL, being involved in very big projects in Romania. Right now, the national identificati