[PERFORM] About the relation between fragmentation of file and VACUUM

Question is about the relation between fragmentation of file and VACUUM performance. OS：RedHat Enterprise Linux AS Release 3(Taroon Update 6) Kernel 2.4.21-37.ELsmp on an i686 Filesystem Type ext3 Filesystem features: has_journal filetype needs_recovery sparse_super large_file CPU：I

Re: [PERFORM] Query is 800 times slower when running in function!

Ralph Mason <[EMAIL PROTECTED]> writes: > I have a simple query that is running inside a plpgsql function. > SELECT INTO _point_id id FROM ot2.point WHERE unit_id = _unit_id AND > time > _last_status ORDER BY time LIMIT 1; It would probably help significantly to make that be "ORDER BY unit_id, t

Re: RES: [PERFORM] pg_dump slow

At 05:13 PM 11/30/2005, Merlin Moncure wrote: > By default W2K systems often had a default TCP/IP packet size of 576B > and a tiny RWIN. Optimal for analog modems talking over noisy POTS > lines, but horrible for everything else wrong. default MTU for windows 2000 server is 1500, as was NT4. ht

[PERFORM] Query is 800 times slower when running in function!

Hi, I have a simple query that is running inside a plpgsql function. SELECT INTO _point_id id FROM ot2.point WHERE unit_id = _unit_id AND time > _last_status ORDER BY time LIMIT 1; Both _unit_id and _last_status variables in the function. the table has an index on unit_id,point When this r

Re: RES: [PERFORM] pg_dump slow

> By default W2K systems often had a default TCP/IP packet size of 576B > and a tiny RWIN. Optimal for analog modems talking over noisy POTS > lines, but horrible for everything else wrong. default MTU for windows 2000 server is 1500, as was NT4. http://support.microsoft.com/?id=140375 However t

Re: RES: [PERFORM] pg_dump slow

At 12:27 PM 11/30/2005, Richard Huxton wrote: Franklin Haut wrote: Hi, Yes, my problem is that the pg_dump takes 40 secs to complete under WinXP and 50 minutes under W2K! The same database, the same hardware!, only diferrent Operational Systems. The hardware is:Pentium4 HT 3.2 GHz 1024 MB

Re: [PERFORM] Select with grouping plan question

"Brad Might" <[EMAIL PROTECTED]> writes: > This seems to me to be an expensive plan and I'm wondering if there's a > way to improve it or a better way to do what I'm trying to do here (get > a count of distinct values for each record_id and map that value to the > entity type) entity_type_id_mappin

RES: [PERFORM] pg_dump slow

Complementing... The test was maked at the same machine ( localhost ) at Command-Prompt, no client´s connected, no concurrent processes only PostgreSQL running. In windows XP, exists much access to the processor (+- 70%) and HD (I see HD Led allways on), while in the W2K almost without activity

[PERFORM] Select with grouping plan question

This seems to me to be an expensive plan and I'm wondering if there's a way to improve it or a better way to do what I'm trying to do here (get a count of distinct values for each record_id and map that value to the entity type) entity_type_id_mapping is 56 rows volume_node_entity_data_values is

Re: RES: [PERFORM] pg_dump slow

Franklin Haut wrote: Hi, Yes, my problem is that the pg_dump takes 40 secs to complete under WinXP and 50 minutes under W2K! The same database, the same hardware!, only diferrent Operational Systems. The hardware is: Pentium4 HT 3.2 GHz 1024 Mb Memory HD 120Gb SATA There have been

Re: [PERFORM] pg_dump slow

> At 08:35 AM 11/30/2005, Franklin Haut wrote: > >Hi > > > >i´m using PostgreSQL on windows 2000, the pg_dump take around 50 minutes > >to do backup of 200Mb data ( with no compression, and 15Mb with > >compression), > > Compression is reducing the data to 15/200= 3/40= 7.5% of original size? > >

RES: [PERFORM] pg_dump slow

Hi, Yes, my problem is that the pg_dump takes 40 secs to complete under WinXP and 50 minutes under W2K! The same database, the same hardware!, only diferrent Operational Systems. The hardware is: Pentium4 HT 3.2 GHz 1024 Mb Memory HD 120Gb SATA Im has make again the test, and then real

Re: [PERFORM] pg_dump slow

At 08:35 AM 11/30/2005, Franklin Haut wrote: Hi i´m using PostgreSQL on windows 2000, the pg_dump take around 50 minutes to do backup of 200Mb data ( with no compression, and 15Mb with compression), Compression is reducing the data to 15/200= 3/40= 7.5% of original size? but in windows XP do

[PERFORM] pg_dump slow

Hi i´m using PostgreSQL on windows 2000, the pg_dump take around 50 minutes to do backup of 200Mb data ( with no compression, and 15Mb with compression), but in windows XP does not pass of 40 seconds... :( This happens with 8.1 and version 8.0, somebody passed for the same situation? It will b