OK I found the cause, it was a default settings added on server start.
(-B 1024) Gr!
Now it works really better I devide the full time per 2.
I suppose I steal have to look deep in the procedure to see some hack,
has somebody suggest, I will try to buffer all updates in one.
One
On Mar 4, 2008, at 6:54 PM, dforums wrote:
Hello,
After controling the settings I so, that shared_buffers is
configurated at 1024 (the default), however, in my postgresql.conf I
set it to 25, is it due to shared memory settings, should I
increase shmmax?
Did you do a full restart o
On Wed, Mar 05, 2008 at 12:15:25AM +, dforums wrote:
> In regards of update, I have around 1 updates while a laps of 10 minutes
>
> Is there a settings to optimise updates ?
If you can, batch them into a single transaction.
If you can, upgrade to 8.3. HOT might help you here.
/* Steinar
Hello,
After controling the settings I so, that shared_buffers is configurated
at 1024 (the default), however, in my postgresql.conf I set it to
25, is it due to shared memory settings, should I increase shmmax?
regards
david
Greg Smith a écrit :
On Tue, 4 Mar 2008, dforums wrote:
ma
Thanks i'm trying with this new settings. I gain only 3 second (2:40 vs
2:37 min) on a treatment of 1000 lines, with it's done every 2 minutes.
For the database version, i'm under postgresql 8.1.11. x64
As i'm in a procedure it seems that postgresql explain analyse doesn't
give details.
I s
On Tue, 4 Mar 2008, dforums wrote:
max_connections = 256
shared_buffers = 1500 # min 16 or max_connections*2, 8KB each
work_mem = 22000# min 64, size in KB
effective_cache_size = 2048 # typically 8KB each
Well, you're giving the main databa
In regards of update, I have around 1 updates while a laps of 10 minutes
Is there a settings to optimise updates ?
regards
david
Alan Hodgson a écrit :
On Tuesday 04 March 2008, dforums <[EMAIL PROTECTED]> wrote:
Hello
We hace a Quad Xeon server, with 8GO of ram, sata II 750Go
I s
tX for your reply,
I do not have more information on disk speed. I'll get it latter.
But My most fear is that for now the database is only of 10 Go.
But I will have to increase it 10 times during the next six month I'm
afraid that these problems will increase.
Regards
David
Alan Hodgson a
On Tuesday 04 March 2008, dforums <[EMAIL PROTECTED]> wrote:
> Hello
>
>
> We hace a Quad Xeon server, with 8GO of ram, sata II 750Go
>
>
> I suppose the main problem is from database server settings.
No, the problem is your hard drive is too slow. One drive can only do maybe
150 seeks per sec
