Re: [GENERAL] Performance impact of hundreds of partitions

2010-04-21 Thread Rene Schickbauer
Leonardo F wrote: Is it mainly a planning problem or an execution time problem? I have here a database with a table partitioned across 400 sub-tables. I'm using a trigger-based solution with constraint exclusion. The thing that takes the longest is planning queries. I made THAT problem just

Re: [GENERAL] [NOVICE] Specific database vars, again...

2010-04-21 Thread Rene Schickbauer
Glus Xof wrote: Hi again, Maybe, I didn't explain my question enough. I need to record properties that belongs to an specific database (and so, they work at database level... not at global scope: * Could I use the \set statements ? but... the vars defined are not in a database scope but a glob

Re: [GENERAL] Virtual table with pl/perl?

2010-04-20 Thread Rene Schickbauer
Alvaro Herrera wrote: Rene Schickbauer escribió: Hi! I'm looking into implementing an updateable "virtual" table using pl/perl. What i basically want to do is read out/update some external resources. For programs using the SQL interface, this should look just like a regular ta

[GENERAL] Virtual table with pl/perl?

2010-04-19 Thread Rene Schickbauer
Hi! I'm looking into implementing an updateable "virtual" table using pl/perl. What i basically want to do is read out/update some external resources. For programs using the SQL interface, this should look just like a regular table except that it isn't ACID compliant (no rollbacks). I'm pret