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
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 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
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 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
=?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 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
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, 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-
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 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
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
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
> 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
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
>>> 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 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
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
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
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
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,
>
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
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
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
--- 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
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
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
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
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`
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
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
>
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
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
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
34 matches
Mail list logo
