[GENERAL]

2006-01-26 Thread Uroš Gruber
help ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] many row updates

2006-01-26 Thread Uroš Gruber
Hi! I have table with row named rank and some other rows. I have about 900.000 rows in table and I need to update all rows with the same value of rank, so I run update table set rank = 1; The only problem is speed. I'm waiting about 30 minutes and it's still running. My system is pg8.1 with

[GENERAL] restore

2005-09-27 Thread Uroš Gruber
Hi! I have an old pgsql dir backuped and I want to know if there's any way to restore some data from this files. Any tool I can use. regards Uros ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate