I see that dblink is 2500 lines more or less...
Is there anyone how to set up correctly the 2 lines I posted before?
I will explore SPI anyway hoping it will gett my life easier...
On Thu, Feb 17, 2011 at 4:16 AM, Alessandro Candini wrote:
I'm dealing witch a C function embedded
perform a query indide the db without involve libpq?
I would prefer to use them because I can connect to several postgresql
instances.
Thank you.
--
Alessandro Candini
MEEO S.r.l.
Via Saragat 9
I-44122 Ferrara, Italy
Tel: +39 0532 1861501
Fax: +39 0532 1861637
http://www.meeo.it
==
Il 15/02/2011 19:32, Alban Hertroys ha scritto:
On 15 Feb 2011, at 9:32, Alessandro Candini wrote:
Is that a single query on that one DB compared to 4 queries on 4 DB's? How does
a single DB with 4 parallel queries perform? I'd expect that to win from 4
DB's, due to the overh
Il 14/02/2011 21:00, Allan Kamau ha scritto:
On Mon, Feb 14, 2011 at 10:38 AM, Alessandro Candini wrote:
No, this database is on a single machine, but a very powerful one.
Processors with 16 cores each and ssd disks.
I already use partitioning and tablespaces for every instance of my db and I
On 14 Feb 2011, at 9:38, Alessandro Candini wrote:
I performed tests with a query returning more or less 10 records and using
my C module I obtain the following results (every test performed cleaning cache
before):
- single db: 9.555 sec
- splitted in 4: 5.496 sec
Is that a single
table);"
I know that this seems stupid, but please answer me only if you know how
to do this...
Thanks in advance.
--
Alessandro Candini
MEEO S.r.l.
Via Saragat 9
I-44122 Ferrara, Italy
Tel: +39 0532 1861501
Fax: +39 0532 1861637
http://w
my thoughts, I don't consider myself an expert on the subject matter.
Mark
--
Alessandro Candini
MEEO S.r.l.
Via Saragat 9
I-44122 Ferrara, Italy
Tel: +39 0532 1861501
Fax: +39 0532 1861637
http://www.meeo.it
"ATTENZIONE:le informazioni
han a C
function...
Thank you!
On 10 Feb 2011, at 9:01, Alessandro Candini wrote:
I have installed 4 different instances of postgresql-9.0.2 on the same machine,
on ports 5433, 5434, 5435, 5436.
I do hope you intend to put those databases on different machines eventually,
or some
accomplish my goal.
Have you got any ideas or suggestions?
Thanks a lot!
--
Alessandro Candini
MEEO S.r.l.
Via Saragat 9
I-44122 Ferrara, Italy
Tel: +39 0532 1861501
Fax: +39 0532 1861637
http://www.meeo.it
"ATTENZIONE:le informazioni contenute in q
