Re: [PERFORM] Embedded VACUUM

2011-09-05 Thread Craig Ringer
On 3/09/2011 8:25 AM, C Pond wrote: I'm running a labour-intensive series of queries on a medium-sized dataset (~100,000 rows) with geometry objects and both gist and btree indices. The queries are embedded in plpgsql, and have multiple updates, inserts and deletes to the tables as well as mul

[PERFORM] Embedded VACUUM

2011-09-05 Thread C Pond
I'm running a labour-intensive series of queries on a medium-sized dataset (~100,000 rows) with geometry objects and both gist and btree indices. The queries are embedded in plpgsql, and have multiple updates, inserts and deletes to the tables as well as multiple selects which require the indice