e script timeout for each statement in
my maintenance scripts using a temporary table to store the deadline.
Kind Regards
Federico
On 17 September 2013 17:23, Roberto Grandi wrote:
>
> Dear all,
>
> i would set a script timeout from a .net application. My problem regards
> how to make sur
from
the manual then transfer the archived segments in a second time using a
more reliable system like rsync.
Cheers
Federico
On 26 April 2013 14:06, German Becker wrote:
> Here is the archive part of the config:
>
> archive_mode = on # allows archiving t
and t_cmax stores the insert and delete CID stamps.
the CID (command that operate on item id?) is similar to XID? where I
can find some docs about CID and its meaning?
Thank you very much in advance.
Regards
Federico
--
Federico Campoli is:
@ PGDay -> Committee, http://www.pgday.it
@ PLUG -> C
0..2896.42 rows=33242 width=64) (actual
time=77.027..791.014 rows=37093 loops=1)"
-
rows=37093 is all of the existing rows of table testcase!
(why does it say "never executed"?)
Hi,
a full index scan is even more expensive than a sequential scan.
So the que
in the permissions. The customer could restart the PostgreSQL
service manually, without resorting to a backup.
Could this be the result of not enough check_point segments?
SNIP!
Your log is full of "Permission denied" statements.
I suggest you to check the permissions on your data directory.
On 1/16/07, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
On Mon, Jan 15, 2007 at 18:24:19 +0100,
Federico <[EMAIL PROTECTED]> wrote:
> Hi,
> after some test i got that my performance problem described in the
> message http://archives.postgresql.org/pgsql-admin/2007-01/msg001
nsive scsi raid hardware so i need to
have raid software.
Thanks in advance
Best Regards
Federico Campoli
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
The same test on my production machine (debian sarge 3.1, postgresql
8.1.6 from source) don't have problem.
What can be the cause of this crazy behaviour?
Best Regards
Federico Campoli
---(end of broadcast)---
TIP 3: Have you checked our extensive
ase
cluster directory
preserving user and permissions to the new location, update the
$PGDATA variable for the user postgres with the value of the new
location , startup the postmaster, enjoy ;)
Best Regards and Merry Christmas
Federico Campoli
---(end o
e delay to have effect on the DBMS.
Please help me.
Federico
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
The link for the Beta 2 Windows version of 8.0 is not
working. How do I download it?
Question: is this a real windows version? Not cygwin?
Federico
11 matches
Mail list logo