On 24 Srpen 2011, 21:41, Merlin Moncure wrote: > On Wed, Aug 24, 2011 at 2:32 PM, Tomas Vondra <tv@xxxxxxxx> wrote: >> On 24 Srpen 2011, 20:48, gnuoytr@xxxxxxx wrote: >>> Also, given that PG is *nix centric and support for TRIM is win >>> centric, >>> having that makes a big difference in performance. >> >> Windows specific? What do you mean? TRIM is a low-level way to tell the >> drive 'this block is empty and may be used for something else' - it's >> just >> another command sent to the drive. It has to be supported by the >> filesystem, though (e.g. ext4/btrfs support it). > > Well, it's a fair point that TRIM support is probably more widespread > on windows. AFAIK the only versions that supports it natively are Windows 7 and Windows Server 2008 R2 - with other versions you're stuck with command-line tools equal to wiper.sh or hdparm. So I don't see a significant difference here - with a reasonably new systems (at least kernel 2.6.33), the support is about the same. Obviously there more machines with Windows, especially in the field of desktop/laptop, but that does not make the TRIM Windows-specific I guess. Most of them runs old versions (without TRIM support) anyway. Tomas -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
