On Fri, 27 Mar 2015 08:33:36 -0700
"David G. Johnston" 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 so much performance o
On Fri, Mar 27, 2015 at 3:41 AM, Vincent Veyron wrote:
> On Thu, 26 Mar 2015 00:25:09 +
> "Lavrenz, Steven M" 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 che
On Thu, 26 Mar 2015 00:25:09 +
"Lavrenz, Steven M" 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 the comm failure.
> On 26 Mar 2015, at 1:25, 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 su
On Wed, Mar 25, 2015 at 8:57 PM, Mitu Verma 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
> and because of w
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
Dat
On Wed, Mar 25, 2015 at 5: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 s
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 i
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
