it maybe anybody know how to
restore db when the in memory schema was damaged?
Regards,
Blazej
2008/11/17 aravind chandu [EMAIL PROTECTED]:
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
I'm joing to Tomas - and I want to cite postgresql too in my PhD thesis.
Regards,
Blazej Oleszkiewicz
2008/11/17 Tomas Lanczos [EMAIL PROTECTED]:
I meant something for use in publications, like it is used for R and almost
identically for GRASS:
R Development Core Team (2008). R
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
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
Regards,
Blazej Oleszkiewicz
2008/10/12 James Hitz [EMAIL PROTECTED]:
Dear All,
I have just started experimenting with PGSQL, with a view to migrate from the
SQL server I use currently. I am trying to implement an intelligent Chart
of Accounts for an accounting program. The following is long
There is some my publications about SART AML System, where is more
detailed described all this things (and more) that I wrote below.
http://www.analyticsql.org/documentation.html
Regards,
Blazej Oleszkiewicz
2008/9/4 Blazej [EMAIL PROTECTED]:
Hi Artacus
2008/9/4 Artacus [EMAIL PROTECTED
,
Blazej Oleszkiewicz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Maybe try pltclu - you may use socket (TCP/IP) or to write data to OS
filesystem. I was doing in pltclu very similar things.
Write what you concrete watnts (in points), then I will try to write
you scripts.
Regards
Blazej
2008/10/3 Rob Richardson [EMAIL PROTECTED]:
That's how it should have
questions:
(1) Are you testing INSERT/UPDATE performance when is only one rule
script for all partition tables?
(2) Are you using SET constraint_exclusion = on;?
Regards,
Blazej
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
experts).
Regards,
Blazej
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
important fact is that
jython scripts may controlled Eclipse widgets (for example
ProgressBar).
Regards,
Blazej
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Maybe this will be helpfull:
http://www.postgresql.org/docs/8.3/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
Regards,
Blazej Oleszkiewicz
2008/9/4 Artacus [EMAIL PROTECTED]:
I'm writing some ETL procedures in pgplsql. After each insert/update/delete,
I'd like to log how
. (at this point, Data Warehouse deployment phase has
been finished).
Business Contact:
Wojciech Merchelski
e-mail: w.merchelski(at)teta(dot)com(dot)pl
www.teta.com.pl
For any questions regarding technical background of ASQL, please contact me:
Blazej Oleszkiewicz
e-mail: blajan(at)poczta
13 matches
Mail list logo