From: | Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: TPC-R benchmarks |
Date: | 2003-10-03 18:04:23 |
Message-ID: | 993DBE5B4D02194382EC8DF8554A52731D7630@postoffice.waterford.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Josh,
My data directory is 3.8 GB.
I can send you flat data files and scripts to create indices, but still
it would be about 1.3 GB of data. Do you still want me to transfer data
to you? If yes, then just give me your FTP address.
Thanks.
Oleg
-----Original Message-----
From: Josh Berkus [mailto:josh(at)agliodbs(dot)com]
Sent: Friday, October 03, 2003 11:22 AM
To: Oleg Lebedev; scott.marlowe
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] TPC-R benchmarks
Oleg,
> I declared all the indexes that you suggested and ran vacuum full
> analyze. The query plan has not changed and it's still trying to use
> seqscan. I tried to disable seqscan, but the plan didn't change. Any
> other suggestions? I started explain analyze on the query, but I doubt
> it will finish any time soon.
Can I get a copy of the database so that I can tinker? I'm curious
now, plus
I want our benchmarks to look good.
I have a private FTP if that helps.
--
Josh Berkus
Aglio Database Solutions
San Francisco
*************************************
This e-mail may contain privileged or confidential material intended for the named recipient only.
If you are not the named recipient, delete this message and all attachments.
Unauthorized reviewing, copying, printing, disclosing, or otherwise using information in this e-mail is prohibited.
We reserve the right to monitor e-mail sent through our network.
*************************************
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-10-03 18:08:48 | Re: Postgres low end processing. |
Previous Message | Stef | 2003-10-03 17:52:38 | Re: Postgres low end processing. |