Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group