Re: [GENERAL] BI tools and postgresql

2012-07-29 Thread Jacqui Caren
On 29/07/2012 10:56, Vincent Veyron wrote: New manager comes in and starts talking about a bidding procedure for an application for the combined team. Hmm - I wonder... All sorts of perks/backhanders for some types of management when this is undertaken. I suspect this is an attempt to either ge

Re: [GENERAL] BI tools and postgresql

2012-07-27 Thread Jacqui Caren
On 26/07/2012 15:04, Vincent Veyron wrote: The money spent in licences alone would pay for scores of developpers to produce any kind of reporting you will need many times over (the data and its structure is what counts, reporting is easy if you have that) I disagree that licences will cover rep

Re: [GENERAL] stored proc

2011-09-29 Thread Jacqui Caren-home
On 29/09/2011 02:34, J.V. wrote: Is it possible to group a bunch of methods and functions into a single file (stored procedures & functions) and have a main method that can be called to orchestrate the methods, pass in params, get back results, log to a file? I know this can be done with Oracle

Re: [GENERAL] Oracle to Postgres migration open source tool

2011-07-07 Thread Jacqui Caren-home
On 07/07/2011 15:21, salah jubeh wrote: > > Hello, > > I do no have any experience with oracle, try to dump the oracle database in plain format and then try to execute the DDL and DML statements. It might be cumbersome to fix all the errors you might get. > But as an initial solution give it a s

Re: [GENERAL] Understanding Schema's

2010-12-15 Thread Jacqui Caren-home
On 15/12/2010 00:20, Carlos Mennens wrote: Why would anyone in a random scenario want to have independent schema's to cross query? I'm just trying to see how this would be useful in any scenario. One very real example :-) When migrating from say mysql to PgSQL it is possible to populate a "myg

Re: [GENERAL] Re: Modfying source code to read tuples before and after UPDATE...how to?

2010-11-06 Thread Jacqui Caren-home
rmd22 wrote: Do you think it's possible? replied offlist suggesting he have a chat with his prof and find the reason behind this task... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] create table as select VS create table; insert as select

2010-10-29 Thread Jacqui Caren-home
I have inherited an application that populates a number of temp.y tables using create table ... as select ... This is taking roughly five to ten minutes to run As this process hammers the database, I can only run benchmarks at night so am asking here if anyone know if create table ...; then ins

[GENERAL] SPI high level abstraction?

2010-10-04 Thread Jacqui Caren-home
Is there any C libs out there that will abstract the SPI interface? I have a number of functions that do input process output and they are all almost identical (tablename fields, change) I could abstract the code but would prefer to re-use an exissting abstraction layer as the less code I write

Re: [GENERAL] pgtune

2010-08-11 Thread Jacqui Caren-home
Greg Smith wrote: Set "-c 300" when you run pgtune and it will do the right thing here. regarding tuning a database we had a rather neat tool for oracle some years ago that would connect to a live database and monitor the QEP (query execution plan) cache for badly indexed queries etc. It would

Re: [GENERAL] MySQL versus Postgres

2010-08-10 Thread Jacqui Caren-home
Randal L. Schwartz wrote: Do not overemphasize the example mode at the cost of presenting concepts or structure. You need all three. Hmm I recently had to find out the various options to get values from a tuple via SPI - referred by docs to the contrib examples :-( Docs did not help and the ex

Re: [GENERAL] How Big is Too Big for Tables?

2010-07-29 Thread Jacqui Caren-home
P Kishor wrote: On Wed, Jul 28, 2010 at 1:38 PM, Stephen Frost wrote: * P Kishor (punk.k...@gmail.com) wrote: Three. At least, in my case, the overhead is too much. My data are single bytes, but the smallest data type in Pg is smallint (2 bytes). That, plus the per row overhead adds to a fair

Re: [GENERAL] Migrating from MySQL

2010-06-29 Thread Jacqui Caren-home
John R Pierce wrote: On 06/26/10 11:22 PM, RP Khare wrote: I downloaded PostgreSQL plus advanced server from EnterpriseDB website. Should I go with the original community PGSQL edition or EnterpriseDB edition? thats entirely up to your preferences and needs.Personally, I think that the s

[GENERAL] subscribe

2010-05-28 Thread Jacqui Caren-home
subscribe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general