Re: [GENERAL] random delays

2005-12-11 Thread Grzegorz Przeździecki
Welcome Simon Riggs wrote: Tune your wal settings and bgwriter to improve things, plus upgrade to 8.1 which has made leaps forward with this issue. What is best settings for that case? I have the same on 7.4 but for me it's not critical issue or big problem. I have database (size 2-3 GB) wi

Re: [GENERAL] change attnum in pg_catalog.pg_attribute

2005-04-05 Thread Grzegorz Przeździecki
dex, pg_attrdef, > pg_depend, pg_rewrite if there are any rules or views mentioning the > columns, and probably some other places I forgot. > Now understand Thanks a lot > regards, tom lane Best Regards -- Grzegorz Przeździecki www.PolskieSklepy.pl kom. +48.6

Re: [GENERAL] change attnum in pg_catalog.pg_attribute

2005-04-05 Thread Grzegorz Przeździecki
27;t work and will likely crash the backend. > Even if I will do like this and for ever?? 1. attnum will be unique and greater than 0 2. no holes in attnum numeric 3. Make change 4. restart postgresql > regards, tom lane Best Regards -- Grzegorz Przeździ