Re: Re(2): Re(2): [ADMIN] db server is too slow, real slow

On Fri, 20 Oct 2000, pgsql-admin wrote: > however i got one problem (see below)... but when i started the psql > monitor again, > it did not appear. i'm worried that it would happen again. > > applieddata=> SELECT COUNT(*) FROM office, office_application > applieddata-> WHERE office.code = offi

RE: [ADMIN] Automation/scheduling of Backup stratetgy

Title: RE: [ADMIN] Automation/scheduling of Backup stratetgy You mean WAL.  When your server goes down, you can restore from the last backup, and then reapply the WAL to recreate all transactions that were in committed between the backup and the crash.  WAL is due for 7.1, I believe. Cheers..

Re(2): Re(2): [ADMIN] db server is too slow, real slow

[EMAIL PROTECTED] writes: >On Fri, 20 Oct 2000, pgsql-admin wrote: > >> The postgres server was started with the command: >> /usr/bin/postmaster -i -S -D/var/lib/pgsql > >Have you tried changing the values of -B to see if increasing the >number of buffers helps? tried it already. i start postmast