Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance problem with a table with 38928077 record - Mailing list pgsql-performance

From Gregg Jaskiewicz
Subject Re: Performance problem with a table with 38928077 record
Date
Msg-id CAJY59_h6DoTG0MpSwLbhBR1uWECUBV0cdfgrA6-xF383rQ-Pew@mail.gmail.com
Whole thread Raw
In response to Re: Performance problem with a table with 38928077 record  (Guillaume Cottenceau <gc@mnc.ch>)
List pgsql-performance
Tree view 
Do you need left join ?
Can you further normalize the tables? (to lower the I/O)
Can you upgrade to at least 8.3 ? It has huuge performance
improvements over 8.3.

pgsql-performance by date:

Previous
From: Guillaume Cottenceau
Date:
Subject: Re: Performance problem with a table with 38928077 record
Next
From: Cédric Villemain
Date:
Subject: Re: Performance problem with a table with 38928077 record