Re: [PERFORM] Response time

2003-11-05 Thread Andrew Sullivan
On Wed, Nov 05, 2003 at 11:35:22AM -0600, [EMAIL PROTECTED] wrote: > The \timing psql command gives different time for the same query executed > repeatedly. Why do you believe that the same query will always take the same time to execute? A -- Andrew Sullivan 204-41

Re: [PERFORM] Response time

2003-11-05 Thread Neil Conway
<[EMAIL PROTECTED]> writes: > The \timing psql command gives different time for the same query executed > repeatedly. That's probably because executing the query repeatedly results in different execution times, as one would expect. \timing returns the "exact" query response time, nevertheless. -N

Re: [PERFORM] Response time

2003-11-05 Thread radha.manohar
The \timing psql command gives different time for the same query executed repeatedly. So, how can we know the exact response time for any query? Thanks and Regards, Radha > On Tue, 2003-11-04 at 09:49, [EMAIL PROTECTED] wrote: >> How do we measure the response time in postgresql? > > In additio

Re: [PERFORM] Interbase/Firebird - any users out there - what's

2003-11-05 Thread Franco Bruno Borghesi
About a year ago I programmed a php/firebird application, and I've never had a problem with firebird. It's a small database (a few megabytes), but it just works day after day. I've seen firebird has updatable views, they seem to work very well. I have the feeling that It's not as flexible as

Re: [PERFORM] Interbase/Firebird - any users out there - what's the

2003-11-05 Thread Shridhar Daithankar
Paul Ganainm wrote: Does Interbase/Firebird have (as far as people here are concerned) any show-stoppers in terms of functionality which they do have on PostgreSQL? Or, indeed, the other way round? Personally I think native windows port is plus that interbase/firebird has over postgresql. It als

[PERFORM] Interbase/Firebird - any users out there - what's the performance like compared to PostgreSQL?

2003-11-05 Thread Paul Ganainm
Hi all, I have just started with PostgreSQL on Linux and in the past I've done a good bit of work on Interbase (both on Windows and Linux). What I want to know here is What do people here think of Interbase/Firebird? Has anybody done performance metrics or could they point me to a compa