[PERFORM] adding foreign key constraint locks up table

I have a table "aaa" which is not very big. It has less than 10'000 rows. However read operations on this table is very frequent. Whenever I try to create a new table "bbb" with foreign key pointing to "aaa". The operation locks, and reading "aaa" is not possible. The query also never seems to fin

Re: [PERFORM] How to turn autovacuum prevent wrap around run faster?

On Mon, Dec 27, 2010 at 10:53 PM, marc.hsiao wrote: > Hi ALL: > > My Database is for logs only, I almost have 30G data growth in my database. > > I Use partition table to store those data, those tables are partitioned by > time column daily. > > My data only keep for three days. > > I will dump th

[PERFORM] How to turn autovacuum prevent wrap around run faster?

Hi ALL: My Database is for logs only, I almost have 30G data growth in my database. I Use partition table to store those data, those tables are partitioned by time column daily. My data only keep for three days. I will dump those data into dump file and drop the partition table after three d