Re: [PERFORM] Running PG on cluster files systems

Hi, On Tue, 2007-01-09 at 15:15 +0100, Hannes Dorbath wrote: > GFS2, OFCS2, lustre, CXFS, GPFS, Veritas and what else there is.. > > ..has someone experience with any of those? Is it bearable to run PG > on them from a performance point of view? I guess not, but any > positive reports? I have t

Re: [PERFORM] Killing long-running queries

Hi, On Tue, 2006-05-02 at 17:19 -0600, Dan Harris wrote: > Is there some way I can just kill a query and not risk breaking > everything else when I do it? Use pg_stat_activity view to find the pid of the process (pidproc column) and send the signal to that process. I think you are now killing po

Re: [PERFORM] memory allocation

ttp://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.sxw OR http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html > SHMAX = ? SHMMAX is not that relevant with PostgreSQL, it's rather relevant with your operating system. Regards, - -- Devrim GUNDU