On Thu, 26 Mar 2015 00:25:09 +
Lavrenz, Steven M slavr...@purdue.edu wrote:
I have a second table (TABLE B) with all of the object_ids and channels that
are supposed to be reporting in each day. For cases where a certain channel
does not check in, I want to add a column that indicates
On Fri, 27 Mar 2015 08:33:36 -0700
David G. Johnston david.g.johns...@gmail.com wrote:
This is a performance optimization that I would avoid at nearly any cost,
and there are likely better ways to limit the processing scope without
having to trust the a cron job runs daily
mmmhh... it's not
On Fri, Mar 27, 2015 at 3:41 AM, Vincent Veyron vv.li...@wanadoo.fr wrote:
On Thu, 26 Mar 2015 00:25:09 +
Lavrenz, Steven M slavr...@purdue.edu wrote:
I have a second table (TABLE B) with all of the object_ids and channels
that are supposed to be reporting in each day. For cases where a
On 26 Mar 2015, at 1:25, Lavrenz, Steven M slavr...@purdue.edu wrote:
Alright everyone, this is a doozy of a problem. I am new to Postgres so I
appreciate patience/understanding. I have a database of hardware objects,
each of which has several different “channels”. Once per day, these
Alright everyone, this is a doozy of a problem. I am new to Postgres so I
appreciate patience/understanding. I have a database of hardware objects, each
of which has several different channels. Once per day, these channels are
supposed to check in with a central server, generating an event log
On 03/25/2015 05:25 PM, Lavrenz, Steven M wrote:
Alright everyone, this is a doozy of a problem. I am new to Postgres so
I appreciate patience/understanding. I have a database of hardware
objects, each of which has several different “channels”. Once per day,
these channels are supposed to check
On Wed, Mar 25, 2015 at 5:25 PM, Lavrenz, Steven M slavr...@purdue.edu
wrote:
Alright everyone, this is a doozy of a problem. I am new to Postgres so
I appreciate patience/understanding. I have a database of hardware objects,
each of which has several different “channels”. Once per day, these
On Wed, Mar 25, 2015 at 8:57 PM, Mitu Verma mitu.ve...@ericsson.com wrote:
Hi,
We have a customer complaining about the time taken by one of the
application scripts while deleting older data from the log tables.
During the deletion, customer reported that he often sees the below error
Hi,
We have a customer complaining about the time taken by one of the application
scripts while deleting older data from the log tables.
During the deletion, customer reported that he often sees the below error and
because of which table size doesn’t reduce.
ERROR: canceling autovacuum task