Search Postgresql Archives

Re: In memory Database for postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux