SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 07:20 PM
| ||||
| ||||
 Partition Reindexing What is the effect of reindexing a partition on the inherited table? For example I have a table 'test' with partitions 'test_01_07', 'test_02_07', 'test_03_07', 'test_04_07', corresponding to data from January 2007, February 2007, and so on. I noticed that when I run a reindex on 'test_02_07' (with a large index ~3Gb) the inserts into 'test_04_07' are extremely slow eventually locking up the entire database. Is there a way I could run the reindexing/vacuuming/analyzing processes without affecting the rest of the partitions? This is on PostgreSQL 8.1.3 on Windows 2003 Advanced Server.      |
|
04-09-2008, 07:21 PM
| ||||
| ||||
| Re: Partition Reindexing On 9/4/07, Nik <XLPizza@gmail.com> wrote: > This is on PostgreSQL 8.1.3 on Windows 2003 Advanced Server. Only 8.2 or newer has CREATE INDEX CONCURRENTLY. Maybe you could schedule a maintenance window for this. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
Linear Mode
