[PERFORM] Poor delete performance AFTER vacuum analyze

is a dual P4 2.4ghz Xeon w/ 1.5 gig of RAM. IBM 335 w/ 36gig mirrored. kernel.shmmax = 1342177280 shared_buffers = 115200# 2*max_connections, min 16 sort_mem = 65536 # min 32 vacuum_mem = 196608 # min 1024 fsync = false - -- Jeremy M. Guthrie Systems Engineer Berbee

Re: [PERFORM] Poor delete performance AFTER vacuum analyze

loops=1) Index Cond: (host = 'tbp-pp'::character varying) Filter: (tlog_id = 47766002) Total runtime: 262178.96 msec - -- Jeremy M. Guthrie Systems Engineer Berbee 5520 Research Park Dr. Madison, WI 53711 Phone: 608-298-1061 Berbee...Decade 1. 1993-2003 -BEGIN PGP SIGNATURE

[PERFORM] free space map usage

appear to be working. shared_buffers = 29400# 2*max_connections, min 16 max_fsm_relations = 1000# min 10, fsm is free space map max_fsm_pages = 1000 # min 1000, fsm is free space map - -- Jeremy M. Guthrie Systems Engineer Berbee 5520 Research Park Dr. Madison, WI 53711

Re: [PERFORM] free space map usage

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 14 October 2003 02:16 pm, Tom Lane wrote: Jeremy M. Guthrie [EMAIL PROTECTED] writes: Is there any way to determine how much of the free space map is currently i= n=20 use?(ie. where and what it is tracking?) I vacuum on a regular

Re: [PERFORM] Postgres 7.3.4 + Slackware 9.1

)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html - -- Jeremy M. Guthrie Systems Engineer Berbee 5520 Research Park Dr. Madison, WI 53711 Phone: 608-298-1061 Berbee...Decade 1. 1993-2003 -BEGIN PGP SIGNATURE- Version: GnuPG

[PERFORM] Question about space usage:

print. Is there something I am missing? - -- Jeremy M. Guthrie Systems Engineer Berbee 5520 Research Park Dr. Madison, WI 53711 Phone: 608-298-1061 Berbee...Decade 1. 1993-2003 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux