On Thu, Jan 22, 2009 at 10:10 PM, Mark Wong wrote:
> On Thu, Jan 22, 2009 at 7:44 PM, Greg Smith wrote:
>> On Thu, 22 Jan 2009, Mark Wong wrote:
>>
>>> I'm also capturing the PostgreSQL parameters as suggested so we can
>>> see what's set in the config file, default, command line etc. It's
>>> t
Hal,
just create separate column with tsvector and create index on it.
Oleg
On Thu, 5 Feb 2009, Hal Roberts wrote:
Hi All,
I'm getting poor performance on full text searches that return lots of
entries from a table with about 7 million rows. I think the cause is
rechecking the text match o
Hi All,
I'm getting poor performance on full text searches that return lots of
entries from a table with about 7 million rows. I think the cause is
rechecking the text match on all of the returned rows, even though I'm
using a @@ query on a gin index, which the docs say should not require
On 2/5/09 4:40 AM, "Matt Burke" wrote:
Are there any reasonable choices for bigger (3+ shelf) direct-connected
RAID10 arrays, or are hideously expensive SANs the only option? I've
checked out the latest Areca controllers, but the manual available on
their website states there's a limitation of 32
On Thu, Feb 5, 2009 at 6:10 PM, Matt Burke wrote:
> Arjen van der Meijden wrote:
>
>> Afaik the Perc 5/i and /e are more or less rebranded LSI-cards (they're
>> not identical in layout etc), so it would be a bit weird if they
>> performed much less than the similar LSI's wouldn't you think?
>
> I'
On Thu, 2009-02-05 at 12:40 +, Matt Burke wrote:
> Arjen van der Meijden wrote:
>
> Are there any reasonable choices for bigger (3+ shelf) direct-connected
> RAID10 arrays, or are hideously expensive SANs the only option? I've
> checked out the latest Areca controllers, but the manual availab
Ivan Voras wrote:
I have a need to fairly often select data where the number of
occurrences of a character in the field is "x". Semantically, it's
literally "SELECT something FROM table WHERE numch('/', field)=$x".
The problem is how to do it efficiently. I see there isn't a built-in
function th
On Thu, Feb 05, 2009 at 02:31:24PM +0100, Ivan Voras wrote:
> The problem is how to do it efficiently. I see there isn't a built-in
> function that counts character occurrences so I'd have to write it
> myself. An additional constraint is that it must be implemented with
> built-in capabilities, i.
Scott Marlowe writes:
> We purhcased the Perc 5E, which dell wanted $728 for last fall with 8
> SATA disks in an MD-1000 and the performance is just terrible. No
> matter what we do the best throughput on any RAID setup was about 30
> megs/second write and 60 Megs/second read.
Is that sequent
Hi,
I have a need to fairly often select data where the number of
occurrences of a character in the field is "x". Semantically, it's
literally "SELECT something FROM table WHERE numch('/', field)=$x".
The problem is how to do it efficiently. I see there isn't a built-in
function that counts chara
Glyn Astill wrote:
> Did you try flashing the PERC with the LSI firmware?
>
> I tried flashing a PERC3/dc with LSI firmware, it worked fine but I
> saw no difference in performance so I assumed it must be somethign
> else on the board that cripples it.
No, for a few reasons:
1. I read somewhere
Matt Burke wrote:
> Arjen van der Meijden wrote:
>
>> Afaik the Perc 5/i and /e are more or less rebranded LSI-cards (they're
>> not identical in layout etc), so it would be a bit weird if they
>> performed much less than the similar LSI's wouldn't you think?
>
> I've recently had to replace a PE
--- On Thu, 5/2/09, Matt Burke wrote:
> From: Matt Burke
> Subject: Re: [PERFORM] suggestions for postgresql setup on Dell 2950 , PERC6i
> controller
> To: pgsql-performance@postgresql.org
> Date: Thursday, 5 February, 2009, 12:40 PM
> Arjen van der Meijden wrote:
>
> > Afaik the Perc 5/i
Arjen van der Meijden wrote:
> Afaik the Perc 5/i and /e are more or less rebranded LSI-cards (they're
> not identical in layout etc), so it would be a bit weird if they
> performed much less than the similar LSI's wouldn't you think?
I've recently had to replace a PERC4/DC with the exact same ca
14 matches
Mail list logo
