2008/11/18 Scott Marlowe <scott.marlowe@xxxxxxxxx>: > On Mon, Nov 17, 2008 at 3:02 PM, Blazej <bl.oleszkiewicz@xxxxxxxxx> wrote: >> In my opinion very nice solution is building part of PostgreSQL >> database in memory - below it is instruction how to build PostgreSQL >> schema in memory in Linux. I tested this with my ROLAP solution for >> recalculation MOLAP cubes in memory and then join with master cube >> (this speeds up proces about 10 times!!! - but in other solution may >> be different). > > Just wondering if you compared it to how fast it runs if you've got > lots of shared_buffers and everything fits into memory. That would be > an interesting comparison. > They are two small thing becouse I do this how I have described above: (1) shared_buffers is SHARED; (2) I needed extremaly speed up so if table stored in hdd it must be sync (sooner or later - even if sync is off), so this operation is very slowly on hdd when it compares to ram_disk. Regards, Blazej -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
