Quassel IRC Issue Tracker

03/04/2017

05:07 AM Quassel IRC Bug #1429: Backlog fetching for channels that have not had any activity at all in a long time takes an extreme amount of time when using PostgreSQL.

This, and #1431, should be fixed in my pull request here:
https://github.com/quassel/quassel/pull/273

05:07 AM Quassel IRC Bug #1431: Database: buffer.lastseenmsgid is greater than the most recent messageid actually recorded for said buffer.

This, and #1429, should be fixed in my pull request here:
https://github.com/quassel/quassel/pull/273

03/03/2017

08:34 PM Quassel IRC Bug #1431: Database: buffer.lastseenmsgid is greater than the most recent messageid actually recorded for said buffer.

Er, typo. Meant to say while working on fixing #1429.

08:33 PM Quassel IRC Bug #1431 (Resolved): Database: buffer.lastseenmsgid is greater than the most recent messageid actually recorded for said buffer.

While working on fixing #1249, I discovered that buffer.lastseenmsgid will often be set to a value higher than the mo...

03/02/2017

07:37 PM Quassel IRC Bug #1429: Backlog fetching for channels that have not had any activity at all in a long time takes an extreme amount of time when using PostgreSQL.

If a column were to be added to the buffer table, 'latestmsgid', and "AND backlog.messageid <= [lastmsgid]" is added ...

07:12 PM Quassel IRC Bug #1429: Backlog fetching for channels that have not had any activity at all in a long time takes an extreme amount of time when using PostgreSQL.

Oh, misread your question.
Yes, the regular JOIN speeds it up without the new index, but not by as much on my mach...

07:11 PM Quassel IRC Bug #1429: Backlog fetching for channels that have not had any activity at all in a long time takes an extreme amount of time when using PostgreSQL.

EgS wrote:
> Did you also test the regular JOIN without the new index? Perhaps that will already suffice, and it wou...

03/01/2017

12:03 AM Quassel IRC Bug #1429 (Resolved): Backlog fetching for channels that have not had any activity at all in a long time takes an extreme amount of time when using PostgreSQL.

My QuasselCore has a large database - right now, I have 73,778,201 rows in the backlog table. I also have a lot of bu...