[PERFORM] Optimisation help

2008-03-04 Thread dforums
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

Re: [PERFORM] Optimisation help

2008-03-04 Thread dforums
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

Re: [PERFORM] Optimisation help

2008-03-04 Thread dforums
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

Re: [PERFORM] Optimisation help

2008-03-04 Thread dforums
#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*

Re: [PERFORM] Optimisation help

2008-03-04 Thread dforums
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

Re: [PERFORM] Optimisation help

2008-03-05 Thread dforums
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

[PERFORM] Vacuum settings

2008-04-20 Thread dforums
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

Re: [PERFORM] Plz Heeeelp! performance settings

2008-08-07 Thread dforums
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

Re: [PERFORM] Plz Heeeelp! performance settings

2008-08-07 Thread dforums
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

[PERFORM] Restoration of datas

2008-08-08 Thread dforums
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.

Re: [PERFORM] Distant mirroring

2008-08-11 Thread dforums
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

Re: [PERFORM] Distant mirroring

2008-08-12 Thread dforums
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