Vick Khera wrote:
On Mon, Feb 15, 2010 at 9:54 AM, Marcin Krol wrote:
I didn't add or delete many rows from that table. Quite a lot of UPDATEs are
running daily, though.
Every update is equal to insert + delete, except in certain
circumstances in 8.3 and above.
Well, it's still a
On Mon, Feb 15, 2010 at 9:54 AM, Marcin Krol wrote:
> I didn't add or delete many rows from that table. Quite a lot of UPDATEs are
> running daily, though.
Every update is equal to insert + delete, except in certain
circumstances in 8.3 and above.
--
Sent via pgsql-general mailing list (pgsql-g
Hello everyone,
Resolved, I've done:
hrs=# CLUSTER hosts_ip_idx ON hosts;
CLUSTER
hrs=#
hrs=#
hrs=# SELECT relpages * 8192 AS size_in_bytes, relname FROM pg_class
WHERE relnamespace = (SELECT oid FROM pg_namespace WHERE nspname =
'public') ORDER BY size_in_bytes DESC LIMIT 10;
size_in_bytes
Hello everyone,
I got this, first CLUSTER was hanging forever, I cancelled after half an
hour:
hrs=# CLUSTER hosts;
Cancel request sent
ERROR: canceling statement due to user request
Then I restarted postgres and get this now:
hrs=# CLUSTER hosts;
ERROR: there is no previously clustered
