On Thu, May 26, 2005 at 02:50:44PM +0100, fremaux wrote:
PostgreSQL 7.2.2 is almost three years old -- consider upgrading
to 7.2.8, or better yet, 8.0.3.

Could you post the query results and the query's EXPLAIN ANALYZE
output? Do you have an index on group_artifact_id? If so, and if
EXPLAIN ANALYZE shows that the query uses the index, what happens
if you set enable_indexscan to off? What type is group_artifact_id?
How often do you vacuum, analyze, and/or reindex the table?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

[Please copy the mailing list on replies so others can participate
in and learn from the discussion.]

On Fri, May 27, 2005 at 10:08:20AM +0200, FREMAUX Benjamin SOFRECOM wrote:
A reindex might have provided an immediate fix, but it probably
didn't solve the problem; it might happen again. I don't know if
the problem still exists in later releases in the 7.2 branch, but
in any case I'd recommend using something newer than 7.2.2. A
number of bugs have been fixed since then; see the Release Notes
for details.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

This is a multi-part message in MIME format.
--------------090302020705060204060707
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Thank you

Michael Fuhr a écrit :


--------------090302020705060204060707
Content-Type: text/x-vcard; charset=utf-8;
name="benjamin.fremaux.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="benjamin.fremaux.vcf"

begin:vcard
fn:Benjamin FREMAUX
n:FREMAUX;Benjamin
email;internet:benjamin.fremaux (AT) sofrecom (DOT) com
tel;work:01-43-98-58-84
version:2.1
end:vcard


--------------090302020705060204060707
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

--------------090302020705060204060707--