[GENERAL] External Large objects what became of them

2000-11-19 Thread Willis, Ian (Ento, Canberra)
Does anyone know what the status of external large objects is? Did they disappear without a trace and will they ever make a comeback? I was reading about Xdelta the other night and I thought that postgresql would be a great interface for this sort of program if it still supported the interface.

RE: [GENERAL] Running several postmaster using same database in parallel

2000-11-23 Thread Willis, Ian (Ento, Canberra)
My guess is that the problem is a very difficult one to solve well. The backends have to reliably communicate between each other in order to stop two processes writing to the one record. The communication times between 2 processes on the one machine and on two different machines would be at least

RE: [GENERAL] Best practice

2001-04-19 Thread Willis, Ian (Ento, Canberra)
What would the the best choice for the WAL mirroring, raid3 or 5. How big does the WAL grow? mirroring is fine as long as the size isn't too big. -- Ian Willis -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Friday, 20 April 2001 9:22 AM To: [EMAIL PROTECTED] Cc: [EM

RE: [GENERAL] Ideal hardware configuration for pgsql

2001-05-02 Thread Willis, Ian (Ento, Canberra)
I would make sure that an intel box won't suit before looking at sun. Simply for cost and if you're planning to run linux on it sun support will be shit because they don't have skills in that area. Databases thrive on more spindles, separate system spindles from the db spindles and swap spindles,

RE: [GENERAL] Ideal hardware configuration for pgsql

2001-05-02 Thread Willis, Ian (Ento, Canberra)
I think that all this fat should be put on the fire. A nice performance test on the same high end hardware would be good. Is there a test suite that would suit? Would anyone expect more than a 5% difference in performance between the OS's even using the dreaded ext2 and not the reiserfs or SGI XFS

RE: [GENERAL] Queries across multiple databases (was: SELECT from a table in another database).

2001-05-20 Thread Willis, Ian (Ento, Canberra)
Oracle financials has about 2000 tables in a single database :> but of course that must not be designed using structured design techniques. -- Ian Willis -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Saturday, 19 May 2001 12:45 AM To: Trygve Falch Cc: [EMAIL PROTECTE