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
2009/4/12 John R Pierce pie...@hogranch.com:
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
: [GENERAL] In memory Database for postgres
2009/4/12 John R Pierce pie...@hogranch.com:
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
2009/4/13 aravind chandu avin_frie...@yahoo.com:
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
On Mon, Apr 13, 2009 at 2:06 PM, aravind chandu avin_frie...@yahoo.com 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
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
in
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
] In memory Database for postgres
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 bl.oleszkiew...@gmail.com
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
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,
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
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
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 operations
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
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
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 solution
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 cubes in
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
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 with my
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 schema
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 think
21 matches
Mail list logo