Re: [GENERAL] Partition Reindexing

2007-09-05 Thread Rodrigo De León
On 9/4/07, Nik <[EMAIL PROTECTED]> 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

[GENERAL] Partition Reindexing

2007-09-04 Thread Nik
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' (wit