On 1/14/2013 12:45 AM, John R Pierce wrote:
On 1/14/2013 12:15 AM, Condor wrote:
When I call the function from php everything it's seems to work,
but some time modify records just disappear. I don't have any ideas
for the moment
what is the problem in my postgresql or in my php code. I'm sure
there was a recording was made.
I run in middle night vacuum, reindex on tables and vacuum analyze; ...
oh, and vacuum is totally safe to be run concurrently with transactions,
the only negative impact is the performance impact of the additional IO
and CPU resources the VACUUM uses while active. Ditto REINDEX, it should
be safe, at most it will lock an index til that index is rebuilt..
with autovacuum, doing nightly vacuums and analyzes shouldn't be
neccessary...
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
