Thread: Tuning heuristics

From time to time people using PostgreSQL for the Smalltalk StORE
repository system are having performance problems.  There are some
common solutions such as suggesting they run vacuum analyze, or apply
the latest StORE schema tweaks.

I'm wondering if there is a document somewhere that describes how to
find performance bottlenecks from a PostgreSQL point of view, and what
to do about them.  A trouble shooting flowchart, with actions and
decision points would be great.

Does such a thing exist?

Thanks

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> I'm wondering if there is a document somewhere that describes how to
> find performance bottlenecks from a PostgreSQL point of view, and what
> to do about them.  A trouble shooting flowchart, with actions and
> decision points would be great.
> Does such a thing exist?

I am working on something very similar to this, but it is not quite ready 
for publication. If someone knows of similar things, please let me (and the 
list) know of course...

- --
Greg Sabino Mullane  greg@turnstep.com
PGP Key: 0x14964AC8 200304142245

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE+mzvOvJuQZxSWSsgRAq2EAKCipOv/D62LHVKCJguwRLtRXGoxzQCeKs1F
v/UR3GecmXkSq/b6vzyZtNY=
=glWX
-----END PGP SIGNATURE-----