Re: [PERFORM] Is there any other way to do this?

This time it worked! But VACUUM FULL requires an exclusive lock on the table which I don't really want to grant. So my question is: why is VACUUM ANALYZE didn't do the job? Is there any setting I can tweak to make a VACUUM without granting a exclusive lock? You need to run normal vacuum analyze

[PERFORM] Tuning planner cost estimates

I've been doing some work to try and identify the actual costs associated with an index scan with some limited sucess. What's been run so far can be seen at http://stats.distributed.net/~decibel. But there's a couple problems. First, I can't use the box exclusively for this testing, which results i

Re: [PERFORM] Is there any other way to do this?

On Tue, May 17, 2005 at 06:58:20PM -0400, Wei Weng wrote: > This time it worked! But VACUUM FULL requires an exclusive lock on the > table which I don't really want to grant. So my question is: why is VACUUM > ANALYZE didn't do the job? Is there any setting I can tweak to make a > VACUUM without

[PERFORM] Is there any other way to do this?

Hi, I have a small table that has only 23 rows, but I do frequent updates( every second ) on it. After running the updates for a while, the performance of SELECT from that table has deteriated into something like 30 seconds. So, natually, I did a VACUUM ANALYZE first. Here is the VERBOSE output

Re: [PERFORM] Trigger performance problem

---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [PERFORM] Trigger performance problem

"Manuel Wenger" <[EMAIL PROTECTED]> writes: > We're having a performance problem with PostgresQL 8.0.2 running on > RHEL3 Update 4. There is a frequently updated table logging all our ADSL > customer logins which has 2 related triggers. An INSERT on that table, > "calls", takes about 300ms to execu

[PERFORM] Trigger performance problem

We're having a performance problem with PostgresQL 8.0.2 running on RHEL3 Update 4. There is a frequently updated table logging all our ADSL customer logins which has 2 related triggers. An INSERT on that table, "calls", takes about 300ms to execute according to the logs, and the process takes up t

[PERFORM] [pgsql-benchmarks] Error when try installing pgbench ?

Hello … Im using source  postgresql 8.0.3 under FreeBSD and already install, the database is running well.   I want to install a pgbench, but I can’t install it, coz an error occur. I try to “make all” in directory ~/src/interfaces/lipq/ The messages are : . . . . . . . . . . "../../../src/Makef