Actually now I already work to upgrade Postgresql version to 8.1 but not
yet finish.
Yesterday I did re-create the affected tables indices, it does improve the
performance but still need 2-5 mins to execute the query.
Is this 'normal' for a table with 40K rows of records?
Anyway thanks for yo
On Mon, May 08, 2006 at 11:21:16AM +0200, Markus Schaber wrote:
> Hi, Kah,
>
> [EMAIL PROTECTED] wrote:
>
> > I already vacuum those tables with full option but it still the same.
> >
> > What could be the possible causes of this problem?
> > How can I solve it?
> >
> > CPU - Intel Xeon 2.40 GH
Hi, Kah,
[EMAIL PROTECTED] wrote:
> I already vacuum those tables with full option but it still the same.
>
> What could be the possible causes of this problem?
> How can I solve it?
>
> CPU - Intel Xeon 2.40 GHz
> Memory - 1.5G
> Postgresql version: 7.2.2
First, you should consider to upgrade
I'm facing a very weird problem.
Recently our database run very slow when execute Delete/Select statement
for a few tables only..
The largest table only have 50K rows of data.
When I run the statement from pgAdmin although it is slow but not as slow
as run from webapp.
When I run the statement
