[PERFORM] PostgreSQL is extremely slow on Windows

Hi, I've downloaded the latest release (PostgreSQL 8.0) for windows. Installation was OK, but I have tried to restore a database. It had more than ~100.000 records. Usually I use PostgreSQL under Linux, and it used to be done under 10 minutes. Under W2k und XP it took 3 hours(!) Why is it so

Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

I used you perl script and found the error = [EMAIL PROTECTED] tmp]# perl relacl.pl DBI connect('dbname=template1;port=5432','postgres',...) failed: FATAL: IDENT authentication failed for user postgres at relacl.pl line 21 Error in connect to DBI:Pg:dbname=template1;port=5432:

Re: [PERFORM] PostgreSQL is extremely slow on Windows

On Tue, 22 Feb 2005 16:00:59 +0100, Vig, Sandor (G/FI-2) [EMAIL PROTECTED] wrote: Hi, I've downloaded the latest release (PostgreSQL 8.0) for windows. Installation was OK, but I have tried to restore a database. It had more than ~100.000 records. Usually I use PostgreSQL under Linux,

[PERFORM] is pg_autovacuum so effective ?

Hi all, I'm running since one week without use any vacuum full, I'm using ony pg_autovacuum. I expect that disk usage will reach a steady state but is not. PG engine: 7.4.5 Example: The message table is touched by pg_autvacuum at least 2 time a day: $ cat pg_autovacuum.log | grep VACUUM | grep

Re: [PERFORM] is pg_autovacuum so effective ?

Gaetano Mendola wrote: pg_class after the vacuum full for that table relfilenode | relname | relpages | reltuples -+--+--+- 18376 | messages |63307 | 1.60644e+06 pg_class before the vacuum full for that table relfilenode | relname | relpages |

Re: [PERFORM] is pg_autovacuum so effective ?

Gaetano Mendola [EMAIL PROTECTED] writes: I'm using ony pg_autovacuum. I expect that disk usage will reach a steady state but is not. PG engine: 7.4.5 One data point doesn't prove that you're not at a steady state. # vacuum full verbose messages; INFO: vacuuming public.messages INFO:

Re: [PERFORM] is pg_autovacuum so effective ?

Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: I'm using ony pg_autovacuum. I expect that disk usage will reach a steady state but is not. PG engine: 7.4.5 One data point doesn't prove that you're not at a steady state. I do a graph about my disk usage and it's a ramp since one

Re: [PERFORM] PostgreSQL is extremely slow on Windows

Magnus Hagander wrote: You can *never* get above 80 without using write cache, regardless of your OS, if you have a single disk. Why? Even with, say, a 15K RPM disk? Or the ability to fsync() multiple concurrently-committing transactions at once? -Neil ---(end of

Re: [PERFORM] is pg_autovacuum so effective ?

Gaetano Mendola [EMAIL PROTECTED] writes: Matthew T. O'Connor wrote: Well without thinking too much, I would first ask about your FSM settings? If they aren't big enought that will cause bloat. Try bumping your FSM settings and then see if you reach steady state. FSM settings are big

[PERFORM] Joins, Deletes and Indexes

I've got 2 tables defined as follows: CREATE TABLE cluster ( id int8 NOT NULL DEFAULT nextval('serial'::text), clusterid varchar(255) NOT NULL, ... CONSTRAINT pk_cluster PRIMARY KEY (id) ) CREATE TABLE sensorreport ( id int8 NOT NULL DEFAULT nextval('serial'::text), clusterid int8

[PERFORM] Inefficient Query Plans

The following query plans both result from the very same query run on different servers. They obviously differ drastically, but I don't why as one db is a slonied copy of the other with identical postgresql.conf files. Both databases are vacuum analyzed nightly. Here is the query:

[PERFORM] PostgreSQL is extremely slow on Windows

Hi, I've downloaded the latest release (PostgreSQL 8.0) for windows. Installation was OK, but I have tried to restore a database. It had more than ~100.000 records. Usually I use PostgreSQL under Linux, and it used to be done under 10 minutes. Under W2k und XP it took 3 hours(!) Why is it so

[PERFORM] Help me please !

I am running postgreSQL 8.0.1 under the Windows 2000. I want to use COPY FROM STDIN function from Java application, but it doesnt work, it throws: org.postgresql.util.PSQLException: Unknown Response Type G error. Please help me! Note: COPY FROM filename works properly.