On Thu, 5 Feb 2009, Mark Wong wrote:
One of the problems is that my scripts are listing the OS of the main
driver system, as opposed to the db system.
That's not a fun problem to deal with. Last time I ran into it, I ended
up writing a little PL/PerlU function that gathered all the kernel-le
Rajesh Kumar Mallah wrote:
>> I've checked out the latest Areca controllers, but the manual
>> available on their website states there's a limitation of 32 disks
>> in an array...
>
> Where exactly is there limitation of 32 drives. the datasheet of
> 1680 states support upto 128drives using en
Scott Carey wrote:
> You probably don’t want a single array with more than 32 drives anyway,
> its almost always better to start carving out chunks and using software
> raid 0 or 1 on top of that for various reasons. I wouldn’t put more than
> 16 drives in one array on any of these RAID cards, they
On Fri, Feb 6, 2009 at 2:04 AM, Matt Burke wrote:
> Scott Carey wrote:
>> You probably don't want a single array with more than 32 drives anyway,
>> its almost always better to start carving out chunks and using software
>> raid 0 or 1 on top of that for various reasons. I wouldn't put more than
>
hubert depesz lubaczewski wrote:
> 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 implem
Hi All,
I am conductingDBT2 tests on PostgreSQL. After completing the test while
analyzing and creating the results I am getting following error:
./dbt2-run-workload: line 514: 731 Terminated dbt2-client
${CLIENT_COMMAND_ARGS} -p ${PORT} -o ${CDIR} >
${CLIENT_OUTPUT_DIR}/`hostname`
It all depends at the end of a day, how crucial is that functionality
to your app ?
If very, I would add to every insert/update a trigger, that would
update info on other table(s) with stats per character.
Other option, is to write a function in C that would parse word and
chop it in C,O (characte
Matt Burke wrote:
> Scott Carey wrote:
> > You probably don?t want a single array with more than 32 drives anyway,
> > its almost always better to start carving out chunks and using software
> > raid 0 or 1 on top of that for various reasons. I wouldn?t put more than
> > 16 drives in one array on a
Glyn Astill wrote:
>> Stupid question, but why do people bother with the Perc line of
>> cards if the LSI brand is better? It seems the headache of trying
>> to get the Perc cards to perform is not worth any money saved.
>
> I think in most cases the dell cards actually cost more, people end
> u
Matt Burke wrote:
> Glyn Astill wrote:
> >> Stupid question, but why do people bother with the Perc line of
> >> cards if the LSI brand is better? It seems the headache of trying
> >> to get the Perc cards to perform is not worth any money saved.
> >
> > I think in most cases the dell cards actu
I have a table, like this:
CREATE TABLE transactions
(
transaction_id integer NOT NULL DEFAULT
nextval('transactions_seq'::regclass),
transaction_type integer NOT NULL,
transaction_client_id integer NOT NULL,
transaction_destination_id integer NOT NULL,
transaction_operator_id integer
On Fri, Feb 6, 2009 at 3:43 PM, Mario Splivalo
wrote:
> Besides PK and uq-constraint indices I have this index:
>
> CREATE INDEX transactions_idx__client_data ON transactions
> USING btree (transaction_client_id, transaction_destination_id,
> transaction_operator_id, transaction_application_id,
>
Bruce Momjian wrote:
Matt Burke wrote:
we'd have no choice other than replacing the server+shelf+disks.
I want to see just how much better a high-end Areca/Adaptec controller
is, but I just don't think I can get approval for a ?1000 card "because
some guy on the internet said the
Mario Splivalo writes:
> Besides PK and uq-constraint indices I have this index:
> CREATE INDEX transactions_idx__client_data ON transactions
> USING btree (transaction_client_id, transaction_destination_id,
> transaction_operator_id, transaction_application_id,
> transaction_time_commit)
> SE
--- On Fri, 6/2/09, Bruce Momjian wrote:
> Stupid question, but why do people bother with the Perc
> line of cards if
> the LSI brand is better? It seems the headache of trying
> to get the
> Perc cards to perform is not worth any money saved.
I think in most cases the dell cards actually cost
On Fri, Feb 6, 2009 at 11:14 AM, Tom Lane wrote:
> Mario Splivalo writes:
>> Besides PK and uq-constraint indices I have this index:
>
>> CREATE INDEX transactions_idx__client_data ON transactions
>> USING btree (transaction_client_id, transaction_destination_id,
>> transaction_operator_id, trans
Rohan Pethkar wrote:
> Hi All,
>
> I am conductingDBT2 tests on PostgreSQL. After completing the test while
> analyzing and creating the results I am getting following error:
>
> ./dbt2-run-workload: line 514: 731 Terminated dbt2-client
> ${CLIENT_COMMAND_ARGS} -p ${PORT} -o ${CDIR
On Fri, Feb 6, 2009 at 8:19 AM, Matt Burke wrote:
> Glyn Astill wrote:
>>> Stupid question, but why do people bother with the Perc line of
>>> cards if the LSI brand is better? It seems the headache of trying
>>> to get the Perc cards to perform is not worth any money saved.
>>
>> I think in most
>>> Robert Haas wrote:
> What's weird about this example is that when he sets enable_seqscan
to
> off, the bitmap index scan plan is actually substantially faster,
even
> though it in fact does scan nearly the entire heap. I don't
> understand how it can be faster to scan the index and the heap
On 4-2-2009 22:36 Scott Marlowe wrote:
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. I can ge
> 3. Pure s/w RAID10 if I can convince the PERC to let the OS see the disks
Look for JBOD mode.
PERC 6 does not have JBOD mode exposed. Dell disables the feature from the LSI
firmware in their customization.
However, I have been told that you can convince them to tell you the 'secret
hands
Hey folks,
I have few tables, that inherit from table X.
The query I perform, tries to obtain information about changes in all
tables that inherit from X,
aside from that, I have table Y that keeps another information related
to changes, but in bit different schema.
Anyway, there is one unique id
On 6-2-2009 16:27 Bruce Momjian wrote:
The experiences I have heard is that Dell looks at server hardware in
the same way they look at their consumer gear, "If I put in a cheaper
part, how much will it cost Dell to warranty replace it". Sorry, but I
don't look at my performance or downtime in th
On Fri, Feb 6, 2009 at 12:41 PM, Kevin Grittner
wrote:
Robert Haas wrote:
>> What's weird about this example is that when he sets enable_seqscan to
>> off, the bitmap index scan plan is actually substantially faster, even
>> though it in fact does scan nearly the entire heap. I don't
>> und
Just guessing here, but what values are you using for
join_collapse_limit and from_collapse_limit, and what happens if you
make them much bigger (like 100)?
...Robert
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.po
On Fri, Feb 6, 2009 at 6:15 PM, Robert Haas wrote:
> Just guessing here, but what values are you using for
> join_collapse_limit and from_collapse_limit, and what happens if you
> make them much bigger (like 100)?
both default values, afair = 8.
--
Sent via pgsql-performance mailing list (pgsql-
On Fri, Feb 6, 2009 at 6:20 PM, Grzegorz Jaśkiewicz wrote:
> On Fri, Feb 6, 2009 at 6:15 PM, Robert Haas wrote:
>> Just guessing here, but what values are you using for
>> join_collapse_limit and from_collapse_limit, and what happens if you
>> make them much bigger (like 100)?
changing them to 1
On Fri, 6 Feb 2009, Bruce Momjian wrote:
Stupid question, but why do people bother with the Perc line of cards if
the LSI brand is better?
Because when you're ordering a Dell server, all you do is click a little
box and you get a PERC card with it. There aren't that many places that
carry t
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= writes:
> so my question is, why isn't postgres use index on some tables , and
> search for the X > N individually ?
The UNION arms have to all be the same data type in order to have
restrictions pushed down through the UNION. You did not show us
the table de
On 2/6/09 9:53 AM, "Arjen van der Meijden" wrote:
When we purchased our Perc 5/e with MD1000 filled with 15 15k rpm sas
disks, my colleague actually spend some time benchmarking the PERC and a
ICP Vortex (basically a overclocked Adaptec) on those drives.
Unfortunately he doesn't have too many com
Hi
I am having some problem understanding the details of a couple of
configuration directives. Here is what I think I understand it so far:
effective_cache_size
- specifies in how many B/KB/MB will be used to cache data
between pg and the OS?
- what is actually cache
On Sat, 2009-02-07 at 01:52 +0100, Thomas Finneid wrote:
> Hi
>
> I am having some problem understanding the details of a couple of
> configuration directives. Here is what I think I understand it so far:
>
> effective_cache_size
> - specifies in how many B/KB/MB will be used to cache dat
On Wed, Feb 4, 2009 at 2:42 AM, Rohan Pethkar wrote:
> Hi All,
>
> I am trying to conduct DBT2 test for PostgreSQL. I am getting following
> errors when I run client and driver separately(Instead of running
> dbt2-run-workload script). I am also attaching exact error log file for the
> same.
>
> t
On Fri, Feb 6, 2009 at 3:46 AM, Richard Huxton wrote:
> Rohan Pethkar wrote:
>> Hi All,
>>
>> I am conductingDBT2 tests on PostgreSQL. After completing the test while
>> analyzing and creating the results I am getting following error:
>>
>> ./dbt2-run-workload: line 514: 731 Terminated
34 matches
Mail list logo
