On Fri, 27 Feb 2004, Shridhar Daithankar wrote:
> Dror Matalon wrote:
>
> > Let me try and say it again. I know that setting effective_cache_size
> > doesn't affect the OS' cache. I know it just gives Postgres the *idea*
> > of how much cache the OS is using. I know that. I also know that a
> > c
Hi,
what is the most performant way to select for example the first 99 rows of a table and insert them into another table...
at the moment i do this:
for userrecord in select * from table where account_id = a_account_id and counter_id = userrecord.counter_id and visitortable_id between a_minid a
I guess the thing to do is to move this topic over to a freebsd list
where we can get more definitive answers on how disk caching is handled.
I asked here since I know that FreeBsd is often recommended,
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html#
as a good platform for postgres, a
On Friday 27 February 2004 16:52, [EMAIL PROTECTED] wrote:
*please* don't post HTML-only messages.
what is the most performant way to select for
> example the first 99 rows of a table and insert them into another
> table...at the moment i do this:
> for userrecord in select *
> from table where
