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
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 suppose the main problem is from database server settings.
No, the problem is your hard drive is too slow. One drive can only do mayb
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 750G
#x27;t
give details.
I suppose that I have to fragment my procedure to see exactly where i'm
wasting so much time.
regards
david
Greg Smith a écrit :
On Tue, 4 Mar 2008, dforums wrote:
max_connections = 256
shared_buffers = 1500 # min 16 or max_connections*
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
question, Could I optimise the treatment if I'm doing the select on
a view while updating the main table
regards
David
Erik Jones a écrit :
On Mar 4, 2008, at 6:54 PM, dforums wrote:
Hello,
After controling the settings I so, that shared_buffers is
configurated at 1024
Hello,
I need wo advice on vacuum settings.
I have a quad core X5355 @ 2.66GHz with 8 Go of memory
1Q) Why autovaccum does not work, I have set the value to on in
postgresql.conf but when the server start it's still off
2Q) Here are my settings for vacuum, could you help me to optimise
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
Result (cost=0.00..0.01 rows=1 width=0) (actual time=1.151..1.151
rows=1 loops=1)
Total runtime: 1.160 ms
(2 lignes)
Has you can see the runtime processs for an update in this table.
multiplying this per 1, it is too long.
regards
david
Richar
Hello
Regarding the advice from all, and the performance of postgresql 8.3.3
I'm trying to change the server and to upgrade to 8.3.3
I install postgresql 8.3.3 on a new server for testing. All well!!!
And I run a \i mybackup.sql since yesterday 7pm. This morning the datas
are not insert yet.
Houlala
I got headache !!!
So please help...;;
"Assuming they all happen from 9 to 5 and during business days only,
that's about 86 transactions per second. Well within the realm of a
single mirror set to keep up if you don't make your db work real fat."
OK i like, But my reality is t
t too ? Tx for helps
Regards
David
Scott Marlowe a écrit :
On Mon, Aug 11, 2008 at 8:26 AM, dforums <[EMAIL PROTECTED]> wrote:
Houlala
I got headache !!!
So please help...;;
"Assuming they all happen from 9 to 5 and during business days only,
that's about 86 tran
12 matches
Mail list logo