From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Mitch Vincent" <mitch(at)huntsvilleal(dot)com> |
Cc: | "Hannu Krosing" <hannu(at)tm(dot)ee>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Why Not MySQL? |
Date: | 2000-05-03 15:28:51 |
Message-ID: | 7718.957367731@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"Mitch Vincent" <mitch(at)huntsvilleal(dot)com> writes:
>> Could you be a little more specific on your performance issues ?
> Well, I'm just noticing that simple select queries are taking 3-5 seconds -
> on a table with 63 fields, 10000ish rows of data. The ID fields are
> indexed, as well as several always-searched varchar() fields.
Hmm. What does EXPLAIN show for the query plan? You might also try
turning on execution stats (run psql with PGOPTIONS="-d2 -s" for
starters) to see what getrusage() can tell. The results will be in the
postmaster log and might look like this:
StartTransactionCommand
query: SELECT usename, relname, relkind, relhasrules FROM pg_class, pg_user WHERE usesysid = relowner and ( relkind = 'r' OR relkind = 'i' OR relkind = 'S') and relname !~ '^pg_' and (relkind != 'i' OR relname !~ '^xinx') ORDER BY relname
ProcessQuery
! system usage stats:
! 0.083256 elapsed 0.040000 user 0.000000 system sec
! [0.080000 user 0.020000 sys total]
! 12/1 [46/11] filesystem blocks in/out
! 0/0 [1/2] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [2/2] messages rcvd/sent
! 8/5 [29/10] voluntary/involuntary context switches
! postgres usage stats:
! Shared blocks: 18 read, 0 written, buffer hit rate = 94.29%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
CommitTransactionCommand
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2000-05-03 15:29:31 | Re: Why Not MySQL? |
Previous Message | Mitch Vincent | 2000-05-03 15:25:42 | Re: Why Not MySQL? |