[PERFORM] any way to get rid of Bitmap Heap Scan recheck?

Hi. I have the following join condition in a query "posttag inner join tag ON posttag.tagid = tag.id and tag.name = 'blah'" tag.id is PK, I have indexes on posttag.tagid and tag.name both created with all the options set to default. PG version is 8.1. The query is very slow (3 minutes on test da

Re: [PERFORM] any way to get rid of Bitmap Heap Scan recheck?

Any ideas? ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

[PERFORM] concurrent inserts into two separate tables are very slow

Hi. Running postgres 8.2 on debian. I've noticed that concurrent inserts (archiving) of large batches data into two completely unrelated tables are many times slower than the same inserts done in sequence. Is there any way to speed them up apart from buying faster HDs/ changing RAID configuration?

Re: [PERFORM] concurrent inserts into two separate tables are very slow

Scott Marlowe wrote: On Jan 5, 2008 9:00 PM, Sergei Shelukhin <[EMAIL PROTECTED]> wrote: Hi. Running postgres 8.2 on debian. I've noticed that concurrent inserts (archiving) of large batches data into two completely unrelated tables are many times slower than the same inse