[GENERAL] valid use of wildcard

ct15m | unknown | unknown | unknown | unknown |269673 | unknown | CuSO4 | unknown Why does reindexdb help? How is WHERE t."startDate"='2008-10-27%' getting interpreted? Thank you. -- irene --

Re: [GENERAL] valid use of wildcard

there that I'm not sure tightening it up would be a good idea. regards, tom lane -- - Irene BargEmail: [EMAIL PROTECTED] NOAO/AURA Inc. http://www.noao.edu/noao/st

[GENERAL] vacuumdb -z do a reindex?

52.6.51(47331) idle 1186 postgres 160 90M 4808K sleep 0:00 0.00% 0.00% postgres: arcsoft metadata [local] idle [arcs...@archdbn1 ~]$ date Fri Nov 27 13:53:28 MST 2009 -- ----- Irene BargEmail: ib.

Re: [GENERAL] vacuumdb -z do a reindex?

Hi Scott, Scott Marlowe wrote: On Fri, Nov 27, 2009 at 2:17 PM, Irene Barg wrote: I've had a simple update running for over 4 hours now (see results from pg_top below). The sql is: Have you looked in pg_locks and pg_stat_activity? Yes, I did look at pg_stat_activity and did no

Re: [GENERAL] vacuumdb -z do a reindex?

Hi Scott, On Sat, Nov 28, 2009 at 3:12 PM, Irene Barg wrote: > Hi Scott, > > Scott Marlowe wrote: >> >> On Fri, Nov 27, 2009 at 2:17 PM, Irene Barg wrote: >>> >>> I've had a simple update running for over 4 hours now (see results from >>>

[GENERAL] psql 8.1.9 autovacuum safe?

said there was a bug with autovacuum in 8.1.x? Is autovacuum under 8.1.9 safe or should I wait until I upgrade? Thanks in advance. -- irene - Irene BargEmail: ib...@noao.edu NOAO/AURA Inc.

Re: [GENERAL] psql 8.1.9 autovacuum safe?

27;Donnell" writes: On 12/04/2009 17:27, Irene Barg wrote: We are running postgresql-8.1.9 and plan to upgrade to 8.2 or even 8.3 but can't just yet. I need to run analyze periodically (like hourly), Well, the current version in that branch is 8.1.17, so you're missing a *lot* of bug

[GENERAL] number of relations reported by vacuumdb -av

m pg_class; The total number of relations is 1725. So shouldn't I increase 'max_fsm_relations' from 1000 to 1725? Thank you in advance. -- irene - Irene BargEmail: ib...@noao.edu NOAO/AURA Inc.

Re: [GENERAL] number of relations reported by vacuumdb -av

never mindI found the answer in the archives.postgresql.org. The answer is 'yes' I use the sum of relations from all of the databases. So I have reset 'max_fsm_relations' from 1000 to 2000. Irene Barg wrote: Hi, I have a PostgreSQL installation with 8 database

Re: [GENERAL] number of relations reported by vacuumdb -av

r of relations reported by vacuumdb -av never mindI found the answer in the archives.postgresql.org. The answer is 'yes' I use the sum of relations from all of the databases. So I have reset 'max_fsm_relations' from 1000 to 2000. Irene Barg wrote: Hi, I have a PostgreSQL instal