SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 07:14 AM
| ||||
| ||||
 Disk Keeper Hi, Has any body got any experience of using Disk Keeper on Windows (On line defragmenter) on the same machine as a PostgreSQL server. We are proposing to use it but do not know if it will have any adverse effects on the overall performance of the Postgres Server. If anybody is already using this or any other defragmentation tool can you let me know. Many Thanks in advance ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend      |
|
04-09-2008, 07:14 AM
| |||
| |||
| Re: Disk Keeper On 12/1/05, David Saunders <dsaunders99@hotmail.com> wrote: > Hi, > > Has any body got any experience of using Disk Keeper on Windows (On line > defragmenter) on the same machine as a PostgreSQL server. We are proposing > to use it but do not know if it will have any adverse effects on the overall > performance of the Postgres Server. If anybody is already using this or any > other defragmentation tool can you let me know. > > Many Thanks in advance > i don't think this is a good idea... in windows autovacuum is enable by default (IIRC) and i think will be a conflict if your defragmentation tool try to work just when autovacuum decides to work too... -- regards, Jaime Casanova (DBA: DataBase Aniquilator  ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
|
04-09-2008, 07:14 AM
| ||||
| ||||
| Re: Disk Keeper If you feel the need to defragment your database files you need to set them up differently. Using partitions on your hard disks and smart use of tablespaces you can create a setup that needs no defragmenting. Besides, on larger disks defragmentation isn't even necessary. On 12/1/05, David Saunders <dsaunders99@hotmail.com> wrote: > > Hi, > > Has any body got any experience of using Disk Keeper on Windows (On line > defragmenter) on the same machine as a PostgreSQL server. We are proposing > to use it but do not know if it will have any adverse effects on the > overall > performance of the Postgres Server. If anybody is already using this or > any > other defragmentation tool can you let me know. > > Many Thanks in advance > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > |
Linear Mode
