Re: [GENERAL] performace review

2006-10-23 Thread Wes Sheldahl
On 10/22/06, Tom Lane [EMAIL PROTECTED] wrote: Joshua D. Drake [EMAIL PROTECTED] writes: Ron Johnson wrote: That implies malice.The people at OpenCRX apparently really believe what they wrote. I believe they probably do believe it and it was probably driven by a complete lack of understanding of

Re: [GENERAL] performace review

2006-10-22 Thread Thomas Hallgren
Joshua D. Drake wrote: Tomi NA wrote: I was just reading http://www.opencrx.org/faq.htm where RDBMS engines are one of the questions and see pgsql bashed sentence after sentence. Can anyone offer any insight as to weather it's fact or FUD? It is 100% FUD. What would be the incentive for

Re: [GENERAL] performace review

2006-10-22 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/22/06 06:45, Thomas Hallgren wrote: Joshua D. Drake wrote: Tomi NA wrote: I was just reading http://www.opencrx.org/faq.htm where RDBMS engines are one of the questions and see pgsql bashed sentence after sentence. Can anyone offer any

Re: [GENERAL] performace review

2006-10-22 Thread Joshua D. Drake
Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/22/06 06:45, Thomas Hallgren wrote: Joshua D. Drake wrote: Tomi NA wrote: I was just reading http://www.opencrx.org/faq.htm where RDBMS engines are one of the questions and see pgsql bashed sentence after sentence. Can

Re: [GENERAL] performace review

2006-10-22 Thread Tom Lane
Joshua D. Drake [EMAIL PROTECTED] writes: Ron Johnson wrote: That implies malice. The people at OpenCRX apparently really believe what they wrote. I believe they probably do believe it and it was probably driven by a complete lack of understanding of PostgreSQL. It doesn't have to be

Re: [GENERAL] performace review

2006-10-09 Thread Merlin Moncure
On 10/7/06, Tomi NA [EMAIL PROTECTED] wrote: I was just reading http://www.opencrx.org/faq.htm where RDBMS engines are one of the questions and see pgsql bashed sentence after sentence. Can anyone offer any insight as to weather it's fact or FUD? FUD postgresql in particular is an enormous

[GENERAL] performace review

2006-10-07 Thread Tomi NA
I was just reading http://www.opencrx.org/faq.htm where RDBMS engines are one of the questions and see pgsql bashed sentence after sentence. Can anyone offer any insight as to weather it's fact or FUD? t.n.a. ---(end of broadcast)--- TIP 2: Don't

Re: [GENERAL] performace review

2006-10-07 Thread Alexander Staubo
On Oct 7, 2006, at 20:06 , Tomi NA wrote: I was just reading http://www.opencrx.org/faq.htm where RDBMS engines are one of the questions and see pgsql bashed sentence after sentence. Can anyone offer any insight as to weather it's fact or FUD? As with any use of a database, it is useless

Re: [GENERAL] performace review

2006-10-07 Thread Jonathan Vanasco
On Oct 7, 2006, at 3:31 PM, Alexander Staubo wrote: I don't see PostgreSQL being bashed sentence after sentence, however -- the two known limitations listed for PostgreSQL are slow (even for small datasets) and jokes [sic] on 3-table-joins -- and among the open-source databases mentioned,

Re: [GENERAL] performace review

2006-10-07 Thread Richard Broersma Jr
did you notice this line --- *** Please note that we do not recommend PostgreSQL for production use. While PostgreSQL may be fine for many settings this DBMS simply does not deliver the performance required for openCRX (PostgreSQL takes minutes/hours to calculate

Re: [GENERAL] performace review

2006-10-07 Thread Brandon Aiken
Title: [GENERAL] performace review It wouldn't surprise me if their bashing were correct, but I doubt that it's PostgreSQL's fault. I download the db source (inside opencrx-1.9.1-core.postgresql-8.zip) and executed their three schema files, dbcreate-indexes.sql, dbcreate-views.sql, dbcreate

Re: [GENERAL] performace review

2006-10-07 Thread Alexander Staubo
On Oct 7, 2006, at 23:44 , Brandon Aiken wrote: I download the db source (inside opencrx-1.9.1- core.postgresql-8.zip) and executed their three schema files, dbcreate-indexes.sql, dbcreate-views.sql, dbcreate-tables.sql. Each of the 118 tables has a three-field composite primary key of

Re: [GENERAL] performace review

2006-10-07 Thread Joshua D. Drake
Tomi NA wrote: I was just reading http://www.opencrx.org/faq.htm where RDBMS engines are one of the questions and see pgsql bashed sentence after sentence. Can anyone offer any insight as to weather it's fact or FUD? It is 100% FUD. Joshua D. Drake t.n.a.

Re: [GENERAL] performace review

2006-10-07 Thread Brandon Aiken
Title: Re: [GENERAL] performace review Denormalization should reduce the number of joins and reduce the overall number of tables, yes? And the idea is to fully normalize and then back off because of physical limitations in the database you're using *with full knowledge and understanding

Re: [GENERAL] performace review

2006-10-07 Thread Chris Browne
[EMAIL PROTECTED] (Richard Broersma Jr) writes: did you notice this line --- *** Please note that we do not recommend PostgreSQL for production use. While PostgreSQL may be fine for many settings this DBMS simply does not deliver the performance required for openCRX

Re: [GENERAL] performace review

2006-10-07 Thread Jonathan Vanasco
On Oct 7, 2006, at 6:41 PM, Chris Browne wrote: This could also be a situation where adding a few useful indexes might fix a lot of ills. Better to try to help fix the problems so as to help show that the comparisons are way off base rather than to simply cast stones... i'm too tight for