From: | Jim Nasby <jim(at)nasby(dot)net> |
---|---|
To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | Hamza Bin Sohail <hsohail(at)purdue(dot)edu>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: would hw acceleration help postgres (databases in general) ? |
Date: | 2010-12-11 21:36:59 |
Message-ID: | 8F2B0A99-C327-4F79-819F-928977E4910C@nasby.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Dec 10, 2010, at 6:18 PM, Jeff Janes wrote:
> On Fri, Dec 10, 2010 at 3:09 PM, Hamza Bin Sohail <hsohail(at)purdue(dot)edu> wrote:
>>
>> Hello hackers,
>>
>> I think i'm at the right place to ask this question.
>>
>> Based on your experience and the fact that you have written the Postgres code,
>> can you tell what a rough break-down - in your opinion - is for the time the
>> database spends time just "fetching and writing " stuff to memory and the
>> actual computation.
>
> The database is a general purpose tool. Pick a bottleneck you wish to have,
> and probably someone uses it in a way that causes that bottleneck to occur.
A common bottleneck we run into is sorting of text data. Unfortunately, I doubt that a GPU would be able to help with that.
--
Jim C. Nasby, Database Architect jim(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net
From | Date | Subject | |
---|---|---|---|
Next Message | tv | 2010-12-11 21:40:57 | Re: keeping a timestamp of the last stats reset (for a db, table and function) |
Previous Message | David E. Wheeler | 2010-12-11 21:35:24 | Re: ALTER EXTENSION ... UPGRADE; |