raghavendra t <raagavendra.rao@xxxxxxxxx> wrote: > I have a table with 40GB size, it has few indexes on it. What does the table look like? What indexes are there? > When i try to REINDEX on the table, Why are you doing that? > its take a long time. How long? > I tried increasing the maintenance_work_mem, but still i havnt > find a satisfying result. What run time are you expecting? > Questions > ======= > 1. What are the parameters will effect, when issuing the REINDEX > command > 2. Best possible way to increase the spead of the REINDEX It's hard to answer that without more information, like PostgreSQL version and configuration, for starters. See: http://wiki.postgresql.org/wiki/SlowQueryQuestions My best guess is that you can make them instantaneous by not running them. A good VACUUM policy should make such runs unnecessary in most cases -- at least on recent PostgreSQL versions. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
