hi,
select count(*) from songs;
count
---
54909
(1 row)
Time: 58.182 ms
update songs set views = 0;
UPDATE 54909
Time: 101907.837 ms
time is actually less than 10 minutes, but it is still very long :(
vacuum said>
VACUUM VERBOSE songs;
INFO: vacuuming "public.songs"
INFO: index "pk_so
Hi,
I've changed settings,
but with no effect on speed.
I try explain query with this result
for 10.000 rows > update songs set views = 0 where sid > 2 and sid < 3
Bitmap Heap Scan on songs (cost=151.59..6814.29 rows=8931 width=526) (actual
time=4.848..167.855 rows=8945 loops=1)
Re
Hi,
thank you for your reply.
Here is some aditional information:
the problem is on every tables with small and large rows too.
autovacuum is running.
relpagesreltuples
6213 54743
tables are almost write-only
Munin Graphs shows that problems is with I/O bottleneck.
I fou
Hi,
I have table with cca 60.000 rows and
when I run query as:
Update table SET column=0;
after 10 minutes i must stop query, but it still running :(
I've Postgres 8.1 with all default settings in postgres.conf
Where is the problem?
Thak you for any tips.
best regards.
Marek Fiala
--
Hi,
I'm uning postgres 8.1 at P4 2.8GHz with 2GB RAM.
(web server + database on the same server)
Please, how long takes your connectiong to postgres?
$starttimer=time()+microtime();
$dbconn = pg_connect("host=localhost port=5432 dbname=xxx user=xxx
password=xxx")
or die("Couldn't Connect"
