"Martyn Ashworth" martyn.ashworth@eag.uk.com writes:
What advantages are there to migrating across to PostgreSQL now ?
A database that works "better", is more "stable and has less "interesting extensions". My opinion only, some people love mySQL and I expect we'll have to wait a few generations for Darwin to work and all the mySQL supporters to have gone insane and not had any surviving offspring. (Hint for the hard of thinking: I'm not being entirely serious here.)
The other problem that i can forsee is that apparantly PostgreSQL has an 8k row limit which is not un-workable but would require more time and effort than MySQL for some of my data structures at the present time.
What the hell are you doing if you expect to do more than 8k in a single row? If it's a single large object, you should use the particular support for it (which I admit I'm bad at using). If it's really unavoidable, you can change that limit to something larger by recompiling.
I would appreciate any helpful feedback here as the only useful comparison i've found so far seems to be inconclusive to say the least !!
All comparisons but one's own are inconclusive...