From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | dg(at)illustra(dot)com (David Gould) |
Cc: | mimo(at)interdata(dot)com(dot)pl, hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Re: [QUESTIONS] Does Storage Manager support >2GB tables?t |
Date: | 1998-03-13 02:27:12 |
Message-ID: | 199803130227.VAA02095@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> Agreed, but what you are talking about here is decomposing a query into
> it's parallel components and executing them in parallel. This is a win
> of course, but the optimizer and executor have to support it. Also, you
> start to want things like table fragmentation across devices to make this
> work. A big job. As a shortcut, you can just do some lookahead on index scans
> and do prefetch. Doesn't buy as much, but could probably be done very
> quickly.
Yes, this is what I was thinking. Could be done pretty easily, and
hence the TODO addition.
> If you have multiple threads each allocing memory at the same time, the
> allocator data structures have to be protected.
>
> > any heap data that is used locally. But it is a big problem when you
> > take a look at global variables and global data that is accessed and
> > modified in many places. This is potential source of troubles.
>
> Too right.
--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-03-13 03:03:04 | Re: vacuum... |
Previous Message | David Gould | 1998-03-13 01:53:02 | Re: [HACKERS] Re: [QUESTIONS] Does Storage Manager support >2GB tables? |