Re: [PERFORM] Postgres log(pg_logs) have lots of message

2013-04-11 Thread Jeff Janes
On Wednesday, April 10, 2013, Nik Tek wrote: > Hi Bambi, > > Thank you the prompt reply. > > This table is very volatile, lot of inserts/updates happen on this > tables(atleast 20~30 inserts/min). > That number of inserts per minute is not all that many. I suspect that you have sessions which ar

[PERFORM] PsqL8.3

2013-04-11 Thread Thiyagarajan, Palaniappan
All, We have performance issue in Psql8.3 vacuum run. The CPU usage going 300+ and application getting slow. How do we avoid high cpu and smooth vacuum tables. Thanks in advance Palani -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subs

Re: [PERFORM] Performance ts_vector fulltext search

2013-04-11 Thread Tom Lane
Luigi Saggese writes: > I've configured 2 table like this > ... > CREATE INDEX "ix_fulltext_usp_what" ON "public"."User_Statement_Pivot" > ("to_tsvector('italian'::regconfig, ""What""::text)", > "to_tsvector('italian'::regconfig, ""What""::text)"); When I try that I get ERROR: column "to_tsvect

Re: [PERFORM] slow bitmap heap scans on pg 9.2

2013-04-11 Thread Steve Singer
On 13-04-10 07:54 PM, Steve Singer wrote: On 13-04-10 02:06 PM, Jeff Janes wrote: On Wed, Apr 10, 2013 at 6:49 AM, Steve Singer mailto:ssin...@ca.afilias.info>> wrote: I think the index recheck means your bitmap is overflowing (i.e. needing more space than work_mem) and so keeping only the p

[PERFORM] Performance ts_vector fulltext search

2013-04-11 Thread Luigi Saggese
I've configured 2 table like this CREATE TABLE "public"."User_Statement_Pivot" ( "Email" varchar(50), "UserId" varchar(50), "ShortId" varchar(50), "LastDirectJobMailSentDateTime" int8, "What" varchar(4096), "Where" varchar(4096) ) WITH (OIDS=FALSE) ; ALTER TABLE "public"."User_Statement_Pivot" OW