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
Hello
We hace a Quad Xeon server, with 8GO of ram, sata II 750Go
An postgresql database, of 10 Go
I have several treatment every 2 minutes who select, insert, update
thousand of data in a table. It take a lot of time (0.3300 ms per line)
just to check if a string of 15 char is present, and
10 matches
Mail list logo
