X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 17B413101E7 for ; Fri, 27 Jun 2003 10:05:25 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 47982-05 for ; Fri, 27 Jun 2003 07:05:14 -0300 (ADT) Received: from email02.aon.at (WARSL402PIP7.highway.telekom.at [195.3.96.94]) by svr1.postgresql.org (Postfix) with SMTP id E08FD3101A2 for ; Fri, 27 Jun 2003 07:05:13 -0300 (ADT) Received: (qmail 105770 invoked from network); 27 Jun 2003 10:05:12 -0000 Received: from m149p026.dipool.highway.telekom.at (HELO cantor) ([62.46.8.154]) (envelope-sender ) by qmail2rs.highway.telekom.at (qmail-ldap-1.03) with SMTP for ; 27 Jun 2003 10:05:12 -0000 From: Manfred Koizar To: Andre Schubert Cc: tgl@sss.pgh.pa.us, pgsql-performance@postgresql.org Subject: Re: problem with pg_statistics Date: Fri, 27 Jun 2003 12:05:14 +0200 Message-ID: <555ofvopbsuiog6tti32natah0futga7d4@4ax.com> References: <20030626151515.5fd0faf0.andre@km3.de> <24083.1056636485@sss.pgh.pa.us> <25814.1056643432@sss.pgh.pa.us> <20030627080735.66d6bdf0.andre.schubert@km3.de> <4avnfvkjr8q7cl8ac6f01j8rddj4pjlte0@4ax.com> <20030627111058.08f71b14.andre@km3.de> In-Reply-To: <20030627111058.08f71b14.andre@km3.de> X-Mailer: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200306/187 X-Sequence-Number: 2271 On Fri, 27 Jun 2003 11:10:58 +0200, Andre Schubert wrote: >Once a month we delete the all data of the oldest month. >And after that a vacuum full verbose analyze is performed. >Could this cause reordering of the data ? I may be wrong, but I think VACUUM FULL starts taking tuples from the end of the relation and puts them into pages at the beginning until read and write position meet somewhere in the middle. This explains the bad correlation. >And should i do a cluster idx_ts tbl_traffic ? I think so. >> >#effective_cache_size = 1000 # default in 8k pages >> >> This is definitely too low. With 512MB or more I tend to set this to >> ca. 80% of available RAM. Use top and free to find hints for good >> values. >> > >Ok, i will talk with my coworker ( he is the sysadmin of our machine ) >and look if can use such amount of RAM, because there are several other >processes that are running on these machines. >But i will test and report ... effective_cache_size does not *control* resource consumption, it just *reports* it as a hint to the planner. Servus Manfred