Re: [ADMIN] Script timeout

2013-09-17 Thread Federico
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

Re: [ADMIN] archive falling behind

2013-04-26 Thread Federico
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

[ADMIN] Question about HeapTupleHeaderData

2007-05-24 Thread Federico
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

Re: [ADMIN] PG does not use my index

2007-04-02 Thread Federico
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

Re: [ADMIN] PostgreSQL crashes on Windows 2003

2007-03-12 Thread Federico
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.

Re: [ADMIN] PostgreSQL data dir on linux raid software

2007-01-16 Thread Federico
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

[ADMIN] PostgreSQL data dir on linux raid software

2007-01-15 Thread Federico
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

[ADMIN] postgresql and apache slow down

2007-01-15 Thread Federico
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

Re: [ADMIN] Very Very Slow Database Restore

2006-12-22 Thread Federico
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

[ADMIN] Trouble with phpbb installation

2006-05-01 Thread Federico Campoli
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

[ADMIN] The link for the Beta 2 Windows version of 8.0 is not working

2004-09-20 Thread Federico Alves
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