Re: TB-sized databases - Mailing list pgsql-performance

From Csaba Nagy
Subject Re: TB-sized databases
Date
Msg-id 1196418583.31315.47.camel@PCD12478
Whole thread Raw
In response to Re: TB-sized databases  ("Trevor Talbot" <quension@gmail.com>)
List 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.



pgsql-performance by date:

Previous
From: "Trevor Talbot"
Date:
Subject: Re: TB-sized databases
Next
From: cluster
Date:
Subject: Appending "LIMIT" to query drastically decreases performance