Re: [GENERAL] In memory Database for postgres

2008-11-17 Thread Blazej
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

Re: [GENERAL] In memory Database for postgres

2008-11-17 Thread Blazej
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 m

Re: [GENERAL] citing postgresql

2008-11-17 Thread Blazej
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 Developm

Re: [GENERAL] In memory Database for postgres

2008-11-17 Thread Blazej
- I have no time to think about 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

Re: [GENERAL] Oracle and Postgresql

2008-11-09 Thread Blazej
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

Re: [GENERAL] Chart of Accounts

2008-11-09 Thread Blazej
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 acc

[GENERAL] Success implementation of the Analytic SQL Server and the SART AML system in bank.

2008-11-08 Thread Blazej
study. Regards, 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

Re: [GENERAL] How do I save data and then raise an exception?

2008-10-03 Thread Blazej
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

Re: [GENERAL] Oracle and Postgresql

2008-09-13 Thread Blazej
((( Oracle marketing is realy the best. 7. ? 8. As I say in 5. - pay for everything - if you are money everybady helps you (even I, and if you pay 1.000.000 $ I say Oracle is the best, like other Oracle 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

Re: [GENERAL] about partitioning

2008-09-13 Thread Blazej
8>< Very nice presentation. I have 2 additional 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 (

Re: [GENERAL] psql scripting tutorials

2008-09-12 Thread Blazej
ork and embeded python language (formaly jython) - very 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

Re: [GENERAL] Getting affected rows in pgplsql

2008-09-04 Thread Blazej
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, >

[GENERAL] Analytic SQL Server - next generation analytic Data Warehouse with OLAP support

2008-01-11 Thread Blazej Oleszkiewicz
. (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)p