Hello
2012/1/30 Carlo Stonebanks :
> Pavel, are you saying that the code of the stored function is actually being
> added to the SQL query, instead of a call to it? For example, I have seen
> this:
>
> SELECT myVar
> FROM myTable
> WHERE myVar > 0 AND myFunc(myVar)
>
> And seen the SQL body of myV
Op 30-01-12 02:52, Jose Ildefonso Camargo Tolosa schreef:
> On Sun, Jan 29, 2012 at 6:18 PM, Ron Arts wrote:
>> Hi list,
>>
>> I am running PostgreSQL 8.1 (CentOS 5.7) on a VM on a single XCP (Xenserver)
>> host.
>> This is a HP server with 8GB, Dual Quad Core, and 2 SATA in RAID-1.
>>
>> The pro
On Sun, Jan 29, 2012 at 6:18 PM, Ron Arts wrote:
> Hi list,
>
> I am running PostgreSQL 8.1 (CentOS 5.7) on a VM on a single XCP (Xenserver)
> host.
> This is a HP server with 8GB, Dual Quad Core, and 2 SATA in RAID-1.
>
> The problem is: it's running very slow compared to running it on bare meta
Pavel, are you saying that the code of the stored function is actually being
added to the SQL query, instead of a call to it? For example, I have seen
this:
SELECT myVar
FROM myTable
WHERE myVar > 0 AND myFunc(myVar)
And seen the SQL body of myVar appended to the outer query:
... Filter: SELECT
On Sun, Jan 29, 2012 at 7:48 PM, Ron Arts wrote:
> Hi list,
>
> I am running PostgreSQL 8.1 (CentOS 5.7) on a VM on a single XCP (Xenserver)
> host.
> This is a HP server with 8GB, Dual Quad Core, and 2 SATA in RAID-1.
>
> The problem is: it's running very slow compared to running it on bare meta
Hi list,
I am running PostgreSQL 8.1 (CentOS 5.7) on a VM on a single XCP (Xenserver)
host.
This is a HP server with 8GB, Dual Quad Core, and 2 SATA in RAID-1.
The problem is: it's running very slow compared to running it on bare metal, and
the VM is starving for I/O bandwidht, so other processe
Greetings,
On Sat, Jan 28, 2012 at 12:51 PM, Jayashankar K B
wrote:
> Hi,
>
> I downloaded the source code and cross compiled it into a relocatable package
> and copied it to the device.
> LTIB was the cross-compile tool chain that was used. Controller is coldfire
> MCF54418 CPU.
> Here is the
