| 1 |
On Sun, 5 Nov 2006 16:49:45 -0800, Lord Sauron wrote |
| 2 |
> On 11/5/06, Tomek Lutelmowski <tomek@×××××.pl> wrote: |
| 3 |
> > Does anybody has any issues when switching to PostgreSQL 8.1 or pgpool |
| 4 |
3.x ? |
| 5 |
> > I see PostgreSQL has threading support since 8.1, could you tell how does |
| 6 |
it |
| 7 |
> > affect performance? |
| 8 |
> |
| 9 |
> The only time I can think of multithreading being a advantage would |
| 10 |
> be if you have multiple processors or multi-core chip. You should also |
| 11 |
> consider the server load. If you don't process that much, I wouldn't |
| 12 |
> bother starting a Crusade to change your SQL server if it isn't going |
| 13 |
> to give you some worthwhile ROI. |
| 14 |
> |
| 15 |
> I'd have to know more about your implementation to make a definitive |
| 16 |
> recommendation. However, just to restate, if you have a high-load |
| 17 |
> server that also has multiple cores or multiple processors, I'd |
| 18 |
> consider making use of a multi-threaded product. Otherwise? I |
| 19 |
> wouldn't (personally) bother with it. |
| 20 |
|
| 21 |
Thank you for your reply. I have 2xdual opteron server, load is not very high |
| 22 |
(about 5 simple transactions / second, 0.2 load - I dont know how to measure |
| 23 |
exact SQL load), but if upgrade is easy (I dont use OIDs), and 8.1 is stable, |
| 24 |
I'll try. I have doubt that it is stable because it is still masked ~amd64. |
| 25 |
|
| 26 |
|
| 27 |
-- |
| 28 |
gentoo-server@g.o mailing list |
Archives