> hi..
>
> > What! That makes no sense. A compiled kernel is different from a
> > non-compiled one? Someone compiled it once. He said he didn't make any
> > changes to the FreeBSD kernel except recompile. I will be shocked to
> > hear he sees any difference in a kernel recompile.
>
> no, wh
Good Morning All!
I'm testing moving stuff off of MS-SQL Server onto pgsql so far so good...
Thanks for everyones help.
When I run a particulare SQL select statement (with 5 tables, 5 inner joins)
my pgsql server almost always crashes.
the error I get is ...
pqReadData() -- backend closed the
"Aaron J. Seigo" wrote:
>
> hi..
>
> > What! That makes no sense. A compiled kernel is different from a
> > non-compiled one? Someone compiled it once. He said he didn't make any
> > changes to the FreeBSD kernel except recompile. I will be shocked to
> > hear he sees any difference in a ke
hi..
> What! That makes no sense. A compiled kernel is different from a
> non-compiled one? Someone compiled it once. He said he didn't make any
> changes to the FreeBSD kernel except recompile. I will be shocked to
> hear he sees any difference in a kernel recompile.
no, what i'm saying is
> one of the reasons for this is that the FreeBSD kernel was
> compiled from source and the Linux one wasn't.. redhat's stock kernels are
> "jack of all trades, masters of none" and 'optimized' for 386. heh. if you
What! That makes no sense. A compiled kernel is different from a
non-compiled o
hi...
> The speed of your disks makes a difference also. No matter how much
> cache you have you are still going to hit your disks. I would say that
> LVD SCSI is a minimum.
agreed.. we use UW SCSI (though on a RAID 5.. bit of a performance hit, but
worth it for the reliability) and see great
> First off RAM helps a LOT. 192MB RAM is not much. Look at "top"
>and keep adding it until the cache and buffer sizes are quite large.
>I would think 512MB or 1GB of RAM is what you need. The idea is
>to let the OS (Linux) cache a good partion of your database in
>RAM. Postgres has a buffer
