Postgres Pro
Downloads
Home   >   mailing lists

Logfile - Mailing list pgsql-performance

From Nick Raj
Subject Logfile
Date
Msg-id BANLkTi=PrLC6jsiPSr=W4mfbnvfgX92xHA@mail.gmail.com
Whole thread Raw
List pgsql-performance
Tree view
Hi,
I am using contrib/cube code. I am building GIST index on cube data type then it leads to a very large size of log file (nearly 220 MB for only 12k records).
While creating index on geometry field with gist gives 1KB size of log file for 17 lakh records.

Can someone please tell me how to stop postgres to logged so much data in case of cube?

Thanks
Nick

pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: SORT performance - slow?
Next
From: Tomas Vondra
Date:
Subject: Re: Performance degradation of inserts when database size grows