Re: [PERFORM] Response time

2003-11-04 Thread Neil Conway
On Tue, 2003-11-04 at 09:49, [EMAIL PROTECTED] wrote: > How do we measure the response time in postgresql? In addition to EXPLAIN ANALYZE, the log_min_duration_statement configuration variable and the \timing psql command might also be useful. -Neil ---(end of broadcast

Re: [PERFORM] Response time

2003-11-04 Thread Pavel Stehule
Hello explain analyse select * from lidi; QUERY PLAN --- Seq Scan on lidi (cost=0.00..1.04 rows=4 width=96) (actual time=0.046..0.092 rows=4 loops=1) Total run

Re: [PERFORM] Response time

2003-11-04 Thread radha.manohar
How do we measure the response time in postgresql? Your response would be very much appreciated. Thanks and Regards, Radha ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [PERFORM] Ignoring index on (A is null), (A is not null) conditions

2003-11-04 Thread Cestmir Hybl
First of all, thanks for all your suggestions. They were of two classes: 1. use different data representation (special constant from column domain instead of NULL) This is possible, of course, but it makes data model less portable and requires changes in database abstraction layer of application