| 1 |
On 11/5/06, Tomek Lutelmowski <tomek@×××××.pl> wrote: |
| 2 |
> Does anybody has any issues when switching to PostgreSQL 8.1 or pgpool 3.x ? |
| 3 |
> I see PostgreSQL has threading support since 8.1, could you tell how does it |
| 4 |
> affect performance? |
| 5 |
|
| 6 |
The only time I can think of multithreading being a advantage would be |
| 7 |
if you have multiple processors or multi-core chip. You should also |
| 8 |
consider the server load. If you don't process that much, I wouldn't |
| 9 |
bother starting a Crusade to change your SQL server if it isn't going |
| 10 |
to give you some worthwhile ROI. |
| 11 |
|
| 12 |
I'd have to know more about your implementation to make a definitive |
| 13 |
recommendation. However, just to restate, if you have a high-load |
| 14 |
server that also has multiple cores or multiple processors, I'd |
| 15 |
consider making use of a multi-threaded product. Otherwise? I |
| 16 |
wouldn't (personally) bother with it. |
| 17 |
|
| 18 |
-- |
| 19 |
========== GCv3.12 ========== |
| 20 |
GCS d-(++) s+: a? C++ UL+>++++ P+ |
| 21 |
L++ E--- W+(+++) N++ o? K? w--- O? M+ |
| 22 |
V? PS- PE+ Y-(--) PGP- t+++ 5? X R tv-- b+ |
| 23 |
DI+++ D+ G e* h- !r !y |
| 24 |
========= END GCv3.12 ======== |
| 25 |
-- |
| 26 |
gentoo-server@g.o mailing list |
Archives