Re: [PERFORM] mysql to postgresql, performance questions

2010-03-20 Thread Andy Colson
On 03/18/2010 09:31 AM, Corin wrote: Hi all, I'm running quite a large social community website (250k users, 16gb database). We are currently preparing a complete relaunch and thinking about switching from mysql 5.1.37 innodb to postgresql 8.4.2. The database server is a dual dualcore operton 22

Re: [PERFORM] GiST index performance

2010-03-20 Thread Yeb Havinga
On Fri, Mar 19, 2010 at 10:16 PM, Kenneth Marshall wrote: > Hi Yeb, > > I have not looked at the gist code, but would it be possible to > make virtual pages that have a size that is 1/power-of-2 * blocksize. > Then the leaf node could be 1/8 or even 1/16 the size of the full > pagesize. > Hello