Hi, where did you put your WAL?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/In-memory-Database-for-postgres-tp1917268p5760845.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgre
If you need to run some database really fast, try to put only all your
indexes onto ram disk. Look here... http://www.linux.com/feature/142658
They use SSD to store indexes (not data) for postgresql. A think the
same conclusions should apply for ram disk too.
And in wrost case (power off for
On Mon, 2009-04-13 at 17:36 -0300, Emanuel Calvo Franco wrote:
> >Thanks for your reply,but what I am actually looking for is
> > database should be an in-memory database and at the same i want to store
> > that data into disk so that data won't be lost when the system restarts or
>
On Mon, Apr 13, 2009 at 2:06 PM, aravind chandu wrote:
>
>
> Hello,
>
> Thanks for your reply,but what I am actually looking for is
> database should be an in-memory database and at the same i want to store
> that data into disk so that data won't be lost when the system restarts or
2009/4/13 aravind chandu :
>
>
> Hello,
>
> Thanks for your reply,but what I am actually looking for is
> database should be an in-memory database and at the same i want to store
> that data into disk so that data won't be lost when the system restarts or
> in case of power failure.
edure how to do this? your help
will he greatly appreciated.
Thanks,
Avin.
From: Emanuel Calvo Franco
To: John R Pierce
Cc: postgresql Forums
Sent: Monday, April 13, 2009 11:54:45 AM
Subject: Re: [GENERAL] In memory Database for postgres
2009/4/12 John R P
2009/4/12 John R Pierce :
> aravind chandu wrote:
>>
>> I created in-memory database but the problem is all the data
>> will be accessed from main memory .when ever the system is restarted the
>> entire data that is in the tables will lost.Is there any way to dump all the
>> data in to l
aravind chandu wrote:
I created in-memory database but the problem is all the
data will be accessed from main memory .when ever the system is
restarted the entire data that is in the tables will lost.Is there any
way to dump all the data in to local hard disk before restarting the
similar method to save the
data in to a permanent storage.
Thanks,
Avin.
From: Blazej
To: avin_frie...@yahoo.com
Cc: postgresql Forums
Sent: Monday, November 17, 2008 4:26:46 PM
Subject: Re: [GENERAL] In memory Database for postgres
Sorry I forgot about
On 2008-11-17 23:26, Blazej wrote:
CREATE TABLESPACE ram_space LOCATION '/mnt/ram0/pgspace';
And then:
CREATE TABLE (...) TABLESPACE ram_space;
and table is in memory.
And when your server will loose power or hang now then your database
will not start after reboot.
I'd rather start a new, t
On Mon, Nov 17, 2008 at 7:13 PM, Robert Treat
<[EMAIL PROTECTED]> wrote:
> On Monday 17 November 2008 17:02:54 Blazej wrote:
>> Of course you must delete schema before shutdown PostgreSQL and OS - I
>> dont't now how resolve problem with error when the schema was not
>> deleted? - I have no time to
On Monday 17 November 2008 17:02:54 Blazej wrote:
> Of course you must delete schema before shutdown PostgreSQL and OS - I
> dont't now how resolve problem with error when the schema was not
> deleted? - I have no time to think about it maybe anybody know how to
> restore db when the in memory sche
2008/11/18 Scott Marlowe <[EMAIL PROTECTED]>:
> On Mon, Nov 17, 2008 at 3:02 PM, Blazej <[EMAIL PROTECTED]> 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 w
On Mon, 17 Nov 2008, Scott Marlowe wrote:
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.
With a large increase in work_mem as well to speed up sorting. If the
bottleneck is
On Mon, Nov 17, 2008 at 3:02 PM, Blazej <[EMAIL PROTECTED]> 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 cub
Sorry I forgot about create tablespace script - this is the SQL script:
CREATE TABLESPACE ram_space LOCATION '/mnt/ram0/pgspace';
And then:
CREATE TABLE (...) TABLESPACE ram_space;
and table is in memory.
Regards,
Blazej
2008/11/17 Blazej <[EMAIL PROTECTED]>:
> In my opinion very nice solutio
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
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of aravind chandu
Sent: Monday, November 17, 2008 11:11 AM
To: postgresql Forums
Subject: [GENERAL] In memory Database for postgres
Hello,
I guess most of you guys heard about In Memory Database.I
have a small question
On Mon, Nov 17, 2008 at 12:11 PM, aravind chandu <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I guess most of you guys heard about In Memory Database.I have
> a small question regarding it.I need to create an In Memory Database for
> postgresql through which I have to perform various opera
2008/11/18 aravind chandu <[EMAIL PROTECTED]>:
> Hello,
Hi!
> I guess most of you guys heard about In Memory Database.I have
> a small question regarding it.I need to create an In Memory Database for
> postgresql through which I have to perform various operations on postgresql
> data
Hello,
I guess most of you guys heard about In Memory Database.I have a small
question regarding it.I need to create an In Memory Database for
postgresql through which I have to perform various operations on
postgresql database(queries,procedures,programs using pqxx API
etc...).I
21 matches
Mail list logo
