Re: [GENERAL] Fast way to delete big table?

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

Re: [GENERAL] Fast way to delete big table?

[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

[GENERAL] Fast way to delete big table?

[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

Re: [GENERAL] Postgres fails to start

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

[GENERAL] Postgres fails to start

/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

Re: [GENERAL] Postgres fails to start

-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

Re: [GENERAL] Update big table

[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

Re: [GENERAL] Update big table

-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

[GENERAL] Update big table

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

[GENERAL] server process (PID 1304) was terminated by exception 0xC0000142

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

[GENERAL] PostgreSQL 9.1 product code

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