Re: would hw acceleration help postgres (databases in general) ?

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

In response to

Responses

Browse pgsql-hackers by date

  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;