Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Huge Data sets, simple queries
- From: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>
- To: Luke Lonergan <llonergan(at)greenplum(dot)com>
- Cc: Mike Biamonte <mike(at)dbeat(dot)com>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: Huge Data sets, simple queries
- Date: Tue, 31 Jan 2006 20:47:03 -0600
On Tue, Jan 31, 2006 at 03:19:38PM -0800, Luke Lonergan wrote: > > Well, the only problem with that is if the machine crashes for any > > reason you risk having the database corrupted (or at best losing some > > committed transactions). > > So, do you routinely turn off Linux write caching? If not, then there's no > difference. My thought was about fsync on WAL; if you're doing much writing then a good raid write cache with BBU will improve performance. -- Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
- References:
- Re: Huge Data sets, simple queries
- From: Jim C. Nasby
- Re: Huge Data sets, simple queries
- From: Luke Lonergan
- Re: Huge Data sets, simple queries
- Prev by Date: Re: Huge Data sets, simple queries
- Next by Date: Sequential scan being used despite indexes
- Previous by thread: Re: Huge Data sets, simple queries
- Next by thread: Re: Huge Data sets, simple queries
- Indexes: