Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres performance comments from a MySQL user - Mailing list pgsql-general

From Kaarel
Subject Re: Postgres performance comments from a MySQL user
Date
Msg-id 3EEEE5F4.5020900@future.ee
Whole thread Raw
In response to Re: Postgres performance comments from a MySQL user  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Postgres performance comments from a MySQL user  (Paul Thomas <paul@tmsl.demon.co.uk>)
List pgsql-general
Tree view 
> can do the calculations in 10 msec.  The number that got my attention
> was 20 minutes.  I don't see where that could come from, given the same

The server was idle 20 minutes?

"Just now I had the server sit for approx 20 minutes, rerunning the same
query resulted in 3155 msec, a followup again 10.85 msec."

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Damn triggers and NEW
Next
From: Oleg Bartunov
Date:
Subject: Re: tsearch - v2 new dict