Re: Optimize query for listing un-read messages

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimize query for listing un-read messages
Date: 2014-05-01 19:39:36
Message-ID: OfficeNetEmail.27.eb2fd548b278ed75.145b94b1c1a@prod2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

På torsdag 01. mai 2014 kl. 21:30:39, skrev Pavel Stehule <
pavel(dot)stehule(at)gmail(dot)com <mailto:pavel(dot)stehule(at)gmail(dot)com>>: Hello [snip]   I had
a perfect success on similar use case with descent ordered partial index

http://www.postgresql.org/docs/9.3/interactive/sql-createindex.html
<http://www.postgresql.org/docs/9.3/interactive/sql-createindex.html>   I'm not
getting good performance. Are you able to craft an example using my schema and
partial index?   Thanks.   -- Andreas Jospeh Krogh CTO / Partner - Visena AS
Mobile: +47 909 56 963 andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com> <https://www.visena.com>  

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pavel Stehule 2014-05-01 19:53:32 Re: Optimize query for listing un-read messages
Previous Message Pavel Stehule 2014-05-01 19:30:39 Re: Optimize query for listing un-read messages