Re: [GENERAL] postgres vs. oracle for very large tables

2006-06-13 Thread Joshua D. Drake
Jim C. Nasby wrote: On Mon, May 15, 2006 at 12:24:51PM -0700, TJ O'Donnell wrote: I've written some extensions to postgres to implement chemical structure searching. I get inquiries about the performance of postgres vs. oracle. This is a huge topic, with lots of opinions and lots of facts. Bu

Re: [GENERAL] postgres vs. oracle for very large tables

2006-06-13 Thread Trent Shipley
On Tuesday 2006-06-13 16:19, Jim C. Nasby wrote: > On Mon, May 15, 2006 at 12:24:51PM -0700, TJ O'Donnell wrote: > > I've written some extensions to postgres to implement > > chemical structure searching. I get inquiries about > > the performance of postgres vs. oracle. This is a huge > > topic,

Re: [GENERAL] postgres vs. oracle for very large tables

2006-06-13 Thread Jim C. Nasby
On Mon, May 15, 2006 at 12:24:51PM -0700, TJ O'Donnell wrote: > I've written some extensions to postgres to implement > chemical structure searching. I get inquiries about > the performance of postgres vs. oracle. This is a huge > topic, with lots of opinions and lots of facts. But, > today I go

Re: [GENERAL] postgres vs. oracle for very large tables

2006-05-17 Thread Graves, John
On Mon, 15 May 2006 16:00:04 -0500, Scott Marlowe wrote: > 5: You're gonna need to load test this to see. You can get > the oracle 10G express for free. I think that one handles > multiple connections, but is limited to 2 gigs of data. The exact limitations of Oracle Database XE are as follows

Re: [GENERAL] postgres vs. oracle for very large tables

2006-05-15 Thread Scott Marlowe
On Mon, 2006-05-15 at 14:24, TJ O'Donnell wrote: > I've written some extensions to postgres to implement > chemical structure searching. I get inquiries about > the performance of postgres vs. oracle. This is a huge > topic, with lots of opinions and lots of facts. But, > today I got some feedba

[GENERAL] postgres vs. oracle for very large tables

2006-05-15 Thread TJ O'Donnell
I've written some extensions to postgres to implement chemical structure searching. I get inquiries about the performance of postgres vs. oracle. This is a huge topic, with lots of opinions and lots of facts. But, today I got some feedback stating the opinion that: "Postgres performance diminis