dforums wrote:
> The delete is global, the procedure is called for each line/tracks.
> > So - are you calling this function 14000 times to inject your data?
> > You're doing this in one transaction, yes?
> NO I have to make it 14000 times cause, I use some inserted information
> for other insert
On Thu, Aug 7, 2008 at 9:30 AM, dforums <[EMAIL PROTECTED]> wrote:
> The performance problem is really only on the insertion and even more on the
> treatment for the aggregation.
>
> To treat the 3000 entrances and to insert, or update the tables it needs 10
> minutes.
>
> As I told you I inject 14
dforums wrote:
The performance problem is really only on the insertion and even more on
the treatment for the aggregation.
To treat the 3000 entrances and to insert, or update the tables it needs
10 minutes.
As I told you I inject 14000 query every 2 minutes, and it needs 10
minutes to trea
The performance problem is really only on the insertion and even more on
the treatment for the aggregation.
To treat the 3000 entrances and to insert, or update the tables it needs
10 minutes.
As I told you I inject 14000 query every 2 minutes, and it needs 10
minutes to treat 3000 of those
dforums wrote:
vmstat is giving :
procs ---memory-- ---swap-- -io --system--
cpu
r b swpd free buff cache si sobibo incs us sy
id wa
0 2 1540 47388 41684 757897600 131 2590 1 9
3 82 7
This system is pract
Richard Huxton a écrit :
> dforum wrote:
>> Tx for your reply.
>>
>> You mean that RAID use fsync method for keeping data's copy.
>
> No, Merlin means PostgreSQL will issue a sync to force WAL to actual
disk.
>
>> So you invite me to desactivate fsync to increase the performance ?
>
> He means
dforum wrote:
Tx for your reply.
You mean that RAID use fsync method for keeping data's copy.
No, Merlin means PostgreSQL will issue a sync to force WAL to actual disk.
So you invite me to desactivate fsync to increase the performance ?
He means you might have to if you can't afford new ha
Tx for your reply.
You mean that RAID use fsync method for keeping data's copy.
So you invite me to desactivate fsync to increase the performance ?
Desactivating fsync. my second disk will not be uptodate, so if the
machine crash, I wont be able to get the server working quickly??? But
if I u
On Wed, Aug 6, 2008 at 6:12 PM, dforum <[EMAIL PROTECTED]> wrote:
> Hello to all,
>
>
> I have a Linux 2.6.24.2--std-ipv4-64 #3 SMP Tue Feb 12 12:27:47 CET 2008
> x86_64 Intel(R) Xeon(R) CPU X5355 @ 2.66GHz GenuineIntel GNU/Linux
> with 8Gb of memory. Using sata II disk in RAID 1 (I known that
