Re: [PERFORM] rotate records

On Tue, Feb 28, 2006 at 09:14:59 +0530, "Jeevanandam, Kathirvel (IE10)" <[EMAIL PROTECTED]> wrote: > Hi all, Please don't hijack existing threads to start new ones. This can cause people to miss your question and messes up the archives. Performance questions should generally be posted to the pe

Re: [PERFORM] wal sync method

Use whichever sync method is fastest for you. They are all reliable, except turning fsync off. --- Javier Somoza wrote: > > > > Hi Evgeny > > Im also testing what fsync method to use and using this progr

Re: [PERFORM] fsync and battery-backed caches

Jim C. Nasby wrote: > On Mon, Feb 27, 2006 at 11:12:57AM +0100, Tino Wildenhain wrote: > > Javier Somoza schrieb: > > > > > >Hi all > > > > > >Is it secure to disable fsync havin battery-backed disk cache? > > > > > >Thx > > > > > No. fsync moves the data from

Re: [PERFORM] fsync and battery-backed caches

On Mon, Feb 27, 2006 at 11:12:57AM +0100, Tino Wildenhain wrote: > Javier Somoza schrieb: > > > >Hi all > > > >Is it secure to disable fsync havin battery-backed disk cache? > > > >Thx > > > No. fsync moves the data from OS memory cache to disk-adaptor > cache

Re: [PERFORM] Large Table With Only a Few Rows

On 27/02/06, Chris Browne <[EMAIL PROTECTED]> wrote: "Nik" <[EMAIL PROTECTED]> writes:> I have a table that has only a few records in it at the time, and they> get deleted every few seconds and new records are inserted. Table never > has more than 5-10 records in it.>> However, I noticed a deterior

Re: [PERFORM] The trigger can be specified to fire on time condition?

[EMAIL PROTECTED] (Jamal Ghaffour) writes: > Hi All, I ' m using the postgresql datbase to stores cookies. Theses > cookies become invalid after 30 mn and have to be deleted. i have > defined a procedure that will delete all invalid cookies, but i > don't know how to call it in loop way (for exampl

Re: [PERFORM] Large Table With Only a Few Rows

"Nik" <[EMAIL PROTECTED]> writes: > I have a table that has only a few records in it at the time, and they > get deleted every few seconds and new records are inserted. Table never > has more than 5-10 records in it. > > However, I noticed a deteriorating performance in deletes and inserts > on it.

Re: [PERFORM] The trigger can be specified to fire on time condition?

Jamal Ghaffour wrote: > Hi All, > I ' m using the postgresql datbase to stores cookies. Theses cookies > become invalid after 30 mn and have to be deleted. i have defined a > procedure that will > delete all invalid cookies, but i don't know how to call it in loop way > (for example each hour).

[PERFORM] The trigger can be specified to fire on time condition?

Hi All, I ' m using the postgresql datbase to stores cookies. Theses cookies become invalid after 30 mn and have to be deleted. i have defined a procedure that will delete all invalid cookies, but i don't know how to call it in loop way (for example each hour). I think that it possible becau

Re: [PERFORM] neverending vacuum

> So one very effective way of speeding this process up is giving the > vacuum process lots of memory, because it will have to do fewer passes > at each index. How much do you have? OK, this is my problem... it is left at default (16 megabyte ?). This must be a mistake in configuration, on other

Re: [PERFORM] neverending vacuum

Csaba Nagy wrote: > I have a quite big table (about 200 million records, and ~2-3 million > updates/~1 million inserts/few thousand deletes per day). I started a > vacuum on it on friday evening, and it still runs now (monday > afternoon). I used "vacuum verbose", and the output looks like: > > [

[PERFORM] neverending vacuum

Hi all, Short story: I have a quite big table (about 200 million records, and ~2-3 million updates/~1 million inserts/few thousand deletes per day). I started a vacuum on it on friday evening, and it still runs now (monday afternoon). I used "vacuum verbose", and the output looks like: INFO: va

Re: [PERFORM] Setting the shared buffers

    How should i set this configuration? Depending on the memory?     And then is it necessary to perform a benchmarking test?I've set it to 'shared_buffers = 12288' with 8 GB RAM on postgresql 7.4.9, FreeBSD 6.0. There is no exact size, depends on type of workload, server-OS etc. A

[PERFORM] Setting the shared buffers

    Hi,     How should i set this configuration? Depending on the memory?     And then is it necessary to perform a benchmarking test?     What did you do?     Thx!     Javier Somoza Oficina de Dirección Estratégica mailto:[EMAIL PROTECT

Re: [PERFORM] wal sync method

    Hi Evgeny     Im also testing what fsync method to use and using this program (http://archives.postgresql.org/pgsql-performance/2003-12/msg00191.php)     a bit modified and i get this results:     write  0.36     write & f

[PERFORM] wal sync method

Hi everybody! Which wal sync method is the fastest under linux 2.6.x? I'm using RAID-10 (JFS filesystem), 2xXEON, 4 Gb RAM. I've tried to switch to open_sync which seems to work faster than default fdatasync, but is it crash-safe? -- Evgeny Gridasov Software Engineer I-Free, Russia -

Re: [PERFORM] fsync and battery-backed caches

Javier Somoza schrieb: Hi all Is it secure to disable fsync havin battery-backed disk cache? Thx No. fsync moves the data from OS memory cache to disk-adaptor cache which is required to benefit from battery backup. If this data is written to the plate

[PERFORM] fsync and battery-backed caches

    Hi all     Is it secure to disable fsync havin battery-backed disk cache?         Thx Javier Somoza Oficina de Dirección Estratégica mailto:[EMAIL PROTECTED] Panda Software Buenos Aires, 12 48001 BILBAO - ESPAÑA Teléfono: 902 24 365 4 Fax:  94 424 46 97 http