Michael Teter said:
> I've used PostgreSQL in the past on a small project,
> and I thought it was great.
> Now I'm trying to evaluate it as a possible
> replacement for MS SQL Server.
[ ... ]
What version of PostgreSQL are you using?
Have you made any changes to the default configuration parameters? If not,
that's probably the first thing to look at. Several settings (e.g.
shared_buffers) are set to very conservative values by default. You can
also consider trading some reliability for better performance by disabling
For more info on configuration, see:
Another low-hanging fruit is kernel configuration. For example, what OS
and kernel are you using? Have you enabled DMA? What filesystem are you
In response to
pgsql-performance by date
|Next:||From: Minghann Ho||Date: 2003-01-01 03:32:10|
|Subject: alter table TBL add constraint TBL_FK foreign key ... very slow|
|Previous:||From: Michael Teter||Date: 2002-12-31 22:14:34|
|Subject: preliminary testing, two very slow situations...|