-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Mon, Feb 19, 2007 at 08:27:32PM +0000, Luigi Tarenga wrote: > > The following bug has been logged online: > > Bug reference: 3033 > Logged by: Luigi Tarenga > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.4 > Operating system: OpenBSD 4.0 amd64 > Description: performance issue with self join > Details: [...] > i'm used to run a query like this one on a 14 row table: [...] > and the first time it takes about 30 seconds on my pc. > the problem raise when i make lots of insert in the > same table and then delete new rows until i left the > original 14 [...] > forever (i waited more then 10 minutes).
You might want to vacuum the table at this point. This might restore performance. HTH - - tomás -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFF3qrIBcgs9XrR2kYRAiOvAJ9laDBqRQMU2oCoUuIgz1zkc/desQCfUI01 rRIkh97lE3c4hXhltXBjsxw= =nEPt -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
