Hi John,
Thanks. Agree, the reindexes will take forever to finish. Do you think increase
temp_buffers will help too?
Regards,
Haiming
[cid:logo_new_96ac6d31-abb9-4f10-a3b7-74542f8c4a5f111.png]
Haiming Zhang | Engineer | Redflex Group
T +61 3 9674 1868 | F +61
[cid:logo_new_96ac6d31-abb9-4f10-a3b7-74542f8c4a5f111.png]
Haiming Zhang | Engineer | Redflex Group
T +61 3 9674 1868 | F +61 3 9699 3566 | E haiming.zh...@redflex.com.au
31 Market Street, (PO Box 720), South Melbourne VIC 3205, Australia
If you are not an authorised
[cid:logo_new_96ac6d31-abb9-4f10-a3b7-74542f8c4a5f111.png]
Haiming Zhang | Engineer | Redflex Group
T +61 3 9674 1868 | F +61 3 9699 3566 | E haiming.zh...@redflex.com.au
31 Market Street, (PO Box 720), South Melbourne VIC 3205, Australia
If you are not an authorised recipient
Hi Michael,
Thank you again. It seems hard to recover, I will go the hard way (lost data).
Learned a lesson.
Regards,
Haiming
-Original Message-
From: Michael Paquier [mailto:michael.paqu...@gmail.com]
Sent: Tuesday, 7 April 2015 1:04 PM
To: Haiming Zhang
Cc: pgsql-general
/2107262657 left 375921, right 379817, next 376394, level 0,
firstright 95
2015-04-07 09:01:44 EST LOG: startup process (PID 2652) exited with exit code 1
2015-04-07 09:01:44 EST LOG: aborting startup due to startup process failure
Regards,
Haiming Zhang
Software Engineer
-Original Message-
From: Michael Paquier [mailto:michael.paqu...@gmail.com]
Sent: Tuesday, 7 April 2015 11:36 AM
To: Haiming Zhang
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres fails to start
On Tue, Apr 7, 2015 at 9:25 AM, Haiming Zhang haiming.zh...@redflex.com.au
wrote
[mailto:bladeofligh...@gmail.com]
Sent: Monday, 15 July 2013 5:26 AM
To: pgsql-general@postgresql.org; Haiming Zhang
Subject: Re: [GENERAL] Update big table
I don't believe you can use JOIN explicitly in this situation because it's an
UPDATE, but I believe you can accomplish the same effect with FROM
-Original Message-
From: Vincenzo Romano [mailto:vincenzo.rom...@notorand.it]
Sent: Sunday, 14 July 2013 9:03 PM
To: Haiming Zhang
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Update big table
2013/7/14 Haiming Zhang haiming.zh...@redflex.com.au:
Hi All,
I am using postgres 9.1
Hi All,
I am using postgres 9.1, I have a question about updating big table. Here is
the basic information of this table.
1. This table has one primary key and other 11 columns.
2. It also has a trigger that before update records, another
table got updated
issue occured.
For Server 2008, my config is:
idleConnectionTestPeriod = 60
idleMaxAge = 240
maxConnectionsPerPartition = 100
minConnectionsPerPartition = 5
partitionCount = 5
and in postgresql.conf:
max_connections = 2000
shared_buffers = 2G
others are as default.
Many thanks
Haiming Zhang
runs without any error. I don not want to change the registry manually
in the future. Would anyone please help with how to manage this?
Thanks a lot.
Haiming Zhang
Software Engineer
Redflex Traffic Systems
Tel: +61 3 9674 1868
Mob:
Email: haiming.zh...@redflex.com.aumailto:haiming.zh
11 matches
Mail list logo