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

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

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Scott Carey <scott(at)richrelevance(dot)com>
Cc: Mathieu Nebra <mateo21(at)siteduzero(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How would you store read/unread topic status?
Date: 2009-06-23 19:44:31
Message-ID: 407d949e0906231244t5ed760d9ye3c8f9431fc4c20@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
All the other comments are accurate, though it does seem like
something the database ought to be able to handle.

The other thing which hasn't been mentioned is that you have a lot of
indexes. Updates require maintaining all those indexes. Are all of
these indexes really necessary? Do you have routine queries which look
up users based on their flags? Or all all your oltp transactions for
specific userids in which case you probably just need the index on
userid.

You'll probably find 8.3 helps this workload more than any tuning you
can do in the database though. Especially if you can reduce the number
of indexes and avoid an index on any flags that are being updated.

In response to

Responses

pgsql-performance by date

Next:From: Mathieu NebraDate: 2009-06-23 20:04:15
Subject: Re: How would you store read/unread topic status?
Previous:From: Mike IvanovDate: 2009-06-23 19:39:55
Subject: Implications of having large number of users

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