Re: [PERFORM] DELETE vs TRUNCATE explanation

2012-07-12 Thread Harold A. Giménez
Hi, I work with Daniel Farina and was the other engineer who "discovered" this, once again. That is, I got bit by it and have been running TRUNCATE on my test suites for years. On Thursday, July 12, 2012 at 12:15 PM, Jeff Janes wrote: > On Wed, Jul 11, 2012 at 3:51 PM, Daniel Farina (mailt

Re: [PERFORM] Question about clustering indexes and restores

2009-01-22 Thread Harold A . Giménez Ch .
Many thanks for your answer. I did see a comment about this in the documentation on the link I posted below. My main question remains though: Is it necessary to cluster after a restore? Thanks again! On Thu, Jan 22, 2009 at 2:58 PM, Kenneth Marshall wrote: > On Thu, Jan 22, 2009 at 02:52:12PM

[PERFORM] Question about clustering indexes and restores

2009-01-22 Thread Harold A . Giménez Ch .
Hi list, Clustering my indexes dramatically improves the query performance of many of my queries. Also, the actual clustering takes a very long time for big databases, roughly 20 hours. I have two questions about how to improve this: 1. I've tweaked maintenance_mem_max and effective_cache_size to