Re: [SQL] OFFSET impact on Performance???

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: <alex(at)neteconomist(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [SQL] OFFSET impact on Performance???
Date: 2005-01-26 18:49:33
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3412A75E8@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> The problem with this approach is TTFB (Time to first Byte). The
> initial query is very slow, but additional requests are fast. In most
> situations we do not want the user to have to wait a disproportionate
> amount of time for the initial query. If this is the first time using
> the system this will be the impression that will stick with them. I
> guess we could experiment and see how much extra time creating a cache
> table will take...

Have you read this?
http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html

Don't know your exact situation, but this is always worth considering in
those hard to optimize corner cases. Moving this stuff into the
application space or 'middleware' is going to be a lot of pain and
aggravation.

Merlin

Browse pgsql-performance by date

  From Date Subject
Next Message James Gunzelman 2005-01-26 18:51:14 Upgrading from from 7.4.2 to 8.0
Previous Message Alex Turner 2005-01-26 18:35:27 Re: [SQL] OFFSET impact on Performance???