[GENERAL] Test patch for timing EXPLAIN

2001-07-19 Thread Martijn van Oosterhout
Hi, Here is a snapshot of the code I'm fiddling with at the moment which actually tracks how much time is spent executing which parts of the query plan. It still has some issues but it has restored my faith in Postgres' estimation system. It's within an order of magnitude in the tests I've done a

Re: [GENERAL] PG rules! (RULES being the word ;->)

2001-07-19 Thread Janning Vygen
Am Mittwoch, 18. Juli 2001 21:02 schrieb Jason Earl: > At the very least you should use the SQL 92 features > that PostgreSQL has. [...] ok, i can agree to this. > Besides, eventually your users are going to want to > circumvent your middleware for one reason or another. > PostgreSQL's constra

[GENERAL] two constrains for one column

2001-07-19 Thread Ben-Nes Michael
Hi All im trying to do the next thing, is it possible ? CREATE TABLE language ( language serial PRIMARY KEY, shortcut char(2) NOT NULL, unique, -- like il,en,fr,sp ); ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unr

Re: [GENERAL] VACUUM ANALYZE

2001-07-19 Thread Ben-Nes Michael
Hi Im never used gdb so I hope I extracted all the Info needed, any why here it is: GNU gdb 5.0 Copyright 2000 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions.