where tsyslog_id=431650835;
QUERY PLAN
- -
Seq Scan on tsyslog (cost=1.00..10058.20 rows=2 width=187)
Filter: (tsyslog_id = 431650835)
(2 rows)
- --
- --
Jeremy M. Guthrie[EMAI
.
- --
- --
Jeremy M. Guthrie[EMAIL PROTECTED]
Network Engineer Phone: 608-298-1061
Berbee Fax: 608-288-3007
5520 Research Park Drive NOC: 608-298-1102
Madison, WI 53711
-BEGIN PGP SIGNATURE-
Version
would result in a larger foot 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-
Ve
HANKS ALL.
>
>
> ---(end of broadcast)---
> 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 537
-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 a
x27;t 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
128.52 rows=82 width=6)
(actual time=262178.82..262178.82 rows=0 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 5371
ng?
The Box:
The DB 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. Guthri
