Re: DB design advice - Mailing list pgsql-novice

From Toni Alfirević
Subject Re: DB design advice
Date
Msg-id C8800CE0-51C9-45B9-9C01-055424BFF2C6@gmail.com
Whole thread Raw
In response to Re: DB design advice  (Sergey Konoplev <gray.ru@gmail.com>)
Responses Re: DB design advice  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-novice
On 7. 6. 2013., at 07:39, Sergey Konoplev <gray.ru@gmail.com> wrote:

> On Thu, Jun 6, 2013 at 2:29 AM, Toni Alfirević <toni.alfirevic@gmail.com> wrote:
>> And app should allow user to search trough his logs filtered by one or more
>> tags and time interval. Here is one more constraint, since those messages
>
> Is it supposed to return all the data from this interval at once, or
> to be implemented like a kind of pagination/slider, that gets a
> limited amount of entries since the beginning of the interval, and
> then, after user requested more, it gets entries that are after the
> last one from the previous bunch, and so on?

Hi Sergey,

It will most likely return subsets of data just like you said (pagination).

But there will be a situation where all data will need to be analyzed for, let's call it', a report. On the other hands
thosereports are not that sensitive when it comes to performance. It won't be an issue if it takes a minute, two or
threeto generate it. 

pgsql-novice by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: DB design advice
Next
From: Aditya Rastogi
Date:
Subject: PostgreSQL 8.3.6 creating empty log files.