Ivano Luberti wrote:
This is what I was thinking , but today I was able to look at the
processes running while a client was doing a bunc of inserts. There was
no autovacuum running and every insert was taking many seconds to e
executed.
Have you done any basic tuning of the database paramete
On Tue, Feb 2, 2010 at 1:45 PM, Ivano Luberti wrote:
> In this table and all her sisters in the other schemas, records are only
> inserted and deleted. No update
same diff. In pgsql an update equals a delete and an insert. deleted
rows use up space just like former versions from an update. If
Ok I definitely food for thought and that is what I was searching for,
as stated in my first message.
Thanks to Richard and Bill for that.
But I have a few things that still I don't understand and I think I had
not outlined enough.
>
>
>> What really worries and puzzles me is the size of the ta
In response to Ivano Luberti :
> >
> >> In only one case so far, the "code" table with 442 record has a size of
> >> 18MB. If I run an vacuum full and a reindex it shrinks to less than
> >> 100KB.
> >> If I use the software to delete the rows and reinsert the same records
> >> it explodes again to
Richard Huxton ha scritto:
> On 02/02/10 14:46, Ivano Luberti wrote:
>> Sorry to post this again, but I have seen no response at all and this is
>> strange on this list.
>> Maybe I have not properly submitted my question ?
>
> You've replied to an existing question, which means your message is
>
On 02/02/10 14:46, Ivano Luberti wrote:
Sorry to post this again, but I have seen no response at all and this is
strange on this list.
Maybe I have not properly submitted my question ?
You've replied to an existing question, which means your message is
hidden in amidst the replies to that.
Sorry to post this again, but I have seen no response at all and this is
strange on this list.
Maybe I have not properly submitted my question ?
I wish also to add another parameter: the size problem is usually
associated with the following log messages:
2010-02-02 00:00:14 GMTLOG: checkpoints a
Hello, I have a software that uses Posgtres 8.4.2 on Windows.
I have a database with data splitted into schemas, so that every schema
replicates the same set of tables.
One of the table is called "code": it has 16 columns, almos all numerics
except for a carachtervarying(1024) and two text fields.
