[PERFORM] Hi!

Hi, I am trying install the postgresql-7.4.3 simple installation. I did ./configure command at the postgresql directory source. While the configuring proccess I receiving the follow message: checking for tar... /bin/tarchecking for strip... stripchecking whether it is possible to strip

[PERFORM] Indexing question

Hello all, I have a rather large table (~20 GB) of network logs taken over the period of a month and stored under postgres 7.3. I'm trying to create an indexing scheme so that I can do a query with a where time foo and time bar and get the results without too much waiting. With this in mind, I

Re: [PERFORM] 50 000 000 Table entries and I have to do a keyword search HELP NEEDED

Title: Message The words for the keyword can be made up of a sentace, ie 10 or more keywords to one entry. Also incase I didnt answer before, we are using TSearch2 and all tables have been fully analyzed and indexed. Any other suggestions? How long do searches take when 10 000 rows are

Re: [PERFORM] Indexing question

Stan Bielski [EMAIL PROTECTED] writes: Table public.allflow_tv_mydoom Column | Type | Modifiers +-+--- tv_s | bigint | ^^ Indexes: allflow_tv_mydoom_x btree (tv_s) standb=# explain select * from allflow_tv_mydoom where tv_s