What version of postgres?
8.0.2 ... but I think I've seen this before on 7.3 ...
There are a few possibilities. If you are having a lot of updates to the
table, you can get index bloat. And vacuum doesn't fix indexes. You have
to REINDEX to do that. Though REINDEX has the same lock that
Hello everyone,First time poster to the
mailing list here.
We have been running pgsql for about a year now at
a pretty basic level (I guess) as a backend for custom
web(intranet)applicationsoftware. Our database so far is a
"huge" (note sarcasm) 10 Mb containing of about 6 or so principle
,
Dave
[EMAIL PROTECTED]
- Original Message -
From: Andrei Reinus [EMAIL PROTECTED]
To: SpaceBallOne [EMAIL PROTECTED]
Cc: pgsql-performance@postgresql.org
Sent: Monday, January 24, 2005 5:22 PM
Subject: Re: [PERFORM] poor performance of db?
SpaceBallOne wrote:
Hello everyone,
First time
index themselves. I didn't do a vacuum analyse on them so that may explain
why they didn't seem to do much.
Thanks,
Dave
[EMAIL PROTECTED]
- Original Message -
From: John Arbash Meinel [EMAIL PROTECTED]
To: SpaceBallOne [EMAIL PROTECTED]
Sent: Tuesday, January 25, 2005 9:56 AM
Subject: Re