[PERFORM] Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options

2004-09-12 Thread mudfoot
Hi, I'd like to help with the topic in the Subject: line. It seems to be a TODO item. I've reviewed some threads discussing the matter, so I hope I've acquired enough history concerning it. I've taken an initial swipe at figuring out how to optimize sync'ing methods. It's based larg

Re: [PERFORM] Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables

2004-09-12 Thread Christopher Browne
The world rejoiced as Mischa Sandberg <[EMAIL PROTECTED]> wrote: > Mark Cotner wrote: >> Requirements: >> Merge table definition equivalent. We use these >> extensively. > Looked all over mysql.com etc, and afaics merge table is indeed > exactly a view of a union-all. Is that right? > PG support

Re: [PERFORM] TSearch2 and optimisation ...

2004-09-12 Thread George Essig
--- Herv� wrote: > George, > > I have well read many pages about this subject ... but I have not found any > thing for the moment to really help me ... > What can I do to optimize my PostgreSQL configuration for a special use of > Tsearch2 ... > I'm a little dispointed looking the Postgresql Ru

Re: [PERFORM] Data Warehouse Reevaluation - MySQL vs Postgres

2004-09-12 Thread Gaetano Mendola
Mark Cotner wrote: Requirements: Merge table definition equivalent. We use these extensively. What do you mean with "merge table definition equivalent"? Regards Gaetano Mendola ---(end of broadcast)--- TIP 2: you can get off all lists at once wit