Re: TB-sized databases

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Trevor Talbot <quension(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: TB-sized databases
Date: 2007-11-30 10:29:43
Message-ID: 1196418583.31315.47.camel@PCD12478
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Isn't that what statement_timeout is for? Since this is entirely based
> on estimates, using arbitrary fuzzy numbers for this seems fine to me;
> precision isn't really the goal.

There's an important difference to statement_timeout: this proposal
would avoid completely taking any resources if it estimates it can't be
executed in proper time, but statement_timeout will allow a bad query to
run at least statement_timeout long...

Cheers,
Csaba.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message cluster 2007-11-30 11:16:08 Appending "LIMIT" to query drastically decreases performance
Previous Message Trevor Talbot 2007-11-30 10:15:45 Re: TB-sized databases