[PERFORM] Interbase/Firebird - any users out there - what's the performance like compared to PostgreSQL?
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 comparison between the two? 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? I'm not interested in starting a flame war or anything like that - just a presentation of the facts as you see them, and if you want to put in your opinion also, that's fine, just make a note! TIA. Paul... -- plinehan__AT__yahoo__DOT__com C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro Please do not top-post. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [PERFORM] Interbase/Firebird - any users out there - what's
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 postgresql, but I still like it. It would be my choice for win32 applications (until win32 postgresql port become available). On Wed, 2003-11-05 at 07:28, Paul Ganainm wrote: 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 comparison between the two? 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? I'm not interested in starting a flame war or anything like that - just a presentation of the facts as you see them, and if you want to put in your opinion also, that's fine, just make a note! TIA. Paul... signature.asc Description: This is a digitally signed message part
Re: [PERFORM] Response time
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 addition to EXPLAIN ANALYZE, the log_min_duration_statement configuration variable and the \timing psql command might also be useful. -Neil ---(end of broadcast)--- TIP 8: explain analyze is your friend ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PERFORM] Response time
[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. -Neil ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PERFORM] Response time
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-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly