Jeff Frost <[EMAIL PROTECTED]> writes:
> Got my oprofile man page reading done. Here's the general opreport:
> ...
> And the postgres one:
> samples %symbol name
> 3894022 12.6488 LWLockAcquire
> 3535497 11.4842 slot_deform_tuple
> 3030280 9.8431 LWLockRelease
> 2279699 7.4050 H
On Tue, 24 Apr 2007, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
Well, finally got this system upgraded to 8.1.8, but unfortunately, that did
not resolve this. Is there any reasonable way to see where this function is
spending it's time?
I've grown enamored of oprofile lately ---
fyi,
I upgraded the odbc driver on the client and every thing worked.
thanks
On May 3, 2007, at 1:45 PM, Warren Little wrote:
I'm getting the following error from a query being generated from
MS Access :
character 0xefbfbd of encoding "UTF8" has no equivalent in "LATIN9"
Upon reviewing the
I though it's my windows config (win2k pro English) problem.. anyway I
have trouble install pgSQL 8.2 in the typical way (msi).
The msi will last a while (looks like loading files) and then the UI disappears
before the welcome window. In my task manager, there are 3 msiexec.exe
processes shown wi
I'm getting the following error from a query being generated from MS
Access :
character 0xefbfbd of encoding "UTF8" has no equivalent in "LATIN9"
Upon reviewing the archives I found the following:
"Kevin McCarthy" writes:
> Often users will copy and paste text directly from MS Word docs
int
hello sir
i am new to postgresql community. i register two days before. and subscribe
in some supports . i recieved a mail from the community with my password.
but when i try to login in my profile. its not working. i clicked forgotten
password and gave my mail id for new password mai
On Thu, May 03, 2007 at 03:52:39PM +0200, Dawid Kuroczko wrote:
> There should already be a utility which could present all those
> marvels hidden in 'pg_stat%' tables, present them as nice graphs,
> highlight most used indexes, etc, etc.
>
> Maybe one of you is already using such a thing and can
Having done a series of
CREATE TEMP TABLE snap_user_idx AS SELECT * FROM pg_stat_user_indexes;
SELECT t1.indexrelname,t1.idx_scan-t0.idx_scan as idx_scan,
t1.idx_tup_read-t0.idx_tup_read AS idx_tup_read,
t1.idx_tup_fetch-t0.idx_tup_fetch as idx_tup_fetch
FROM pg_stat_user_indexes t1 JOIN snap_u
the problem was not the long running statement. that statement has
blocked other connections and i was unable to drop that connection. at
the end all connections where blocked (output in ps: UPDATE waiting ..).
the only solution was to restart the server. After my understanding I
can terminate
Thomas Markus wrote:
> thanks for your awnsers
>
> i cant repeat the problem after increasing autovacuum_naptime to 5min. a
> vacuumdb -f -a runs over night (and finished :) ) and now that blocking
> statement finished after some seconds. it seems autovacuum = on is not
> enough.
Enough for wh
10 matches
Mail list logo
