Re: [GENERAL] [HACKERS] [pgsql-advocacy] Need concrete 'Why Postgres

2003-08-22 Thread Andrew Dunstan
> On Friday 22 August 2003 13:59, Andrew Dunstan wrote: >> Shridhar Daithankar wrote: >> >BTW any comments on storing an entire database in single file? I >> >don't >> > trust any file system for performance and data integrity if I have >> > single 100GB file. I would rather have multiple of them..

Re: [GENERAL] [HACKERS] [pgsql-advocacy] Need concrete "Why Postgres

2003-08-22 Thread Shridhar Daithankar
On Friday 22 August 2003 13:59, Andrew Dunstan wrote: > Shridhar Daithankar wrote: > >BTW any comments on storing an entire database in single file? I don't > > trust any file system for performance and data integrity if I have single > > 100GB file. I would rather have multiple of them.. > > I don

Re: [GENERAL] [HACKERS] [pgsql-advocacy] Need concrete "Why Postgres

2003-08-22 Thread Andrew Dunstan
Shridhar Daithankar wrote: BTW any comments on storing an entire database in single file? I don't trust any file system for performance and data integrity if I have single 100GB file. I would rather have multiple of them.. I don't see why not. Entire file systems are stored within a single fi

Re: [GENERAL] [HACKERS] [pgsql-advocacy] Need concrete "Why Postgres not MySQL" bullet list

2003-08-21 Thread Shridhar Daithankar
On 21 Aug 2003 at 21:30, Manfred Koizar wrote: > On Thu, 21 Aug 2003 15:05:52 +0200, I wrote: > >>Just wondering, what other databases has transactable DDLs? > > > >Firebird. > > Stop! I withdraw that statement. I must have mis-read some feature > list :-( > > Tests with InterBase 6 showed tha

Re: [GENERAL] [HACKERS] [pgsql-advocacy] Need concrete "Why Postgres not MySQL" bullet list

2003-08-21 Thread Ian Barwick
On Thursday 21 August 2003 21:30, Manfred Koizar wrote: > On Thu, 21 Aug 2003 15:05:52 +0200, I wrote: > >>Just wondering, what other databases has transactable DDLs? > > > >Firebird. > > Stop! I withdraw that statement. I must have mis-read some feature > list :-( > > Tests with InterBase 6 show

Re: [GENERAL] [HACKERS] [pgsql-advocacy] Need concrete "Why Postgres not MySQL" bullet list

2003-08-21 Thread Manfred Koizar
On Thu, 21 Aug 2003 15:05:52 +0200, I wrote: >>Just wondering, what other databases has transactable DDLs? > >Firebird. Stop! I withdraw that statement. I must have mis-read some feature list :-( Tests with InterBase 6 showed that you can change metadata within a transaction, but when you ROLLB