Skip site navigation (1) Skip section navigation (2)

Re: How would you store read/unread topic status?

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Mathieu Nebra <mateo21(at)siteduzero(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: How would you store read/unread topic status?
Date: 2009-06-23 15:30:14
Message-ID: 603c8f070906230830s9402658kc2c5501e29806f60@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
>>>> Which pg version are you using?
>>
>> I should have mentionned that before sorry: PostgreSQL 8.2
>
> I definitely would consider upgrading to 8.3 - even without any config
> changes it might bring quite some improvement.
>
> But mainly it would allow you to use "asynchronous commit" - which could
> possibly increase your throughput tremendously.

HOT can potentitally help a lot for this workload, too, if the columns
being updated are not indexed.

...Robert

In response to

pgsql-performance by date

Next:From: Grzegorz JaśkiewiczDate: 2009-06-23 15:34:30
Subject: Re: How would you store read/unread topic status?
Previous:From: Andres FreundDate: 2009-06-23 15:14:07
Subject: Re: How would you store read/unread topic status?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group