-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 02/08/07 20:50, Arturo Perez wrote:
> Hi all,
>
> Saturday I changed a table to add a varchar(24) and a TEXT column. It's
> used for some reporting purposes (small potatoe stuff really) and the
> TEXT column remains mostly empty. However, this week performance has
> gotten terrible. Queries joining against the aforementioned table have
> gone from 40s to 1500s. The schema change is the only explanation I
> have for the 30x slower queries. The queries have definitely gotten
> disk-bound (I can see the connection process sitting in the D state for
> several minutes).
>
> This is pg8.1.4 on Linux RedHat. Would adding a TEXT column impact
> things that much? The change to the schema was
>
> alter table foo add column title text;
Could the issue be record fragmentation? Does PG even suffer from
record fragmentation?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFFy/YRS9HxQb37XmcRAlM3AKCmcuEQR0OBrNrs6vtdfrxtMgmswgCggVKS
d8W9YEzDUmCfT53jorbCq9w=
=xpiF
-----END PGP SIGNATURE-----