| From: | Andy Colson <andy(at)squeakycode(dot)net> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, Zdenek Kotala <zdenek(dot)kotala(at)gmail(dot)com>, "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM> |
| Subject: | Re: Multicolumn index corruption on 8.4 beta 2 |
| Date: | 2009-06-10 18:20:50 |
| Message-ID: | 4A2FF982.7010400@squeakycode.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Josh Berkus wrote:
> Andy,
>
>> 6) To the -hackers: I write the records and then refind them in the
>> exact same order, would it be a better test to search for records in a
>> more random order? would it make a difference? Would searching for some
>> but not all make a difference?
>
> Are you on OpenSolaris? Can you give your script to Zdenek & Jignesh to
> test in their enviroments?
>
I am not, and yes I can.
Hopefully I can attach a .tar.bz2
The bigtest.sh is the one to run (it runs all the parts). You'll need
to edit fill.pl and test.pl and set the dbname and maybe give a
username/password.
In the fill.pl there is a $max variable that's used to set the number of
records to insert. (its set to 10 million right now)
Oh, this .tar wont create a subdirectory
-Andy
| Attachment | Content-Type | Size |
|---|---|---|
| test.tar.bz2 | application/octet-stream | 2.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-06-10 18:23:09 | Re: Resolving 8.4 open items |
| Previous Message | Andrew Dunstan | 2009-06-10 18:19:43 | Re: Problem with listen_addresses = '*' on 8.4beta2 on AIX |