[PERFORM] horrible performance when trying to connect to PostgreSQL using ODBC

2003-11-06 Thread Adrian Maier
Hello guys ! I am trying to connect to pgsql using ODBC from Visual Objects (for the ones who don't know what is Visual Objects, it's an IDE with its own object-oriented language made by Computer Associates. VO's roots are related to Clipper. ). The time it takes to get the list of the tables, and

Re: [PERFORM] horrible performance when trying to connect to PostgreSQL using ODBC

2003-11-06 Thread Tom Lane
Adrian Maier <[EMAIL PROTECTED]> writes: > I begin to think that there is something fishy about the ODBC > support installed on the laptop (i have recently "inherited" the > laptop from someone else, and i haven't reinstalled the os ). You'd be better off asking these questions on pgsql-odbc. I'm

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

2003-11-06 Thread Christopher Browne
"Private" <[EMAIL PROTECTED]> writes: > Try this benchmark on PostgreSQL, MySQL, FireBird, Oracle: > > http://go.jitbot.com/dbbench-pg-fb-mys-orcl It looks like a good candidate for adding in a plpgsql stored procedure to get similar speedups to what was gotten with the Oracle benchmark. It looks

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

2003-11-06 Thread Hannu Krosing
Christopher Browne kirjutas N, 06.11.2003 kell 20:23: > "Private" <[EMAIL PROTECTED]> writes: > > Try this benchmark on PostgreSQL, MySQL, FireBird, Oracle: > > > > http://go.jitbot.com/dbbench-pg-fb-mys-orcl > > It looks like a good candidate for adding in a plpgsql stored > procedure to get simi

Re: [PERFORM] Pg+Linux swap use

2003-11-06 Thread Bruce Momjian
Greg Stark wrote: > > William Yu <[EMAIL PROTECTED]> writes: > > > Rob Sell wrote: > > > > > Not being one to hijack threads, but I haven't heard of this performance hit > > > when using HT, I have what should all rights be a pretty fast server, dual > > > 2.4 Xeons with HT 205gb raid 5 array, 1