pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedIndex Anding
5+ messages / 3 participants
[nested] [flat]
* Index Anding
@ 2007-01-31 14:56 Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>
2007-01-31 15:52 ` Re: Index Anding Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 1 reply; 5+ messages in thread
From: Hiltibidal, Robert @ 2007-01-31 14:56 UTC (permalink / raw)
To: Shoaib Mir <shoaibmir@gmail.com>; Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>; +Cc: Joe <dev@freedomcircle.net>; Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-sql
Good Morning
I am considering postgres for a project I am currently using DB2 for.
The database is a 200 gb database on db2. The os is AIX 5.2 on a p5
series box with 2 processors and 7 gb ram. I have 300 gb in local scsi
mirrored and 300 gb of shark disk raid5.
The database is primarily an olap database we use for log analytics. DB2
does not seem to be olap friendly.
My questions are:
Does postgres provide for index anding?
In DB2 index anding is set up using a runstats command. If postgres
allows index anding is index anding set up with a similar runstats
command?
How does postgres handle tablespaces? I currently have my indexes going
to one table space with my data going to a different table space. Is
this possible in postgres?
Does postgres provide 64 bit support? If so is there a precompiled 64
bit version for AIX? I have the 32 bit GCC and can compile 32 bit. 64
bit GCC I have not gotten stabilized. (I cold use a tip in that
direction if anyone lese has experienced similar issues)
Those are the three big ones. I'll hold off on the other questions for
now.
Thanks!
-Rob
PRIVILEGED AND CONFIDENTIAL
This email transmission contains privileged and confidential information intended only for the use of the individual or entity named above. If the reader of the email is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any use, dissemination or copying of this email transmission is strictly prohibited by the sender. If you have received this transmission in error, please delete the email and immediately notify the sender via the email return address or mailto:postmaster@argushealth.com. Thank you.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Index Anding
2007-01-31 14:56 Index Anding Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>
@ 2007-01-31 15:52 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-02-01 22:45 ` Re: Index Anding Chris Browne <cbbrowne@acm.org>
0 siblings, 1 reply; 5+ messages in thread
From: Andrew Sullivan @ 2007-01-31 15:52 UTC (permalink / raw)
To: Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>; pgsql-sql
You probably want to take these questions to the -general list, or
-admin, in future. That said. . .
On Wed, Jan 31, 2007 at 08:56:21AM -0600, Hiltibidal, Robert wrote:
>
> Does postgres provide for index anding?
Yes. See
<http://www.postgresql.org/docs/8.2/static/indexes-bitmap-scans.html;.
You don't need to do anything special.
> How does postgres handle tablespaces? I currently have my indexes going
> to one table space with my data going to a different table space. Is
> this possible in postgres?
Yes. See
<http://www.postgresql.org/docs/8.2/static/manage-ag-tablespaces.html;
> Does postgres provide 64 bit support? If so is there a precompiled 64
> bit version for AIX? I have the 32 bit GCC and can compile 32 bit. 64
> bit GCC I have not gotten stabilized. (I cold use a tip in that
> direction if anyone lese has experienced similar issues)
I know we've managed to get it to work using gcc, but I haven't had
to do it in a while (ask on -general or -admin, I suggest). More
important is to make sure you tell the compiler to use all the
memory. For reasons that are completely beyond my ken, AIX imposes a
memory limitation on every program at compile time. There are some
hints about this in the FAQ_AIX.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Index Anding
2007-01-31 14:56 Index Anding Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>
2007-01-31 15:52 ` Re: Index Anding Andrew Sullivan <ajs@crankycanuck.ca>
@ 2007-02-01 22:45 ` Chris Browne <cbbrowne@acm.org>
0 siblings, 0 replies; 5+ messages in thread
From: Chris Browne @ 2007-02-01 22:45 UTC (permalink / raw)
To: pgsql-sql
ajs@crankycanuck.ca (Andrew Sullivan) writes:
>> Does postgres provide 64 bit support? If so is there a precompiled 64
>> bit version for AIX? I have the 32 bit GCC and can compile 32 bit. 64
>> bit GCC I have not gotten stabilized. (I cold use a tip in that
>> direction if anyone lese has experienced similar issues)
>
> I know we've managed to get it to work using gcc, but I haven't had
> to do it in a while (ask on -general or -admin, I suggest). More
> important is to make sure you tell the compiler to use all the
> memory. For reasons that are completely beyond my ken, AIX imposes
> a memory limitation on every program at compile time. There are
> some hints about this in the FAQ_AIX.
Here's the environment data submitted to ./configure for a recent build of 8.1.5:
pgdba@ydb1 $ ./pg_config --configure '--prefix=/where/I/stow/it '--enable-thread-safety' '--enable-debug' '--with-libraries=/opt/freeware/lib' '--with-includes=/opt/freeware/include' 'CC=gcc -maix64' 'LDFLAGS=-Wl,-bmaxdata:0x80000000,-bbigtoc'
Note that you also need to export:
export OBJECT_MODE=64
And you need to make sure that you are using the AIX ld, and not GNU ld...
For version 7.4, it was considerably fiddlier to do a build. For 8.2,
it is neither overly baroque nor overly unpleasant, which I consider a
direct result of the combination of Seneca Cunningham's reports to
-hackers/-ports as well as BuildFarm runs...
--
(reverse (concatenate 'string "ofni.sesabatadxunil" "@" "enworbbc"))
http://cbbrowne.com/info/finances.html
Rules of the Evil Overlord #30. "All bumbling conjurers, clumsy
squires, no-talent bards, and cowardly thieves in the land will be
preemptively put to death. My foes will surely give up and abandon
their quest if they have no source of comic relief."
<http://www.eviloverlord.com/;
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Index Anding
@ 2007-01-31 16:39 Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>
0 siblings, 0 replies; 5+ messages in thread
From: Hiltibidal, Robert @ 2007-01-31 16:39 UTC (permalink / raw)
To: Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-sql
This is excellent information
Thank you!
-----Original Message-----
From: Andrew Sullivan [mailto:ajs@crankycanuck.ca]
Sent: Wednesday, January 31, 2007 9:53 AM
To: Hiltibidal, Robert; pgsql-sql@postgresql.org
Subject: Re: Index Anding
You probably want to take these questions to the -general list, or
-admin, in future. That said. . .
On Wed, Jan 31, 2007 at 08:56:21AM -0600, Hiltibidal, Robert wrote:
>
> Does postgres provide for index anding?
Yes. See
<http://www.postgresql.org/docs/8.2/static/indexes-bitmap-scans.html;.
You don't need to do anything special.
> How does postgres handle tablespaces? I currently have my indexes
going
> to one table space with my data going to a different table space. Is
> this possible in postgres?
Yes. See
<http://www.postgresql.org/docs/8.2/static/manage-ag-tablespaces.html;
> Does postgres provide 64 bit support? If so is there a precompiled 64
> bit version for AIX? I have the 32 bit GCC and can compile 32 bit. 64
> bit GCC I have not gotten stabilized. (I cold use a tip in that
> direction if anyone lese has experienced similar issues)
I know we've managed to get it to work using gcc, but I haven't had
to do it in a while (ask on -general or -admin, I suggest). More
important is to make sure you tell the compiler to use all the
memory. For reasons that are completely beyond my ken, AIX imposes a
memory limitation on every program at compile time. There are some
hints about this in the FAQ_AIX.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
When my information changes, I alter my conclusions. What do you do
sir?
--attr. John Maynard Keynes
PRIVILEGED AND CONFIDENTIAL
This email transmission contains privileged and confidential information intended only for the use of the individual or entity named above. If the reader of the email is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any use, dissemination or copying of this email transmission is strictly prohibited by the sender. If you have received this transmission in error, please delete the email and immediately notify the sender via the email return address or mailto:postmaster@argushealth.com. Thank you.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Index Anding
@ 2007-02-01 23:13 Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>
0 siblings, 0 replies; 5+ messages in thread
From: Hiltibidal, Robert @ 2007-02-01 23:13 UTC (permalink / raw)
To: pgsql-sql
I will investigate this.
Our gcc is only able to compile 32 bit. I think I will have to see if I
can get/compile a 64 bit gcc
I appreciate the help!
-R
-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Chris Browne
Sent: Thursday, February 01, 2007 4:45 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Index Anding
ajs@crankycanuck.ca (Andrew Sullivan) writes:
>> Does postgres provide 64 bit support? If so is there a precompiled 64
>> bit version for AIX? I have the 32 bit GCC and can compile 32 bit. 64
>> bit GCC I have not gotten stabilized. (I cold use a tip in that
>> direction if anyone lese has experienced similar issues)
>
> I know we've managed to get it to work using gcc, but I haven't had
> to do it in a while (ask on -general or -admin, I suggest). More
> important is to make sure you tell the compiler to use all the
> memory. For reasons that are completely beyond my ken, AIX imposes
> a memory limitation on every program at compile time. There are
> some hints about this in the FAQ_AIX.
Here's the environment data submitted to ./configure for a recent build
of 8.1.5:
pgdba@ydb1 $ ./pg_config --configure '--prefix=/where/I/stow/it
'--enable-thread-safety' '--enable-debug'
'--with-libraries=/opt/freeware/lib'
'--with-includes=/opt/freeware/include' 'CC=gcc -maix64'
'LDFLAGS=-Wl,-bmaxdata:0x80000000,-bbigtoc'
Note that you also need to export:
export OBJECT_MODE=64
And you need to make sure that you are using the AIX ld, and not GNU
ld...
For version 7.4, it was considerably fiddlier to do a build. For 8.2,
it is neither overly baroque nor overly unpleasant, which I consider a
direct result of the combination of Seneca Cunningham's reports to
-hackers/-ports as well as BuildFarm runs...
--
(reverse (concatenate 'string "ofni.sesabatadxunil" "@" "enworbbc"))
http://cbbrowne.com/info/finances.html
Rules of the Evil Overlord #30. "All bumbling conjurers, clumsy
squires, no-talent bards, and cowardly thieves in the land will be
preemptively put to death. My foes will surely give up and abandon
their quest if they have no source of comic relief."
<http://www.eviloverlord.com/;
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
PRIVILEGED AND CONFIDENTIAL
This email transmission contains privileged and confidential information intended only for the use of the individual or entity named above. If the reader of the email is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any use, dissemination or copying of this email transmission is strictly prohibited by the sender. If you have received this transmission in error, please delete the email and immediately notify the sender via the email return address or mailto:postmaster@argushealth.com. Thank you.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2007-02-01 23:13 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-31 14:56 Index Anding Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>
2007-01-31 15:52 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-02-01 22:45 ` Chris Browne <cbbrowne@acm.org>
2007-01-31 16:39 Re: Index Anding Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>
2007-02-01 23:13 Re: Index Anding Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox