Hi all,
I noticed the following. Given two tables, just simply articles and their
packages:
article(id int)
package( id int, article_id int, amount)
When taking the minimum package for articles given some constraint on the
article table
select
article.
Hi All,
Im testing my postgres 7.3.2 db on redhat 9.0 using osdb 0.16. I couldnot find any
docuementation for interpreting the results obtained. Im doing multiuser (10 users)
test. I've two different con figurations for postgresql.conf. In one it takes 44 mins
to finish while in other it takes
Just as a point of reference, my situation is very much like the one in this
thread:
http://archive.netbsd.se/?list=pgsql-admin&a=2004-02&mid=50891
Thanks again.
- Marcus
---(end of broadcast)---
TIP 7: don't forget to increase your free space ma
Hello all,
I have a PostgreSQL instance running on a Dell Poweredge 6450. 4 700Mhz
processors, 6 GB of Ram, 2GB Backside, 60GB Raid 10 Server. Today, it
crashed hard. At the command line (BASH), all I could get was 'bus fault' .
After rebooting, we were unable to mount the partition that
Borajetta,
> So I have a table with about 50 million entries in it, I have to do a
keyword search.
Are you using OpenFTS/TSearch2? Is your database optimized?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
Apologies in advance for the length of this post but I want to be as
thorough as possible in describing my problem to avoid too much banter
back and forth.
First off, thanks to all for your help with my index problem on my
multi-column index made up of 5 double precision columns.
Unfortunately, I
So I have a table with about 50 million entries in it, I have to do a
keyword search.
The keyword search is done on the title of the entry. For example a entry could be "This is a
title string which could be searched"
I have tried a few ways to search but I get horrible search times. So
We actually found that in the 2.4-20 kernel for RedHat there was a known
issue that was causing cached memory to not be reused and our box
started to swap also.
http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=89226
This may be what you are experiencing if your using the same kernel.
Dawn H
