Re: Using indexes for partial index builds

From: Jim Nasby <jim(at)nasby(dot)net>
To: Ants Aasma <ants(at)cybertec(dot)at>
Cc: Greg Stark <stark(at)mit(dot)edu>, Paul Norman <penorman(at)mac(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Using indexes for partial index builds
Date: 2013-03-13 23:51:28
Message-ID: 51411100.9040601@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 3/12/13 9:10 AM, Ants Aasma wrote:
> I have a feeling this is an increasingly widespread pattern with a
> proliferation of mobile devices that need syncing.

If you're doing that with timestamps you're asking for a slew of problems, not all of which can be solved by just adding some random amount of fluff to your criteria. A queue-based solution is often a more robust solution, even if it is harder to implement.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2013-03-13 23:59:09 Re: Column defaults for foreign tables (was Re: [v9.3] writable foreign tables)
Previous Message Jim Nasby 2013-03-13 22:24:54 Re: Enabling Checksums