Re: [PERFORM] Bulk loading/merging

clip_temp.cids=clip_category.cids AND clip_temp.clip_id=clip_category.clip_id INSERT INTO clip_category (cids, clip_id, mentions) SELECT * FROM clip_temp DROP TABLE clip_temp; Best regards, ahmad fajar,

Re: [PERFORM] serious problems with vacuuming databases

maintainance like you have done. You just need to create tables for every week of data, do vacuum/analyze and regular backup. Best regards, ahmad fajar, ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PERFORM] Multiple Order By Criteria

will not suffer, and we also will advantage if the table have relationship with other table with the same fields order. We have not to make another index for that relation. Best regards, ahmad fajar. I am getting an idea of what I need to do to make this work well. I was wondering if there is more

Re: [PERFORM] Text/Varchar performance...

the search uses the index you have been created. If you do not need to index the field, you can use the text field. Because text field can store data up to 4 Gbytes. Regards, ahmad fajar -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cristian Prieto Sent

Re: [PERFORM] Query seem to slow if table have more than 200 million rows

(idx_dict3 varchar_pattern_ops) == I use this index for query ... keywords like 'blabla%', just for testing purpose Regards, ahmad fajar -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Qingqing Zhou Sent: Selasa, 27 September 2005 8:43 To: pgsql-performance

Re: [PERFORM] tsearch2 seem very slow

for postgresql data. Do you have any idea what best for postgresql, JFS or XFS? I will not try reiserfs, because there are some rumors about reiserfs stability, although reiserfs is fast enough for postgresql. And must I down grade my postgresql from version 8.0.3 to 7.4.8? Regards, ahmad fajar

[PERFORM] Query seem to slow if table have more than 200 million rows

server beat postgresql, the query about 0-4 sec to get the result. What wrong with my postgresql. wassalam, ahmad fajar

Re: [PERFORM] tsearch2 seem very slow

Hi Oleg, Thanks, I will read your documentation again, and try to understand what I miss. And about pgmanual, it is very help me. I'll take attention on that. Regards, ahmad fajar -Original Message- From: Oleg Bartunov [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 3:12 AM

Re: [PERFORM] tsearch2 seem very slow

Serial ATA 7200 RPM UltraATA/133, configure as RAID0 for postgresql data and the partition is EXT3 1x80 GB EIDE 7200 RPM configure for system and home directory and the partiton is EXT3 Did I miss something? Regards, ahmad fajar -Original Message- From: Oleg Bartunov [mailto:[EMAIL PROTECTED

[PERFORM] tsearch2 seem very slow

I have about 419804 rows in my article table. I have installed tsearch2 and its gist index correctly. My table structure is: CREATE TABLE tbarticles ( articleid int4 NOT NULL, title varchar(250), mediaid int4, datee date, content text, contentvar text, mmcol float4 NOT