On 3/26/06, Ed L. <pgsql@xxxxxxxxxxxxx> wrote: > On Saturday March 25 2006 9:36 pm, Ed L. wrote: > > I have a performance riddle, hoping someone can point me in a > > helpful direction. We have a pg 8.1.2 cluster using > > Apache::Sessions and experiencing simple UPDATEs taking > > sometimes 30+ seconds to do a very simply update, no foreign > > keys, no triggers: > > > > Table "public.sessions" > > Column | Type | Modifiers > > -----------+---------------+----------- > > id | character(32) | not null > > a_session | text | > > Indexes: > > "sessions_pkey" PRIMARY KEY, btree (id) > > The table has 6800 rows over 18000 pages, and is getting a > minimum of many tens of thousands of updates per day with > queries like this: If you're updating that much, how often are you running 'analyze'? Are you running autovacuum? How often? -- Postgresql & php tutorials http://www.designmagick.com/
