On Wed, Jun 01, 2011 at 04:56:12PM +, Campbell, Lance wrote:
> Postgresql: 8.4.x
> How do you add a timestamp to the logs. Currently I see:
>
> ERROR: {some error message}
> STATEMENT: {the sql statement}
>
> Ideally I would like to have the timestamp in front of the statements.
>
> Thanks,
Postgresql: 8.4.x
How do you add a timestamp to the logs. Currently I see:
ERROR: {some error message}
STATEMENT: {the sql statement}
Ideally I would like to have the timestamp in front of the statements.
Thanks,
Lance Campbell
Software Architect/Project Manager/DBA
Web Services at Public Affa
Glyn Astill wrote:
> Does anyone know of any tricks to replace primary key indexes
> without using reindex? Or any other method that will not lock the
> table for an extended amount of time on 8.4?
>
> I've got a bloated primary key index on a table and I'd like to
> try and clean it up without
On Wed, Jun 01, 2011 at 06:47:51AM -0400, Greg Smith wrote:
> Ray Stell wrote:
>> I want to do OS patching on prod and hot standby. What is the advised
>> procedure for maintenance on the two systems? I would think patching
>> the standby should come first in case it blows something up. Oracle ha
Hi Guys,
Does anyone know of any tricks to replace primary key indexes without using
reindex? Or any other method that will not lock the table for an extended
amount of time on 8.4?
I've got a bloated primary key index on a table and I'd like to try and clean
it up without downtime.
A quick s
Ray Stell wrote:
I want to do OS patching on prod and hot standby. What is the advised
procedure for maintenance on the two systems? I would think patching
the standby should come first in case it blows something up. Oracle has
a defer switch you can throw on prod to tell it to relax on log shi
On 06/01/2011 02:07 AM, Jenish wrote:
select * from Round_Action where action_id =5 limit 100 →
execution time 80 sec
select * from Round_Action_CH1 action_id =5 limit 100 → execution
time 0.1 sec
First off: each of the child tables needs to have the index created on
them. That
