| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Subject: | Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris |
| Date: | 2007-11-15 00:17:05 |
| Message-ID: | 18797.1195085825@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Jignesh K. Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM> writes:
> So from the PostgreSQL view things are doing fine based on outputs: I
> need to figure out the Solaris view on it now.
> Could it be related to autovacuum happening also?
Maybe ... have you tried fiddling with the vacuum_cost_delay options?
Looking at the autovacuum log output,
> 2007-11-13 09:21:19.830 PST 9458 LOG: automatic vacuum of table
> "specdb.public.txn_log_table": index scans: 1
> pages: 11 removed, 105 remain
> tuples: 3147 removed, 40 remain
> system usage: CPU 0.11s/0.09u sec elapsed 6.02 sec
it seems like a serious omission that this gives you no hint how many
pages were scanned.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jignesh K. Shah | 2007-11-15 01:33:39 | Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris |
| Previous Message | Kenneth Marshall | 2007-11-15 00:12:56 | Re: Hash index todo list item |