pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Laszlo Nagy <gandalf@shopzeus.com>
To: mandavi <mandavi@web.de>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: queries are fast after dump->restore but slow again after some days dispite vacuum
Date: Fri, 20 Jul 2012 09:10:23 +0200
Message-ID: <5009045F.8020502@shopzeus.com> (raw)
In-Reply-To: <CAGr8ZJ917Ko_kLrfkuUam32z_KVTr8Zy34f0jvvgE+djDv2i9A@mail.gmail.com>
References: <loom.20120719T133136-384@post.gmane.org>
	<5007FFDD.5050103@dunslane.net>
	<loom.20120719T160306-28@post.gmane.org>
	<CAOR=d=0jKdsQPEduC4YFnhdGjEBVi5EZ9mFGS6b7_KL03M7kNw@mail.gmail.com>
	<CAGr8ZJ917Ko_kLrfkuUam32z_KVTr8Zy34f0jvvgE+djDv2i9A@mail.gmail.com>

>> Are you running a lot of full table updates?
> If you mean updates which are applied on every or almost every row of
> the table - yes, it happens with two rather small tables of max. 10
> 000 rows. But they are both not touched by the query with this big
> performance difference.
I'm not an expert, but would it help to change fillfactor to about 45%? 
I'm just guessing that full table updates with fillfactor=45% could 
store the rows on the same page. Maybe I'm wrong.



view thread (8+ messages)

Message-ID: <5009045F.8020502@shopzeus.com>
Permalink:  ../5009045F.8020502@shopzeus.com/
Also on:    postgresql.org/message-id/5009045F.8020502@shopzeus.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gandalf@shopzeus.com, mandavi@web.de, scott.marlowe@gmail.com
  Subject: Re: queries are fast after dump->restore but slow again after some days dispite vacuum
  In-Reply-To: <5009045F.8020502@shopzeus.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox